| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate Chart Based on Cell Values | Charts and Charting in Excel | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| list two columnar values based on conditional formating (text color) | Excel Worksheet Functions | |||
| In excell be able to Sum values based on the color of the cell | Excel Worksheet Functions | |||
Linear Mode
