Moving average trend line

[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

 

[Shane Devenshire]

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