In the Add-Ins box, check the Analysis ToolPak check box, and then click OK.In the Manage box, select Excel Add-ins and then click Go.Click the File tab, click Options, and then click the Add-Ins category.To perform data analysis on the remainder of the worksheets, recalculate the analysis tool for each worksheet.įollow these steps to load the Analysis ToolPak in Excel 2016 for Mac: When you perform data analysis on grouped worksheets, results will appear on the first worksheet and empty formatted tables will appear on the remaining worksheets. The data analysis functions can be used on only one worksheet at a time. Some tools generate charts in addition to output tables. You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table. So different methods of creating a chart quickly, not only this Quick Analysis tool, but also before that the F11 key, to get a chart on a separate sheet, and the Alt+F1 keystroke combination, to get a chart on the current worksheet.If you need to develop complex statistical or engineering analyses, you can save steps and time by using the Analysis ToolPak. If not quite instantaneous, that's fast also. Simply click it, and then we'll see charts here, as one of the choices, and we'll see some variations in there. A new feature in Excel 2013, not exactly instant, but pretty fast in its own right, is after selecting data that must include at least one numeric cell, we will see a Quick Analysis tool pop up right here in the lower right hand corner. And here too, we can press F11 or Alt+F1. If the data, like in the lower case here, is not surrounded by any other relevant data, we can simply click here. We can quickly, if not finish this, make the changes that we want simply by either pressing Alt+F1 or as we did earlier to get that chart on the separate sheet, F11. In both cases, we have room for a chart title there. And of course, at other times, we do want to do more with the chart. But often we simply want to chart, just to get a good quick read. In both cases, the chart types we see here are called Clustered Column. Now, if you want to chart right on the worksheet, and here the data is already selected. If you go back to the sheet data selection and make some changes to the values, even if you're not looking at that chart at the same time, the chart will be changing, if you make changes here, with any of these values. This chart, by the way, is in sync with the data though. Your focus is strictly on the chart, not on the data. If you want to refine the chart, start working with some of the various commands to make this chart look better. There are some advantages to this approach. In other words, we don't see the data associated with it. Notice, there's nothing on the screen here except this chart. And there it is, typically called Chart 1, or if you've already created some, Chart 2, Chart 3. We're about to see a new sheet to the left of the current sheet, data selection. After selecting the data that you want to see in a chart, you can simply press the F11 key, and get a new chart on a new sheet. You can create a chart instantly with one of two different key stroke combinations.
0 kommentar(er)
