LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 54
Default Changing color of negative bar when using Invert if negative

I have multiple bar charts in Excel 2007 that I am using the Invert if
negative option. After right clicking on the bar of each chart and
choosing "format data series" then "Fill" then "Invert if negative"
all of the bars that are negative are changed to the color white or
possible transparent. I can change the color of the positive bars but
I can't find where to change the color of the negative bars from
white. Anyone know how to change the color or the negative bar? Any
help would be appreciated.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing a cell color to reflect positive or negative total Alex Vega[_2_] New Users to Excel 4 May 27th 07 03:25 PM
change the colour of the "invert if negative" option in Excel Luci Charts and Charting in Excel 1 May 10th 07 01:48 PM
Set negative numbers to zero. Do not calculate with negative valu Excel Headache Excel Discussion (Misc queries) 4 September 14th 06 08:56 PM
Changing negative numbers to zero Chet T Excel Discussion (Misc queries) 5 October 7th 05 02:11 PM
Changing Positive to Negative Matthew Hackett via OfficeKB.com Excel Worksheet Functions 2 June 28th 05 11:55 AM


All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"