Results 1 to 3 of 3

Thread: Trendlines

  1. #1
    New Lounger
    Join Date
    Aug 2002
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Trendlines

    A co-worker wants to use the Trendline function on a series of data that contains some anomalous numbers that she would like to exclude. However, she still wants to display these numbers on the chart. I would be interested in what others recommend as being the best way of handling this. Best we can figure is to replicate the data excluding those points and do the trendline on that.

  2. #2
    Star Lounger
    Join Date
    Jan 2001
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trendlines

    Lorne,
    Plot the data as two series, adding a trendline only to the series that is required.

    PaulJ

  3. #3
    New Lounger
    Join Date
    Aug 2002
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trendlines

    Thanks for your help, Paul.

Posting Permissions

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