Microsoft KB Archive/95988

= Microsoft Knowledge Base =

Excel: Moving Average Chart Does Not Reflect Data
Last reviewed: September 12, 1996

Article ID: Q95988

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0 and 4.0a
 * Microsoft Excel for the Macintosh, version 4.0

SUMMARY
The sample moving average chart shown on page 37 of the &quot;Microsoft Excel User's Guide 2,&quot; version 4.0, does not reflect the accompanying sample data.

The illustration indicates that the input range used in the example extends from cell B2 to cell B9. However, to create this chart with the sample data shown, the input range must be from cell B2 to cell B10.

If the chart accurately reflected the displayed input range (from cell B2 to cell B9), the forecast series in the chart would extend only to the x-axis label &quot;8&quot;, rather than the x-axis label &quot;9&quot;.