However, for one particular series, the trend line extends the entire length of the graph. I checked the Format->Trendline window on all the other lines and they show the "Backwards" box grayed out. But on this one particular trend line that runs the length of the graph, it's not. Everything else matches the other (short) trend lines.

The Options tab has:

Custom title

Forecast: Forward = 0 Backward = 0

Set intercept, Display equation, Display R-squared value are all NOT checked.

When the linear trend line extends the length of the chart, it compresses the scale and makes the whole chart look funny.

Has anybody run into this problem? If so, how do I fix it?

Thanks,

Jon