How can I make a table or chart to interpolate between values?

		Microsoft Office Forums > Microsoft Excel > Excel
How can I make a table or chart to interpolate between values?

FAQ

Mark Forums Read

Thread Tools

Display Modes

09-30-2016, 08:10 PM

macropod

Windows 7 64bit How can I make a table or chart to interpolate between values?

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

There are many possible interpolation algorithms. Perhaps the simplest is a linear one.
Suppose your dates (in ascending order) are in column A and the data are in column B and there are gaps in column B between rows 9 and 19. To generate a linear interpolation for the missing data, you could insert the following formula in B10 and copy down to B18:
=(B$9-B$18)/(A$9-A$18)+B9

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how can I make a ScrollBar &/or a SpinButton display values?	jeffk	Excel	3	01-04-2016 04:25 AM
Format Chart X axis - inconsistent values	TimTDP	Excel	2	12-01-2015 02:56 AM
Is it possible to make such chart in Word?	am0	Word	3	12-12-2014 02:13 AM
Generate chart from list of text values	knownunknown	Excel	6	04-24-2013 01:56 AM
Word chart with words for y-values?	Computerbum	Office	0	09-19-2011 07:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:28 PM.