|
|
Search
Contextures Sites
|
||
Pivot Table Data Field Layout
Arrange Multiple Data Fields in Excel 2010In Excel 2010 and Excel 2007, when you add multiple data fields to the table, by default the data headings are arranged horizontally.
It's easy to change the data to a vertical layout though, which was the default setting in older versions of Excel. To change the data to a vertical layout, drag the Values button in the Pivot Table Field List, from the Column Labels area to the Row Labels area.
In most cases, the Values button should be positioned below the other fields in the Row Labels area.
After you move the Values label to the Row Labels area, the data fields will be arranged vertically. This pivot table is in Tabular Form layout.
If the Report Layout is Compact Form, the data field headings are indented under the other Row headings.
Video: Arrange Data Fields in Excel 2010Watch a short video tutorial, to see how to move the data fields in Excel 2010:
Arrange Multiple Data Fields in Excel 2003If you place two fields in the Data area of a Pivot Table, they might appear vertically arranged. In the screen shot below, 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:
The Data fields will now be arranged horizontally, with each data field in a single column.
Video: Arrange Data Fields in Excel 2003Watch a short video tutorial, to see how to move the data fields in Excel 2003:
Rename Data FieldsWhen you add fields to the Data area, they are renamed. For example, 'Units' becomes 'Sum of Units'. Instead of using these default names, you can change the field names to something shorter, or more descriptive, such as Units Sold. 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'
Change the Data Field NameThere are several ways to change the names, but the following is probably the easiest.
Move a Pivot Field in Excel 2010Drag a field button from one area in the Field List to another. For example, drag the Region field from the Row Labels area to the Column Labels area.
Download the zipped sample file for this tutorial
|
|
|
|
|
|
