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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Amy" wrote in message
...
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