Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change column color in chart when column value is over/under goal
No use of VBA or macros expected. It is believed to be Excel chart feature.
Any ideas on how to change column colors (Red/Green) if value exceeds or meets the preset goal. Eg. if goal is 4% - anything at or above 4 should show green and under 4 should be red. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change column color in chart when column value is over/under goal
Assuming your data is in A2:A20
B2: =IF(A2=4,A2,NA()) C2: =IF(A2<4,A2,NA()) copy B2:C2 down, add some labels to B1:C1, then chart B1:C20. This will give you two series, one for the aboves, one for the rest. Select each data series, right click, choose format, and set the colour as required. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Excel Charts" <Excel wrote in message ... No use of VBA or macros expected. It is believed to be Excel chart feature. Any ideas on how to change column colors (Red/Green) if value exceeds or meets the preset goal. Eg. if goal is 4% - anything at or above 4 should show green and under 4 should be red. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change column color in chart when column value is over/under goal
Here's an illustrated explanation of 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 _______ "Bob Phillips" wrote in message ... Assuming your data is in A2:A20 B2: =IF(A2=4,A2,NA()) C2: =IF(A2<4,A2,NA()) copy B2:C2 down, add some labels to B1:C1, then chart B1:C20. This will give you two series, one for the aboves, one for the rest. Select each data series, right click, choose format, and set the colour as required. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Excel Charts" <Excel wrote in message ... No use of VBA or macros expected. It is believed to be Excel chart feature. Any ideas on how to change column colors (Red/Green) if value exceeds or meets the preset goal. Eg. if goal is 4% - anything at or above 4 should show green and under 4 should be red. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Active Row Column Color Change | Setting up and Configuration of Excel | |||
Past date in column to change color | Excel Worksheet Functions | |||
How do I change the color of my row and column headers? | Excel Discussion (Misc queries) | |||
How do I change column into lines on a Line-Column chart? | Charts and Charting in Excel | |||
Change the width of a single column in a column chart | Charts and Charting in Excel |