Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
Is it possible to fix my background color?
Sometimes I have the same color in cells, because it skips cells without data.
Please see my files.
regards,
on the chart, right click and then choose custom format cell
select a row and set the background color you like
select the below (above) row and set to another background color
Go to Style and select and style..
Also select Stripes every 1 rows
Nothing changed
Actually qv skips the format for empty cells.
Setting the presentation panel without "Supress Zero Values" and with "Populate Missing Cells" helps a little but, in many cases, doesn't solve the problem.
I usually create zero values in script or use NumSum(Sum(...)) in the chart expressions so you always have data in every cells.
Regards,
Fernando
I think Manish is right; why you say nothing changed?
comment your background color expression, follow Manish post, .....
or I'm missing someting?
Hi ,
I could see a condition on expression background color and it is the reason
If(Even(RowNo()), rgb(220,220,220), rgb(238,233,233))
By fixing it you can get rid of the cell color.
Thanks,
Chiru
Please see my screen shot
please see attachment
regards
You need to remove background color expression under both dimensions and expression
I resolved it. Thanks, But I'd like make colours of cells a bit darker.
Because brightness of my computer is high and I couldn't see them.