If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
chart menu
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. |
#2
|
|||
|
|||
chart menu
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: 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. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cannot get chart menu bar to stay up in excel 97 | fireaxe2 | General Discussion | 1 | October 30th, 2005 02:08 PM |
Menu Bar | tezza | General Discussion | 4 | October 17th, 2005 06:58 PM |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
Where is the "Chart Menu" for adding a trendline to a set of #s? | Exceller In America | Charts and Charting | 1 | August 5th, 2005 08:49 PM |
How to disable or remove Save button. | jdtivoli | General Discussion | 3 | July 27th, 2004 12:52 PM |