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

G

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.
 
S

SpudHutton

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't format 'invert if negative' colour programmitically (macroignores it!) 0
change the colour of the "invert if negative" option in Excel 1
Inverse colors in bar chart 1
Changing color of negative bar when using Invert if negative 9
Convert Error Bars to Series and Colour 1
Excel 07 - Stacked Chart Labels on Negative Values 1
How to change line chart color based on condition like + and -. 1
separate colors for positive and negative bars in bar charts? 1

Top