Moving average trend line
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
"Don Culp" wrote:
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
|