LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Caro-Kann Defence
 
Posts: n/a
Default Conditional formatting a bar chart

Hello.

I feel that I am so close, I can taste it! I have looked at a number of
postings here and tried some of the referenced websites but just haven't been
able to get this to work. Any help would be appreciated. My problem is:

I have a bar chart tracking stock performance. For each stock, I have a cost
basis and a current value which is either greater or less than (or possibly
equal to I suppose) the cost. What I want to do is to create a bar chart that
when the current value is less than the cost, the difference between the
current value and the cost is shaded red. When the current value is greater
than the cost, the difference is shaded green. I have tried using the overlap
but I cannot then figure out how to fill in the colours or use the
move-to-back or move-to-front (if I can even do that). Should I use stacked
columns instead?

Help!!!

Thanks,
CKD
 
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 of a data series in an Excel Chart? Rowan Excel Discussion (Misc queries) 1 July 29th 05 01:21 PM
Conditional formatting in a chart Baro Charts and Charting in Excel 3 June 27th 05 06:01 AM
Conditional Formatting Error ddate Excel Worksheet Functions 0 May 5th 05 09:00 PM
difficulty with conditional formatting Deb Excel Discussion (Misc queries) 0 March 23rd 05 06:13 PM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


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