Inverse colors in bar chart

[Marcin Peciak]

Hi,

I have a bar chart with series positive and negative. I'm looking for
solution that would change color of the bar chart for points where value is
negative (or if it meet a condition - like <5). Any suggestions? I would
also need to control color of the positive/negative bars.

Many thanks,
Marcin

 

[Andy Pope]

Hi,

For information on the use of Invert if negative see,
http://www.andypope.info/charts/Invertneg.htm

And for conditional charts see,
http://peltiertech.com/Excel/Charts/ChartIndex.html#C

Cheers
Andy