If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Vertical Lines on the Lines on 2 Axes Chart | [email protected] | Charts and Charting | 3 | March 3rd, 2006 05:14 AM |
Multiple filter query of form | truepantera | Using Forms | 6 | August 4th, 2005 08:26 AM |
Want to combine columns and horizontal lines in complex chart - Can it be Done?! | James Hobart | Charts and Charting | 3 | February 18th, 2005 03:23 AM |
How do print a chart so the chart area 'fill' shows through it? | holly | Charts and Charting | 1 | October 9th, 2004 04:36 AM |
Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |