Hi,
I am trying to create column chart from the table like this:
Period1 Period2 Period3
X 10 15 20
further I have constant Y = 16
I would like to create colored column chart, where used filling color is based on the following condition:
If value of PeriodX < Y than display PeriodX column in red otherwise green, X =1..3 .
In my example I would get three columns - 1st and 2nd red, 3rd would be green
I would need something like alerts but for charts
Any idea how to do that, is it possible?
Thanks,
Petr
I am trying to create column chart from the table like this:
Period1 Period2 Period3
X 10 15 20
further I have constant Y = 16
I would like to create colored column chart, where used filling color is based on the following condition:
If value of PeriodX < Y than display PeriodX column in red otherwise green, X =1..3 .
In my example I would get three columns - 1st and 2nd red, 3rd would be green
I would need something like alerts but for charts
Any idea how to do that, is it possible?
Thanks,
Petr