Formating Color in Bar Chart based on cell values
 

Hi,

How can I change the color of a Column Chart based on the values (limits)
of cell.
Assuming this,

A1 = Low Limit Value
A2 = High Limit Value
A3 = LowLow Limit Value
A4 = High High Limit Value
A5 = Actual Value

If A5 is between the A1 & A2 values the bar should be Green, if A5 is
outside the limits A1 & A2 but inside the limits A3 & A4, then the bar should
be Yellow and finally if A5 is out of the limits A3 & A4 the bar should be Red
Thanks

Cesar

Formating Color in Bar Chart based on cell values
 

Create a conditional chart:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Cesar" wrote in message
...
Hi,

How can I change the color of a Column Chart based on the values (limits)
of cell.
Assuming this,

A1 = Low Limit Value
A2 = High Limit Value
A3 = LowLow Limit Value
A4 = High High Limit Value
A5 = Actual Value

If A5 is between the A1 & A2 values the bar should be Green, if A5 is
outside the limits A1 & A2 but inside the limits A3 & A4, then the bar
should
be Yellow and finally if A5 is out of the limits A3 & A4 the bar should be
Red
Thanks

Cesar

Formating Color in Bar Chart based on cell values
 

Thanks, that helps great!!
--
Cesar


"Jon Peltier" wrote:

Create a conditional chart:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Cesar" wrote in message
...
Hi,

How can I change the color of a Column Chart based on the values (limits)
of cell.
Assuming this,

A1 = Low Limit Value
A2 = High Limit Value
A3 = LowLow Limit Value
A4 = High High Limit Value
A5 = Actual Value

If A5 is between the A1 & A2 values the bar should be Green, if A5 is
outside the limits A1 & A2 but inside the limits A3 & A4, then the bar
should
be Yellow and finally if A5 is out of the limits A3 & A4 the bar should be
Red
Thanks

Cesar