Hi,
To some extent it depends how many times the lines cross. If it's just the
once then you can use area charts to provide the shading.
http://www.andypope.info/ngs/ng21.htm
http://pubs.logicalexpressions.com/P...cle.asp?ID=590
This may help if the used one line as a base line.
http://peltiertech.com/WordPress/are...t-if-negative/
More complex lines may require a coded solution.
http://peltiertech.com/Excel/Charts/VBAdraw.html
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Michael B." wrote in message
...
Can the overlap portion(s) of two lines in a chart be shown in a different
color, without having to manually draw a shape? I would like to show the
areas where Line A is above Line B as red, and the areas where it crosses
below in blue - is it possible to do this without manually drawing in
shapes?