How do you get the values of the data between data points

M

marshie

I am using excel to make a line graph with two lines. The two lines cross and
I want to know the exact point where the lines cross, however can't get my
computer to trace either line to figure out the exact point.
 
A

Anthony D

Hi Marshie,

One way is to use the drawing toolbar to draw straight lines on the chart to
the x axis and y axis from the point where the lines cross. The y-axis format
can be adjusted to increase the resolution of the scale e.g. showing the
minor tick marks with a small minor unit. The same can be done with the
x-axis if the chart type is x-y scattergraph e.g. an x series 1,2,3,4, etc.
to identify the data sequence is explicitly included.

Another way is to select a line and add a trendline (to each of the two
lines) and display their equations on the chart, then solving the equations
to obtain the crossing point.

e.g.
series 1: 1, 2, 3 (trend equation y=x)
series 2: 4, 3, 2 (trend equation y=5-x)

x=2.5, y=2.5

Hth
Anthony
 
Top