Formating based on chart row number

[martynlloyd]

Hi,

Is there a variable for the row in a pivot or straight table chart?

I want to assign a different background colour to the first six rows of a chart.

Note: it is not possible for me to do this by comparing a field in the chart - i know how to do that...

best regards,

Marty.

[sunny_talwar]

You can use RowNo() function. I would first create an expression =RowNo() and see what values it assigns to each row and then use it in my Background color expression accordingly.

HTH

Best,

Sunny

[sunilkumarqv]

Yes

[awhitfield]

Hi Martyn,

Add =If(RowNo()<=6,LightRed())

to each dimension and expression in the 'Background Colour'

HTH

Andy