How to Move Pivot Charts to Separate Sheets in Excel 2013
How to Create a Pivot Table with the Excel 2013’s Quick Analysis Tool
How to Move Pivot Charts in Excel 2013

How to Pivot a Table’s Fields in Excel 2013

As pivot implies, the fun of pivot tables in Excel 2013 is being able to restructure the table simply by rotating the column and row fields. This makes it easier to organize your information.

For example, suppose that after making the Dept field the column field and the Location field the row field in a pivot table, you decide you want to see what the table looks like with the Location field as the column field and the Dept field as the row field.

No problem at all: In the PivotTable Field List task pane, imply drag the Dept field label from the COLUMNS drop zone to the ROWS drop zone and the Location field from the ROWS drop zone to the COLUMNS drop zone.

Voilà — Excel rearranges the totaled salaries so that the rows of the pivot table show the departmental grand totals and the columns now show the location grand totals.

You can switch column and row fields by dragging their labels to their new locations directly in the pivot table itself. Before you can do that, however, you must select the Classic PivotTable Layout (Enables Dragging of Fields in the Grid) check box on the Display tab of the PivotTable Options dialog box.

To open this dialog box, you select the Options item on the Pivot Table button’s drop-down menu. This button is located at the very beginning of the Analyze tab beneath the PivotTable Tools contextual tab.

blog comments powered by Disqus
How to Use the Excel 2013 Quick Analysis Tool
How to Format Values in the Pivot Table in Excel 2013
Use Excel Pivot Tables to Get Top and Bottom Views
Create a Histogram with a Pivot Table for Excel Dashboards
How to Add Calculated Fields to Pivot Tables in Excel 2013
Advertisement

Inside Dummies.com