ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Marking point of intersection on double y axis chart? (https://www.excelbanter.com/charts-charting-excel/73201-marking-point-intersection-double-y-axis-chart.html)

TheBigLoofah

Marking point of intersection on double y axis chart?
 

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


Barb Reinhardt

Marking point of intersection on double y axis chart?
 
Why don't you have your workbook do the calculation of intersection point
and plot that as another series.

"TheBigLoofah"
wrote in message
...

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





All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com