Stacked charts

[Guest]

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

 

[Del Cotter]

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?

Yes. Have two columns. One (the red one) has the production value if the
production value is under the goal, and zero if it is over. The other
(the green one) has zero if the production value is under the goal, and
the production value if it is over.

=IF(value<production,value,0)
=IF(value<production,0,value)

If you plot them together, they will never appear at the same time, but
will seem to be one column that changes colour!

 

[Guest]

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