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.
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.
David,
The concept described here should work:
http://www.pdbook.com/index.php/exce..._column_chart/
----
Regards,
John Mansfield
http://www.pdbook.com
"david_hutton.NO_SPAM" wrote:
> 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.
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
david_hutton.NO_SPAM wrote:
> 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.
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
That's the business!
A convoluted way of doing it but it works.
Many thanks,Andy.
David.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks