Can Line Chart Overlaps be Highlighted?

  • Thread starter Thread starter Michael B.
  • Start date Start date
M

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:
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!
 
Back
Top