+ Reply to Thread
Results 1 to 3 of 3

how to plot a best fit line?

  1. #1
    trashcan1620
    Guest

    how to plot a best fit line?

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

  2. #2
    Jerry W. Lewis
    Guest

    Re: how to plot a best fit line?

    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. #3
    Jon Peltier
    Guest

    Re: how to plot a best fit line?

    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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1