Excel 2016 and 2013 provides users with popular tools for doing quick analysis of the selected data. The tools that are available as part of Quick Analysis are Formatting, Charts, Totals, Tables and Sparklines.
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.