Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Apply Two Fill Colours Between Lines in a Chart
I am trying to produce a graph that tracks an actual performance against a
target. When the actual performance is below the target, the area between them needs to be filled red. When the actual performance is above the target, the area between them needs to be filled green. I have followed the steps detailed in the TechTrax Article on "Apply Fill Color Between Lines in a Chart" (http://pubs.logicalexpressions.com/P...cle.asp?ID=590). This produced what I required except for the correct colouring. Is this possible? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Apply Two Fill Colours Between Lines in a Chart
Hi
It should be possible you just need to use extra series to provide the different colours. See this example. http://www.andypope.info/ngs/ng21.htm Cheers Andy Rick Andrews wrote: I am trying to produce a graph that tracks an actual performance against a target. When the actual performance is below the target, the area between them needs to be filled red. When the actual performance is above the target, the area between them needs to be filled green. I have followed the steps detailed in the TechTrax Article on "Apply Fill Color Between Lines in a Chart" (http://pubs.logicalexpressions.com/P...cle.asp?ID=590). This produced what I required except for the correct colouring. Is this possible? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I shade the area between two lines on a chart? | Charts and Charting in Excel | |||
Vertical Lines on the Lines on 2 Axes Chart | Charts and Charting in Excel | |||
Horizontal lines in waterfall chart | Charts and Charting in Excel | |||
= Drawing more lines in a OHLCV chart = | Charts and Charting in Excel | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |