Marking point of intersection on double y axis chart?

[TheBigLoofah]

I have two sets of data plotted on a 2 axis line chart. The data resembles a cross with one set increasing and the other decreasing. Is there a simple command that will draw on marker lines showing where they intersect, with their respective values on the axes?

[Barb Reinhardt]

Why don't you have your workbook do the calculation of intersection point
and plot that as another series.

"TheBigLoofah" <[email protected]>
wrote in message
news:[email protected]...
>
> I have two sets of data plotted on a 2 axis line chart. The data
> resembles a cross with one set increasing and the other decreasing. Is
> there a simple command that will draw on marker lines showing where
> they intersect, with their respective values on the axes?
>
>
> --
> TheBigLoofah
> ------------------------------------------------------------------------
> TheBigLoofah's Profile:
> http://www.excelforum.com/member.php...o&userid=31797
> View this thread: http://www.excelforum.com/showthread...hreadid=515232
>