Color change for Column Chart

[John]

Hi Everyone
I'm using a column chart, always 4 columns.
Is it possible to have each column change color automatically based on
criteria >Below 7 = Green

Between 7 and 9.9 = Orange
10 and above = Red

TIA
John

 

[John]

See attached Screen shot sample.
http://cjoint.com/?fev2shbXLa

 

[Peter T]

From Jon Peltier's main page

http://peltiertech.com/

search "conditional" without the quotes. The Simple conditional column chart
looks like what you're after.

Regards,
Peter T

 

[John]

Hi Peter
I will have a look at it, thank you.
Regards
John

 

[John]

Hi Peter
I got it working, Thanks again
John

From Jon Peltier's main page

http://peltiertech.com/

search "conditional" without the quotes. The Simple conditional column chart
looks like what you're after.

Regards,
Peter T