+ Reply to Thread
Results 1 to 3 of 3

type of interpolation in line chart

  1. #1
    Registered User
    Join Date
    01-22-2014
    Location
    Dayton, OH
    MS-Off Ver
    Excel 2013
    Posts
    2

    type of interpolation in line chart

    I am charting growth over a span of 6 decades for several groups. Data points vary in time for the groups over this span so I am using interpolation (#N/A) to fill gaps. My question is does this interpolation default to linear interpolation?

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

    Re: type of interpolation in line chart

    Assuming I understand your scenario (an example chart + data set in a spreadsheet would help illustrate this kind of question), then I would say that the "default" method of drawing the lines on the chart is indeed to assume that the available points are connected by straight lines, so the "missing" points are linearly interpolated.

    If you go into the "format data series" dialog and select the optional "smoothed" line toggle, you can have the points connected by a smooth "spline" curve.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    01-22-2014
    Location
    Dayton, OH
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: type of interpolation in line chart

    great, thanks for the help!

+ 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. Changing line cap type for X-Y chart
    By michch in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 12-20-2016, 03:11 PM
  2. [SOLVED] assign different chart line type under different condition with vba
    By DavidRoger in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-30-2013, 08:51 PM
  3. Help creating special type of line chart
    By zeospeed in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-01-2013, 09:55 AM
  4. How to apply the custom chart type: "Line - Column on 2 Axes"
    By talrs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-20-2006, 04:25 AM
  5. Adding a line Chart Type to a stacked-clustered Chart Type
    By Debbie in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-05-2005, 08:06 PM

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