If you are using Excel just to input data, then you are not utilizing the true potential of this software. Pivot Table is one of the most powerful features of MS Excel that enables you to extract helpful conclusions out of seemingly large clutters of data set. You can then select which quarters to include by ticking/ unticking them in the 'Pivot Table Fields' section, but note that this will also affect the pivot table you picked to make into a pivot chart.Do you want to organize your data set and make sense out of it? Don’t want to spend thousands of dollars on data analysis software? Do you want a simple yet effective way of number crunching?Įxcel Pivot Table is exactly what you are looking for! What are Pivot Tables in Excel? You can make a pivot chart by simply clicking the pivot chart button when you have a pivot table selected. To get the top ten you would either count the rows manually, or use formulae to present this on another worksheet. If you want all four at the same time then make four pivot tables. Then 'Descending (Z to A) by:' pick 'Sum of QTR1', then 'Sum of QTR2', etc. To get the top 10 per quarter you would need to click the arrow in the 'Row Labels' cell and pick 'More Sort Options'. You would wants your rows to be 'Category Association', and then you could add 'QTR1' to 'QTR4' as 'Sum of' items to the 'Values' part of the Pivot Table. If your data was in an Excel worksheet then you could easily make this into a Pivot Table, simply highlight all the data and Insert - Pivot Table. I'm going to take a guess that you don't have an answer yet because this is poorly tagged?Īnyway, here's a quick stab, seeing as nobody else has stepped up to the plate yet.

Excel 2013 create pivot table options