can any one send me expression attributes in a chart expression

[#1]

Hi all,

Greetimg for the day,

can any one send me expression attributes in a chart expression.

Thanks,

Venkat

[Anonymous]

Venkat,

Edit color with:

=if(condition=1, RGB(255,0,0), RGB(0,255,0))

Edit line type with:

='<s2>'

decide if show values with:

=if(condition=1, 1,0)

Hope it helps.

Marc.

[datanibbler]

Hi Venkat,

can you try to be a bit more precise? What exactly do you want to do?

The expression attributes are on the "formulas" tab, when you click on the little + to expand.

There is something about them in the help_file, though it's not too much.

Best regards,

DataNibbler

[#4]

Hi DATANIBBLER,

i need to give colors to my pivot tables cells diffrent colors for each row based on dimension

can you help me on this .

Venkat

[datanibbler]

Hi,

I don't do much work with pivot_tables - but I guess it works like it does in any other type of chart:

You have to expand as I said, click into the edit_field for "background_colour" and enter an IF_formula there, depending on your dimension - so it would be sth like

>> = IF([dimension] = 'X', BLUE(), RED()) <<

HTH

Best regards,

DataNibbler