Moving average trend line

  • Thread starter Thread starter Don Culp
  • Start date Start date
D

Don Culp

For an XY scatter chart with a 30 day moving average trend line, the trend
line extends 30 days beyond the end of the actual data. Is there a way to
prevent this?

Excel 2003, SP3

Thanks,
Don Culp
 
Hi,

This only happens if the X-axis extends past the last data point, so at
least one way to eliminate the problem is to double-click the x-axis and on
the Scale tab set the Maximum to the last date you want plotted.

A second way is to calculate the moving average in the spreadsheet and plot
it as a separate series.

If this helps, click the Yes button.

Cheers,
Shane Devenshire
 
Back
Top