Auto Chart Colour Change

[LEVICC01]

Hi,

I have approximately 50 mini charts on a page, each linked to the cell behind them.

Each has an axis scale from 0-10.
I would like the chart to automatically change colour based on the content behind the cell. I.e If the cell is between 0-3, colour green, if between 3-7 amber, and over 7 red.

I can get it to change if i click a button to look at the value, but i want it to auto change. Any ideas anyone?

 

[Derek Brown]

You could have a look at Jon Peltier's excellent site for ideas.
Have a look at the index at:
http://peltiertech.com/Excel/Charts/
Also check out the following:
http://peltiertech.com/Excel/Charts/ConditionalChart1.html