Drop line in Line Chart
 

Excel 2002 -

I have a line chart with 5 data sources. I would like to add a
dropline when 2 data sources cross each other. Is this possible?


--
GorillaBoze
------------------------------------------------------------------------
GorillaBoze's Profile: http://www.excelforum.com/member.php...fo&userid=5165
View this thread: http://www.excelforum.com/showthread...hreadid=398318

Hi,

You might be able to do this with the help of the functions in this example.
http://www.andypope.info/charts/intersection.htm

Create extra data series to plot the intersecting points and then user
error bars with custom values to provide the drop line.

Cheers
Andy

GorillaBoze wrote:
Excel 2002 -

I have a line chart with 5 data sources. I would like to add a
dropline when 2 data sources cross each other. Is this possible?



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info