Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting of a data series in an Excel Chart? | Excel Discussion (Misc queries) | |||
Conditional formatting in a chart | Charts and Charting in Excel | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |