chart conditional formatting

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.

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

bob777 wrote:
> 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, Microsoft MVP - Excel
http://www.andypope.info