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
Last edited by VBA Noob; 10-17-2007 at 07:19 PM.
Add these three series to your plot and you're good to go:
Code:---F---- ------G------- ------H------- ------I------- 40 x -15% 0% 15% 41 1 =$F41*(1+G$40) =$F41*(1+H$40) =$F41*(1+I$40) 42 10000000 =$F42*(1+G$40) =$F42*(1+H$40) =$F42*(1+I$40)However, the +/-15% lines on your log scale are a narrow band indeed.Code:---F---- ---G--- ---H---- ---I---- 40 x -15% 0% 15% 41 1 0.85 1 1.15 42 10000000 8500000 10000000 11500000
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
See attached.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks