Take a look at Jon's site (via the link below) under "Conditional Charts".
The examples of formula references should help you create the chart.

http://peltiertech.com/Excel/Charts/ChartIndex.html

--
John Mansfield
http://cellmatrix.net





"Ticotion" wrote:

Hi

I want to to create a chart where the colour changes when ever a value is
reached. Ex. I have a mashine that produces 1000 it's goal is 2000. The chart
should then show a column that is red because it is under the goal. I also
have a maschine that produces 3000 and the goal is 2000. The coloum should
then change to green. Is it possible to make a chart like this in excel?

Regards
Ticotion