Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all experts,
I try to format line colors (background colors) in expressions for a line chart. I have also a change button to a pivot table.
Now, when I change from line chart to pivort table, I have the background colors and this is not well readable.
For that I try to get a if-condition in the background color expression.
For Example:
if <type of chart> = <pivot>, rgb(255,255,255), rgb(0,255,0)
--> if type = pivot, background white, background green
Do somebody know how i can read out the type of chart?
Thanks in advance
Zeynel
Hi,
Simple create a variable and use that variable in your button to set its value to say 1 in case of pivot and 0 in case of line..
then you can write: if(variable = 0,green(),white())
HTH
sushil
Hi Sushil,
thank you for the fast feedback. But how can I can I read in a variable
if the the type is a pivot or line chart? What is the syntax or code for this reading?
Because my fast change button is integrated a button in the caption of a chart