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: 36
Default Conditional formatting in a bar chart

I have a horizontal bar chart for weekly sales figures i.e. this years
sales minus last years sales .
I am using Excel 2007.
I have positive and negative sales figures.
Everything works fine but I would like to chart negative sales as red and
positive sales as green on the same chart?
I am new to Excel and I am not comfortable using VBA code, if that helps.
Thanks



 
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
conditional formatting within chart JC Charts and Charting in Excel 4 December 5th 07 07:05 PM
Conditional Chart Formatting? Sandy Charts and Charting in Excel 2 August 17th 07 05:34 PM
Chart Conditional Formatting Jus Excel Discussion (Misc queries) 1 August 29th 06 08:14 PM
chart conditional formatting bob777 Excel Discussion (Misc queries) 1 November 28th 05 10:48 AM
Conditional formatting a bar chart Caro-Kann Defence Charts and Charting in Excel 2 September 13th 05 01:52 PM


All times are GMT +1. The time now is 01:42 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"