software

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 quot;Apply Fill
Color Between Lines in a Chartquot;
(pubs.logicalexpressions.com/P...cle.asp?ID=590).
This produced what I required except for the correct colouring.
Is this possible?

Hi

It should be possible you just need to use extra series to provide the
different colours. See this example.
www.andypope.info/ngs/ng21.htm

Cheers
Andy

Rick Andrews wrote:
gt; I am trying to produce a graph that tracks an actual performance against a
gt; target. When the actual performance is below the target, the area between
gt; them needs to be filled red. When the actual performance is above the
gt; target, the area between them needs to be filled green.
gt;
gt;
gt;
gt; I have followed the steps detailed in the TechTrax Article on quot;Apply Fill
gt; Color Between Lines in a Chartquot;
gt; (pubs.logicalexpressions.com/P...cle.asp?ID=590).
gt;
gt;
gt;
gt; This produced what I required except for the correct colouring.
gt;
gt;
gt;
gt; Is this possible?
gt;
gt;
gt;
gt;
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info