Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have these 2 tables below
Now I want to create a pivot table and transpose the date so it looks something like this:
question is how do I identify the null cells and change it's background color.
It's getting the not nul bit but not working for missing values
Try changing the null values to 'null' string values:
Set NullValue='null';
MyTable:
LOAD stuff FROM somewhere;
Hi Gysbert,
Sorry edited my question just now.
Regards,
Check this?
Expression
=If(count(NoOrder)>0, count(NoOrder), '-')
BG Color
=If(count(NoOrder)>0, RGB(0,0,255), RGB(255,0,0))
You can't give cells without a value a background color using the Background Color setting. That's why you need to replace null values with real values.
Well, not quite true. You could give the entire table a background color and then give the cells that do have a value a different color.
Hi!
Here is one click solution :
Open Chart properties,
Go to Presentation tab,
Uncheck Suppress Zero-Values
Apply
Best Regards!