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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
That's the business!
A convoluted way of doing it but it works.
Many thanks,Andy.
David.
 
Back
Top