|
#1
|
||||
|
||||
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] |
#2
|
|||
|
|||
Quote:
Actually, I probably phrased my question incorrectly. I'm looking for a simple solution and don't need interpolation. I was thinking more along the lines of "if a cell is zero or blank, insert previous cell contents." That would keep the line graph from bottoming out and giving the appearance that investments went to zero on the days where there is no data entered. |
|
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 |