Search Contextures Sites

Excel Pivot Table Tutorial -- Data Field Layout

1. Arrange Multiple Data Fields 2. Rename Data Fields Download the zipped sample file for this pivot table tutorial			Table of Contents

Arrange Multiple Data Fields If you place two fields in the Data area of a Pivot Table, they might appear vertically arranged. In this pivot table, the Units and Total fields have been added to the data area in the Pivot Table Wizard.
In the pivot table, the two data fields, Sum of Units and Sum of Total, appear in a single column, stacked vertically in the pivot table. This layout makes it difficult to compare the Units sold for each product or to compare the total sales per product.
To make the data easier to read, you can rearrange the table layout. If you move the data fields into the pivot table's column area, each data field will appear in a single column. To change the layout, follow these steps:
In the pivot table, point to the grey button for the Data field Hold the left mouse button, and drag the Data button onto the cell which contains the word 'Total' Release the mouse button
The Data fields will now be arranged horizontally, with each data field in a single column.   Watch a short pivot table tutorial video: Arrange Pivot Table Data Fields Horizontally

Rename Data Fields When you add fields to the Data area, they are renamed, e.g. 'Units' becomes 'Sum of Units'. Instead of using these default names, you can change the field names to something shorter, or more descriptive. There are several ways to change the names, but the following is probably the easiest. Select the heading cell in the Pivot Table. Type a new heading. Press the Enter key. Note: The typed name can't be the same as the original field name. For example, if the original field name is Units, you can't change 'Sum of Units' to 'Units'. However, you can type the original field name, and add a space character at the end, e.g. 'Units ' or at the beginning -- ' Units' Download the zipped sample file for this pivot table tutorial

Pivot Table Tutorials Excel Pivot Table -- Introduction  Excel Pivot Table -- Clear Old Items Excel Pivot Table -- Create a Pivot Table in Excel 2007  Excel Pivot Table -- Custom Calculations  Excel Pivot Table -- Data Field Layout Excel Pivot Table -- Dynamic Data Source Excel Pivot Table -- FAQs Excel Pivot Table -- Field Settings Excel Pivot Table -- Filter Source Data   Excel Pivot Table -- Filters, Top 10  Excel Pivot Table -- GetPivotData Excel Pivot Table -- Grand Totals Excel Pivot Table -- Grouping Data Excel Pivot Table -- Layout, Excel 2007 Excel Pivot Table -- Multiple Consolidation Ranges Excel Pivot Table -- Pivot Cache    Excel Pivot Table -- PivotTable Style Excel Pivot Table -- Printing    Excel Pivot Table -- Protection   Excel Pivot Table -- Report Filters Excel Pivot Table -- Running Totals   Excel Pivot Table -- Show and Hide Items  Excel Pivot Table -- Sorting Excel Pivot Table -- Subtotals  Excel Pivot Table -- Summary Functions Excel Pivot Table -- Unique Items

Pivot Table Books Pivot Tables, Beginning (Excel 2007)  Pivot Tables, Recipe Book (Excel 2003)  Pivot Tables, Recipe Book (Excel 2007)  Pivot Table Add-Ins Pivot Tables - Add-in -- Pivot Power  Pivot Tables - Add-in - Pivot Play PLUS  Pivot Table Videos Pivot Tables - Clear Old Items Pivot Tables - Copy a Custom PivotTable Style Pivot Tables - Create in Excel 2007 Pivot Tables - Create from Multiple Sheets Pivot Tables - Data Field Layout Pivot Tables - Date Filters, Add Pivot Tables - GetPivotData Pivot Tables - Group Data Pivot Tables - Layout, Excel 2007 Pivot Tables - Report Filters, Add Pivot Tables - Running Totals Pivot Tables - Select Sections Pivot Tables - Subtotals, Create Multiple Pivot Tables - Top 10 Filters

Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact
Privacy Policy		Contextures Inc., Copyright ©2010 All rights reserved.	Debra Dalgleish