XY Scatter - applying X=Y line

[smurray444]

Dear all,

I have a quick and hopefully very straight forward question in Excel 2002, which I've been having trouble getting to the bottom of. I have a graph of two sets of data points plotted against themselves in an XY Scatter, and I want to add a line through these points to show where a perfect fit would occur (i.e. where X = Y along the course of the line - *not* simply a line of best fit). I also want to show a +/-15% envelope of dashed lines surrounding this line too, which I'm currently only able to achieve for individual points (by selecting the data series, going to the Format menu and changing the error bars).

Please see the attached (zipped) file to view the data and graph itself in its current state.

Thanks very much for your time and help,
smurray444

[shg]

Add these three series to your plot and you're good to go:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

However, the +/-15% lines on your log scale are a narrow band indeed.

[smurray444]

Thanks for your reply - however, I'm only able to get 2 points for each series (not lines), and these don't go through or anywhere near the cluster of data points already in place.

Maybe I misunderstood your explanation? If someone is willing to put the lines in place and post the updated file, with an explanation as to how they got it to work (so I understand how to do it myself), then I'd be very grateful.

Many thanks
smurray444

[shg]

See attached.