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?

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