How do I change the inverse colour in an Excel chart?

[Guest]

I want to have blue bars when the values are positive and yellow when they
are negative. I have checked the box for "invert if negative" when choosing
the colour in Format Data Series, but I still get blue for both.

 

[John Mansfield]

David,

The concept described here should work:

http://www.pdbook.com/index.php/excel/conditional_column_chart/

 

[Andy Pope]

Hi david,

He is an explanation of how to work with the Invert if negative feature.
http://www.andypope.info/charts/Invertneg.htm

Cheers
Andy

 

[SpudHutton]

That's the business!
A convoluted way of doing it but it works.
Many thanks,Andy.
David.