Color change for Column Chart

John · May 4, 2010

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 · May 4, 2010

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

Peter T · May 4, 2010

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 · May 4, 2010

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

John · May 5, 2010

Hi Peter
I got it working, Thanks again
John

Peter T said:
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