Stacked charts
 

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

Stacked charts
 

On Thu, 21 Jun 2007, in microsoft.public.excel.charting,
Ticotion said:
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!

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Stacked charts
 

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