Trendline for chart with error bars

G

Guest

Hi,

I have scatter plots with error bars (each data point is the average of
several reps, and the error bars show the standard error). If I fit a
trendline to the data, is there a way to make the trendline take the error
bars into account? Or would I have to plot all raw data rather than averages?

I'm using Excel 2003.

Thanks,
Amy
 
J

Jon Peltier

You would have to calculate the trendline based on all of the points. You
could plot them in a second series but use no markers and no lines, so they
don't clutter up the chart. Then add a trendline to this second series.

- Jon
 
G

Guest

Thanks Jon - I had thought of that but just thought I'd post here in case
there was an easier way.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top