LinkBack URL
About LinkBacks
Is there any way I can get the negative numbers on this bar graph to be green. Basically when the numbers are negative the delivery times are fine and when they are above 0 (which I want red) they are late?
Thanks
Is there any way I can get the negative numbers on this bar graph to be green. Basically when the numbers are negative the delivery times are fine and when they are above 0 (which I want red) they are late?
Thanks
See this link:
http://www.andypope.info/charts/Invertneg.htm
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi,
Take a look at Andy Pope's example here
http://www.andypope.info/charts/Invertneg.htm
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
I got the inverted part to work, but I can not figure out how to change the color of the inverted bars. It defaults to white, and I want green. I have Microsoft 2007. The link is for 2003. Not a huge deal, but if anyone could shine some light I would appreciate it.
Thanks again
The work through for Invert if negative does not work in xl2007.
Well it does but not if you want solid fills.
The only way around the problem is to use 2 series and create a conditional chart. This will mean though that you will have to lose the charts data table or put up with the additional series being displayed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks