View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anthony D Anthony D is offline
external usenet poster
 
Posts: 78
Default How do you get the values of the data between data points

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

"marshie" wrote:

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.