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
|
|||
|
|||
No Data Analysis item in Excel Tools menu. Now what?
How do I get the Data Anlysis (for regression) into my Tools menu?
|
#2
|
|||
|
|||
No Data Analysis item in Excel Tools menu. Now what?
The answer, as for so many questions, is in Excel help:
"If the Data Analysis command is not available, you need to load the Analysis ToolPak add-in program." -- David Biddulph "ainoni" wrote in message ... How do I get the Data Anlysis (for regression) into my Tools menu? |
#3
|
|||
|
|||
No Data Analysis item in Excel Tools menu. Now what?
What if the ToolPak is installed but will not appear in tool menu on a
worksheet with graph displayed. "David Biddulph" wrote: The answer, as for so many questions, is in Excel help: "If the Data Analysis command is not available, you need to load the Analysis ToolPak add-in program." -- David Biddulph "ainoni" wrote in message ... How do I get the Data Anlysis (for regression) into my Tools menu? |
#4
|
|||
|
|||
No Data Analysis item in Excel Tools menu. Now what?
It needs to be not only installed but enabled (under Tools/ Addins).
If that looks OK you could try disabling the Add-in, coming out of Excel (& possibly rebooting your machine), then re-opening Excel and re-enabling the Add-in. Excel does sometimes "forget" that the add-in was enabled. Or going back to the last bit of your message, "Data Analysis" won't appear on the Tools menu if you are looking at a chart, rather than a worksheet. The menus for a chart are very different from the menus for a worksheet. Data Analysis is a worksheet function, not a chart function. Go to a worksheet, rather than a chart, and look again at your Tools menu. -- David Biddulph "hoakland" wrote in message ... What if the ToolPak is installed but will not appear in tool menu on a worksheet with graph displayed. "David Biddulph" wrote: The answer, as for so many questions, is in Excel help: "If the Data Analysis command is not available, you need to load the Analysis ToolPak add-in program." -- David Biddulph "ainoni" wrote in message ... How do I get the Data Anlysis (for regression) into my Tools menu? |
#5
|
|||
|
|||
No Data Analysis item in Excel Tools menu. Now what?
If the Chart is selected you will get a different menu.
Do not select the Chart on the worksheet and you will see ToolsData Analysis. Gord Dibben MS Excel MVP On Tue, 23 Sep 2008 08:45:26 -0700, hoakland wrote: What if the ToolPak is installed but will not appear in tool menu on a worksheet with graph displayed. "David Biddulph" wrote: The answer, as for so many questions, is in Excel help: "If the Data Analysis command is not available, you need to load the Analysis ToolPak add-in program." -- David Biddulph "ainoni" wrote in message ... How do I get the Data Anlysis (for regression) into my Tools menu? |
Thread Tools | |
Display Modes | |
|
|