![Where Is The Quick Analysis Tool In Excel For Mac? Where Is The Quick Analysis Tool In Excel For Mac?](/uploads/1/2/5/4/125423885/105552471.jpg)
Sep 22, 2017 - Start Excel for Mac. Click Tools, and then click Add-Ins. Click the Data Analysis ToolPak or Solver option to enable it. Then, click OK.
Let us take the following sample data and have a quick look at the charts that can be for this data. Select the data and click the Quick Analysis icon available at the bottom right hand side of the selection. This should provide you with the option to use different tools as shown below. Now let us say you want to pick the better looking charts for the sample data. Navigate to Charts tab in Quick Analysis tool and check the preview for different chart types.
And on selecting your preferred chart type, will add the chart to your worksheet. Turn Off Quick Analysis tool For some reason if you do not want to have the Quick Analysis tool on selecting the data then you can turn off this feature using the General Options. Click the File menu – Options from the menu list. In the General Options window, navigate to User Interface options and unmark the check box with caption as “Show Quick Analysis options on selection”. Click OK button to confirm and save the changes.