| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Automate bar chart color based on value postive or negative
Is there way to automate a bar chart color based on value postive or
negative. for example if the value is postive change the bar chart color to green, if the value is negative change the bar chart color to red. |
|
#2
|
|||
|
|||
|
Hi,
I have some instructions on how to get the invert if negative option to work as expected. http://www.andypope.info/charts/Invertneg.htm Cheers Andy kathy wrote: Is there way to automate a bar chart color based on value postive or negative. for example if the value is postive change the bar chart color to green, if the value is negative change the bar chart color to red. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| Pie chart on a pie chart (exploded)? | Excel Discussion (Misc queries) | |||
| Urgent Chart Assistance | Charts and Charting in Excel | |||
| Urgent Chart Questions | Excel Discussion (Misc queries) | |||
| Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Linear Mode
