EXCEL QUICK ANALYSIS BUTTON AND CHART DOWNLOAD

This option itself has different sub-options for sparklines. Step 1: Select all the data and navigate towards the quick analysis tool where you can see an option named Sparkline, click on that. You can also add the Sparklines using Quick Analysis Tool in excel. This option adds the pivot table on a new excel sheet for the selected range of data.Įxample #5 – Add Sparklines using Excel Quick Analysis Tool Step 2: Navigate towards the Tables section again and this time select the Blank… option. Select Table there and you can see the table has been added under the selected cells of data. Step 1: Navigate to the Quick Analysis Toolbar and go to Tables option to add the tables and pivots. We also can add the tables and pivots using Quick Analysis Tool. See the screenshot below.Įxample #4- Adding Tables and Pivots using Quick Analysis Tool Step 4: Select the Running Total across rows option and it will calculate the running total across all the rows. Click on the navigation bar present at the right-hand side, it will load more sub-options under Totals. Step 3: Now, we would like to explore some more options under Totals section. You can see the average of all the cells value under cell B8. Step 2: Click on Average button inside the Totals option to calculate the average sales based on the data provided. There, selct Totals option there you’ll see different sub-options like sum, average, etc. Select the data and navigate to Quick Analysis Tool. Step 1: Follow the same step we did in example 1 and 2. Quick Analysis allows you to do so as well. Often it is good to have total or averages to get the analytical overview of the data.

Step 3: After clicking on Pie Chart, the output is shown below. You can select out of the given list or can see the more charts option as well. Step 2: Select an appropriate chart that can represent this data. You can see different chart options available. Step 1: Select all the data across A1:B8 as we did in example 1 and navigate through Charts option under Quick Analysis toolbox which can be accessed at the end of the selection or by hitting CTRL + Q after the selection. Now, we would like to add the chart under this data. Step 4: Select Data Bars option under Formatting and it will add data bars across the cells which have numeric values for the data.Įxample #2 – Adding Charts Associated With the Data You also can choose different formatting options. Step 3: Once you click on and select the Icon Set option, you’ll be able to see the icon set assigned to your data and it will look like the screenshot given below.

This option enables you to set the icons for the data. Navigate to Formatting and choose the Icon Set operation under it. Each option has different sub-options that allows you to do different analytical operations. Step 2: As soon as you click on Quick Analysis toolbar, you’ll be able to see different options under it named Formatting, Charts, Totals, Tables, Sparklines. Step 1: Select all the data across A1:B8 and click on the Quick Analysis tool at the bottom of the selection or hit CTRL + Q to launch quick analysis tool. Suppose we have a country-wise sales data as shown in the screenshot below.

EXCEL QUICK ANALYSIS BUTTON AND CHART DOWNLOAD

You can download this Quick Analysis Excel Template here – Quick Analysis Excel Template Example #1 – Excel Quick Analysis Tool to Apply Conditional Formatting

Excel quick analysis button and chart