See what Jon has to say
http://peltiertech.com/Excel/Charts/...nalChart1.html
http://peltiertech.com/Excel/Charts/...nalChart2.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Annie1904" wrote in message
...
How can we auto colour columns according to their value? For example, the
value is 3.5, then the col turns green, if <2.5 it turns red. Similar to
cell changes and conditional formatting, I suppose.