"Jon Peltier" wrote in message
...
Greg -

To make the lines appear (assuming the intervening cells are truly blank,
and not just formulas that appear blank to the human eye), select the
chart, go to Options on the Tools menu, and on the Chart tab, choose the
Show Empty Cells As --
Interpolate option.

A trendline will not pass through all points of any but the most mundane
data sets. You can make it extend beyond the data: double click the
trendline, click on the Options tab, and choose the number of units to
forecast forward or backward (back-cast?). You could use a smoothed line
to make it look like a "best fit through all points" curve.

- Jon

Thanks Jon!!

Are there any AddIns for doing Chart analysis?

-gk-