+ Reply to Thread
Results 1 to 4 of 4

Plotting & Smoothing Linear Inflection Points

  1. #1
    Registered User
    Join Date
    04-05-2021
    Location
    Philadelphia, PA
    MS-Off Ver
    MS 365 Business
    Posts
    2

    Plotting & Smoothing Linear Inflection Points

    I need to fix the attached photo. I'm looking to straighten the circled area (with a linear trendline?), rather than have it temporarily increase, decrease, then increase again.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,610

    Re: Plotting & Smoothing Linear Inflection Points

    Welcome to the forum.

    Excel 2008??? Do you mean MS 365?

    We won't be able to work with a photo, so don't bother with that. There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    04-05-2021
    Location
    Philadelphia, PA
    MS-Off Ver
    MS 365 Business
    Posts
    2

    Re: Plotting & Smoothing Linear Inflection Points

    Thank you for the guidance! The issue I'm running into is the inflection point between 3/23/20 & 3/31/21. You'll see the initial increase, then a sharp decline, then another increase. How can I smooth that line?
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,371

    Re: Plotting & Smoothing Linear Inflection Points

    I'm not sure what to recommend. The chart itself is not going to do this -- the chart simply shows what is in the spreadsheet. And I don't see anything in the spreadsheet to indicate what values you would rather use for the chart. Basically, I would expect to replace/overwrite the offending values in the spreadsheet with values that you like better. I'm not sure how you would like to approach that, but that's what I would expect -- by hook or crook change the values in the spreadsheet and the chart will follow.

    How would you like to move forward? Overwrite values in the existing data, or make a copy of the data so the original data are not lost?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Linear Chart with points (a specified value)
    By caranti in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-23-2017, 04:29 AM
  2. Inflection points formula for excel
    By ruthyeh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-23-2013, 12:04 PM
  3. linear plot where all data points aren't known
    By moldoverb in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-16-2012, 11:59 AM
  4. Linear interpolation between just two points
    By steven_p in forum Excel General
    Replies: 2
    Last Post: 09-06-2011, 11:54 PM
  5. Plotting points using VBA
    By adilson.perez in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 01-08-2011, 10:37 PM
  6. [SOLVED] plotting 'random' data on a linear x-axis
    By tengel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-23-2006, 05:40 PM
  7. [SOLVED] Linear interpolation between two points found using a lookup funct
    By aj4444 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-30-2005, 01:00 AM

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