Afternoon,

I have a graph showing 2 items of data, and I need to calculate the intersection between these 2 sets of data.
Below is a screen capture of the graph, with the blue series of data shown in the table to the left. Note that the top row is row 1.

Capture.JPG

Below is the red series of data, formulated to just show a vertical line.

Capture 2.JPG

My end goal is to have excel report the Y value of where these 2 line intersect, in this instance I know the X value will be 49, and the Y will be approx 140. Is this something that is achievable?

Any assistance greatly appreciated, thanks.