Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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.
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
Could the user not simply click on 'b' ?
What will happen when the user click "b"?
What is "b"/
See the example screen shot from the earlier post..
Can you please explain the formula:
=If(Mod(RowNo(), 2) = 0, RGB(159,159,159))
I did not understand the formula =If(Mod(RowNo(), 2) = 0, RGB(159,159,159)) and how to use it.