Home |
Search |
Today's Posts |
#1
|
|||
|
|||
separate colors for positive and negative bars in bar charts?
When using the "invert if negative" function in an excel chart, is it
possible to set a default color for negative numbers (i.e. positive bars will be Blue and negativ Red)? I know you can change the colors individually, but have not found a way to make it dynamic. This gets tedious when updating weekly charts. |
#2
|
|||
|
|||
Hi,
Here is an explanation of how to get this feature working. http://www.andypope.info/charts/Invertneg.htm Cheers Andy t killion wrote: When using the "invert if negative" function in an excel chart, is it possible to set a default color for negative numbers (i.e. positive bars will be Blue and negativ Red)? I know you can change the colors individually, but have not found a way to make it dynamic. This gets tedious when updating weekly charts. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Negative Values Only | Excel Discussion (Misc queries) | |||
Calculating negative time & creating scrol bars for fixed size txt box. | Excel Discussion (Misc queries) |