Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
trashcan1620
 
Posts: n/a
Default how to plot a best fit line?

how do u delete the original line after u added a trendline?
  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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?


  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to force continuous lines in line charts wal50 Charts and Charting in Excel 1 December 21st 04 11:43 PM
Plot a line? Set dymanic axis Max min Stan Altshuller Charts and Charting in Excel 3 December 9th 04 09:04 PM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 10:39 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM
Adding a text label to a line. Neil Charts and Charting in Excel 1 December 4th 04 09:41 PM


All times are GMT +1. The time now is 11:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"