STEP 1:Insert a new Pivot table by clicking on your data and going to Insert Pivot Table New Worksheet or Existing Worksheet STEP 2: In the ROWS section put in the Sales Month field, in the COLUMNS put in the Financial Year field and in the VALUES area you need to put in the Sales field twice, I explain why below: STEP 3:Click the second Sales field’s (Sum of SALES2) drop down and choose Value Field Settings STEP 4: Select the Show Values As tab and from the drop down choose Rank Largest to Smallest. Select Sales Month as the Base Field. This means that we will rank the Sales Values by the Sales Month (where Rank 1 is the Largest). Also change the Custom Name into Rank Largest to Smallest to make it more presentable. You now have your Pivot Table, showing the Rank Largest to Smallest for the sales data of years 2012, 2013, and 2014. You can see that each red box is the ranking for each year (for Years 2012, 2013, 2014, and the Total Rankings).
A pivot chart is an extension of a pivot table, so in order to have a pivot chart you must also have a pivot table. Excel provides several ways insert a pivot table and pivot chart in one step. First, try Recommended Charts.
![How do i insert a pivot chart in excel 2016 for mac 2012 full How do i insert a pivot chart in excel 2016 for mac 2012 full](/uploads/1/2/5/4/125405141/606110592.jpg)
HELPFUL RESOURCE.
Did your pivot table field list disappear? In this video I explain how to get the field list back if it is not showing. The quickest way to get it back is to Right-click a cell inside the pivot table and select 'Show Field List' from the menu. The field list is contextual and will only appear when a cell is selected inside the pivot table. It can also be turned on or off in the Analyze/Options tab of the Ribbon by clicking the Field List button.
Here are the instructions: 1. Select any cell inside the pivot table. Go to the Analyze/Options tab on the right side of the ribbon. If you are using Excel 2010/2007 it will say options. The tab has been changed to Analyze in new versions.
Click the Field List button in the show section to enable the field list. This is a toggle button that can be turned on/off. The close button in the top-right corner of the field list window also turns the toggle off.
The PivotPal Add-in allows you to work with the field list when you are looking at the source data of the pivot table. This is something that cannot be done with Excel's field list. Click here to learn more about PivotPal. Subscribe to my free email newsletter.