chart conditional formatting

[bob777]

I have a line chart with 3 lines, red, blue and green. Is there any way
I can conditionally format some, but not all, points on the red line to
colour white - ie make them invisible. I have looked at Jon Peltier's
site - he addresses conditional formatting - but cannot see a solution
there. Thanks in advance to all who try to help.

 

[Andy Pope]

Hi,

Have a look at my broken line example. It uses lines to mask others.
http://www.andypope.info/charts/brokenlines.htm

You can not dynamically change the colour of part of a line without
resorting to VBA code.

Cheers
Andy