software

I am using Excel 2000 and am trying to calculate a trend line and extrapolate
a data set using a polynomial function. My problem is two fold - 1st - I
cannot find a built-in function on the pull down list. The formula is listed
in the on-line help but I cannot find the actual function. 2nd - the on line
help suggests going to the chart menu and merely clicking on the tab to add a
trend line - but I cannot find the chart menu. The add a trendline option
does not appear among the chart wizard choices. I suspect that this is a
simple matter but I am completely flummoxed. Thanks in advance.

Hi,

If the chart is embedded on a worksheet you will need to select the
chart before the Chart menu item appears.
Note that not all chart types allow trendlines.

Cheers
Andy

RonB wrote:
gt; I am using Excel 2000 and am trying to calculate a trend line and extrapolate
gt; a data set using a polynomial function. My problem is two fold - 1st - I
gt; cannot find a built-in function on the pull down list. The formula is listed
gt; in the on-line help but I cannot find the actual function. 2nd - the on line
gt; help suggests going to the chart menu and merely clicking on the tab to add a
gt; trend line - but I cannot find the chart menu. The add a trendline option
gt; does not appear among the chart wizard choices. I suspect that this is a
gt; simple matter but I am completely flummoxed. Thanks in advance.

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info