XY scatter plot graph

hey, im not too good on excell hence the post, btw im on 98 version

basically i have 2 sets of data
eg.

HeartRate ..... Oxygen Uptake
101 .................... 1
102 .................... 2
103 .................... 3

I want to plot these points on a set of axis,
the x-axis being HR and the y-axis being O2.
I want the x-axis to range from 0 - 220 (with 202 being a point) in 10 increments.
and the y-axis to range from 0-3 in 0.1 increments.

i then want to (after setting the points from the table above on the axis) plot a linear regression line, which extends to the 202 and have dotted lines pointing to the Oxygen value.


is this possible because i have been trying it for ageeeeees

Make sure you are using an XY scatter plot. The format axis dialog will then allow you to set the scale parameters to the desired values.

You can use the Chart Trendline function (Chart menu -> Add trendline) to get a trendline. For users who aren't familiar with regression in Excel, it is probably the easiest, though you will be limited to the equation forms built into the tool. I prefer to use the LINEST worksheet function to perform regressions.

If the trendline tool won't automatically extrapolate to 202, it would be easy to do the extrapolation in a worksheet by putting the equation coefficients into worksheet cells. If you use LINEST to perform the regression, then you don't have to transfer the coefficients to worksheet cells.

If I've understood what you want, you simply add another series consisting of three points: (xmin,ycalc);(xcalc,ycalc);(xcalc,ymin)

great, thanks! managed to do it now