Background Color Pivot chart (if one dimension on top)

[richters]

Hi all,

I created a pivot chart and want to highlight every second row. So I gave every formula and dimension a background formula as followed:

=if(mod(rowno(),2)=0,LightGray(80))

Is it possible to give the cells in red a background color?

Thanks a lot!

[richters]

Anyone got an idea?

[sunny_talwar]

Have you made sure to use the same expression on your second dimension (Zuverlegung) also?

[richters]

Yes, everywhere the same expression. Are you able to create a simple pivot chart where one dimension is on top and to set a backgroundcolor like this?

[sunny_talwar]

I will give it a try now. Give me few minutes

[sunny_talwar]

I am unable to replicate the sample image you have shown or I should it say, it would take some effort to create what you have. Would you be able to share a sample to test it out?

[Qrishna]

Is this what you wanted?

see attached.

make sure your values in cells are not nulls.

If you have any nulls, you cannot see the color in that cell(i anticipate.)

[sunny_talwar]

Need color on the dimension also (not just the expression)

[richters]

Here you are

[richters]

No, I want to color the complete row (my problem in your case are the cells under the "C". see attached