Highlight a row in a pivot table chart

[#1]

Dear Experts,

Is there a way to highlight a row in a pivot table chart so it will be easier to read the data?

Thank You

[Gysbert_Wassenaar]

Yes, click on the + sign in front of the expression on the Expressions tab. Select Background Color and enter an expression to calculate the color. For example =if( ...some...condition..., lightgreen(), lightred()). Do the same as for the dimensions on the Dimensions tab.

[sunny_talwar]

You can use the following if statement under the Background Color expression

=If(Mod(RowNo(), 2) = 0, RGB(159,159,159))

Output:

HTH

Best,

S

[#4]

Thank you for your replies but what I mean is the user if he can highlight when reading a report like in excel if we click on the row number it highlights. Just to know which row the user is reading.

[sunny_talwar]

That is something I don't know and would love to know if it is possible. I will let gwassenaar answer you on this.

Best,

S

[awhitfield]

Could the user not simply click on 'b' ?

[#7]

What will happen when the user click "b"?

What is "b"/

[awhitfield]

See the example screen shot from the earlier post..

[#9]

Can you please explain the formula:

=If(Mod(RowNo(), 2) = 0, RGB(159,159,159))

[#10]

I did not understand the formula =If(Mod(RowNo(), 2) = 0, RGB(159,159,159)) and how to use it.