In Excel 2007 is there a way I can create a bar chart which shows negative vaues as a red bar and positive values as green?
Cheers
RL
In Excel 2007 is there a way I can create a bar chart which shows negative vaues as a red bar and positive values as green?
Cheers
RL
Last edited by Redder Lurtz; 02-26-2013 at 07:36 AM.
Hi RL,
There is an option "invert if negative", see attached where I used that.
red bars for negatives.xlsx
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Top man, thanks DILIPandey.
Cheers
you are welcome RL...
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks