• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Intersection Points

Kmahraz

Member
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

upload_2016-2-12_23-19-20.png
 

Attachments

  • work 4.xls
    36 KB · Views: 4
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.
 
Last edited:
Thanks Chihiro, I was thinking excel should have an option to get the intersection instantly
I appreciate the help.
Best
K
 
Back
Top