Partial data in series

[jbsum]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have a data series of annual values that plots a simple moving average of three years. The first two years of data in the series are blank (for obvious reasons). The problem is that the plotting of data begins in the first year instead of the third year and ends two years shy.

This routine worked fine in Excel 2002 on an XP machine. Is there some way to begin the calculations in the third year instead the first?

Thanks - jbsum

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I have a data series of annual values that plots a simple moving average of
three years. The first two years of data in the series are blank (for obvious
reasons). The problem is that the plotting of data begins in the first year
instead of the third year and ends two years shy.

This routine worked fine in Excel 2002 on an XP machine. Is there some way to
begin the calculations in the third year instead the first?

Thanks - jbsum

It ought to work the same. But you have not provided anywhere near enough
information for me (or probably anyone else) to have any idea of what might
be wrong. What is you data layout? What kind of plot? What is the series
formula?

 

[jbsum]

Thanks for your quick response...

Data layout: x 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009

y
Monthly Average 3315.96 3713.92 3128.16 2940.59 3470.33 3924.58 3396.13 4088.05 3439.79 3568.19 3096.38 3686.38 3686.38 3686.38
Thirty Year Average 3686.38 3686.38 3686.38 3686.38 3686.38 3686.38 3686.38 3686.38 3686.38 3686.38 3686.38 3686.38 3686.38 3686.38

3 Year Rolling Average 0 0 3386.013333 3260.89 3179.69 3445.17 3597.01 3802.92 3641.32 3698.68 3367.82 3284.37 3217.15 3280.61

Kind of plot: Combination plot. The 3 Year Rolling Average is the problem. It is shown above with zero value in the first two years...it does the same thing with spaces.

Series Formula

Name:Sheet1!$A$2
Y Values Sheet1!$D$2:$O$2

I tried Sheet1!$A$2:$O$2 for the Y Value but it didn't correct the problem

Note: The Chart Data Range is blank and has the following comment: "The Chart Data Range is too complex to be displayed. If a new Data Range is selected, it will replace all of the series on the Series Panel."

Thanks very much for your help

 

[Bob Greenblatt]

Thanks for your quick response...

Data layout: x 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007
2008 2009

y
Monthly Average 3315.96 3713.92 3128.16 2940.59 3470.33 3924.58 3396.13
4088.05 3439.79 3568.19 3096.38 3686.38 3686.38 3686.38
Thirty Year Average 3686.38 3686.38 3686.38 3686.38 3686.38 3686.38 3686.38
3686.38 3686.38 3686.38 3686.38 3686.38 3686.38 3686.38

3 Year Rolling Average 0 0 3386.013333 3260.89 3179.69 3445.17 3597.01 3802.92
3641.32 3698.68 3367.82 3284.37 3217.15 3280.61

Kind of plot: Combination plot. The 3 Year Rolling Average is the problem.
It is shown above with zero value in the first two years...it does the same
thing with spaces.

Series Formula

Name:Sheet1!$A$2
Y Values Sheet1!$D$2:$O$2

I tried Sheet1!$A$2:$O$2 for the Y Value but it didn't correct the problem

Note: The Chart Data Range is blank and has the following comment: "The Chart
Data Range is too complex to be displayed. If a new Data Range is selected,
it will replace all of the series on the Series Panel."

Thanks very much for your help

Try #N/A instead of zero.

 

[jbsum]

#N/A worked fine
Thanks