Can Line Chart Overlaps be Highlighted?

[Michael B.]

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?

 

[Andy Pope]

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/Pub0009/LPMArticle.asp?ID=590

This may help if the used one line as a base line.
http://peltiertech.com/WordPress/area-chart-invert-if-negative/

More complex lines may require a coded solution.
http://peltiertech.com/Excel/Charts/VBAdraw.html

Cheers
Andy

 

[Michael B.]

Andy:
Thanks for that information - with regard to the first solution, the lines
do cross more than once, so that won't do the trick.
The second solution doesn't work since one line is not a baseline, and the
values aren't negative, so the "invert if negative" option doesn't apply.

I'm not sure about the third, I have no experience with VBA, but I will look
at the examples closely and see if anything will work.

Thank you very much for your quick response, and for the great information
that I can use in many other situations I've come across!