how to plot a best fit line?
how do u delete the original line after u added a trendline?
|
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 trashcan1620 wrote: how do u delete the original line after u added a trendline? |
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/ _______ trashcan1620 wrote: how do u delete the original line after u added a trendline? |
All times are GMT +1. The time now is 05:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com