Stacked charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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?
Click to expand...

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!
 
Back
Top