Intersection Points

[Kmahraz]

Hi:
Is there a way to get the Intersection Points for the graph below.
Also can someone help get the Line Chart -start at Y axis.

Thank you

 

[Chihiro]

First find points (x & y values) before and after intersecting point for two lines (since Excel does not draw curves, but series of lines connecting 2 data points).

Find equation that express the slope for each line connecting 2 data points before and after intersection. Then solve for intersecting point (y1=y2 & x1=x2).

Then plot that value as x-y scatter chart to plot on the chart.

See links for more detailed explanation and howto.
http://www.pblpathways.com/projects/common/pt_intersection_ex.pdf
http://www.listendata.com/2012/10/excel-intersection-between-curve-and.html
http://andypope.info/charts/intersection.htm

Edit: For clarity.

 

[Kmahraz]

Thanks Chihiro, I was thinking excel should have an option to get the intersection instantly
I appreciate the help.
Best
K