chart color, alternate in rows

[#1]

i want to fill table chart with alternate color in rows.

row1 - green

row2- blue

row3- green

row4- blue

i have enable the setting from user preferences  - > design -> always show design menu

in custom format cell - background color i expression is

if(mod(RowNo(total),2)=0,green(),blue())

but it is not working

[#2]

i guess

in color tab u have  clor appreance   1-6  change there based on ur colour requirment

[#3]

i think it is for bar chart

[its_anandrjs · Accepted solution]

Hi.

In the dimension EMPNO click on  ( + ) and in Background write expression

=if(mod(RowNo(total),2)=0,green(),blue())

and in Text Color write expression

=if(mod(RowNo(total),2)=0,White(),White())

In your app you can find here

Regards

Anand

[#5]

Hi,

try this in the back ground colour

if(mod(RowNo(),2)=0,green(),blue())

[simenkg]

In your expression and dimension tabs. Expand the dimension and expression by pressing the [+] next to it. Under Background Color or Text Color, insert your expression:

if(mod(RowNo(total),2)=0,green(),blue())

[jagan]

Hi,

Try like this

Properties->Style->Current Style -> Basic

Stripes every 1 Rows

Regards,

JagaN

[anbu1984]

Check this app

[#9]

and how we can change dimension, expression label background color ??????????

[its_anandrjs]

Hi,

For this you have to use Custom Format Cell to check it is enable or not go to settings >> user preference >> Design >> check Always Show design Menu selected or deselected if deselect then select it. And this option Custom Format Cell is view-able by right click on the dimension and expression label.

Regards

Anand