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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Marcin Peciak" wrote in message
...
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