Greg -

What kind of analysis are you looking for?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

38N90W wrote:

"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-