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.


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=488635

chart conditional formatting
 

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