how to plot a best fit line?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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/
_______
 
Back
Top