Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stack area chart - keep the same color for each item
Hi All,
I have a stack area chart, and when the rank of a stack item changes order, I want the color to stay with the item. E.g. Instance 1 X - 5 (color blue) Y - 2 (color green) Z - 3 (color red) X is at the bottom of the stack, then Y then Z. Instance 2 Y - 4 (color green) Z - 3 (color red) X - 1 (color blue) Now the stack has changed to Z at the bottom, then Z then Y. Is there any way I can always have X as blue, Y as green and Z as Red? This one has been racking my brain all day, any help with be much appreciated... Thanks, B/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RedYellowGreen Color Banding in Chart Plot Area | Charts and Charting in Excel | |||
Target area in Excel chart with different color | Charts and Charting in Excel | |||
Conditional Format of the CHART AREA COLOR | Charts and Charting in Excel | |||
Conditional Format of the Chart AREA COLOR | Excel Discussion (Misc queries) | |||
How to vary color in an area chart between negative or positive d. | Charts and Charting in Excel |