Results 1 to 2 of 2

Thread: Smooth line graph eror
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Feb 2013
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Smooth line graph eror

    So I am trying to make a smooth line graph in excel 2007. I have the points at (6.67,32), (7.78,32.1), (8.6,32.18), and (12.5,32). instead of making a smooth line with 32.18 as the maximum it puts a little bump between 32 and 32.1 with a maximum of about 32.2 so the graph has a little m in the middle. if I remove the 32.1 point (it was just an estimate to try and make the line fit better) it is smooth but it still isn't using 32.18 as the maximum which it needs to be. Is there something I'm missing here or is this just doomed to be erroneous.

    And I just realized I misspelled error in the title *sigh*
    Last edited by zw1ck; Jun 18th, 2015 at 11:09 AM.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,318
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Smooth line graph eror

    I believe that's normal excel behavior - the smoothed line is an approximation but I'm unaware of any built in options to tweak this.

    Here's a link that references some example files that explore excel's logic that you might find useful
    Mystery solved! The secret of Excel curved line interpolation | The Splitwise Blog

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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