how to plot a best fit line?

[trashcan1620]

how do u delete the original line after u added a trendline?

 

[Jerry W. Lewis]

If by "the original line" you mean a line that connects the data points,
select the data series, and Format|Selected Data Series|Patterns and
check "None" under "Line"

Jerry

 

[Jon Peltier]

If you delete the series, the trendline will also go away. Double click on the
original series, and on the Patterns tab, choose none for the Line style, and if
desired, none for Markers. To hide the legend entry, select the legend, then select
the text of the entry, and press the Delete key (don't select the legend key, which
is the symbol in front of the text, or you'll delete the series!)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______