Pivot Table Issues

How to Stack Multiple Values Vertically in an Excel PivotTable

Phi Hung Vo Sep 30, 2026 870 views

Question details

The user wants to format a PivotTable so that multiple calculated value fields (such as Sales, Average Price, and Units Sold) are displayed vertically, one below another, rather than side by side in columns.

How to Stack Multiple Values Vertically in an Excel PivotTable

Product: Excel
Device & OS: not provided
Scenario: Formatting a complex PivotTable report to improve readability when dealing with multiple data metrics.
Observed behavior: By default, adding multiple fields to the Values area in a PivotTable causes the values to populate horizontally across columns.

Before you start

Ensure that you have already created your PivotTable and dragged more than one data field into the Values area in the PivotTable Fields pane.

Solution 1Recommended

Move the Values Field from Columns to Rows

The most direct way to stack multiple values vertically is by adjusting the layout placement of the automatically generated Values field.

Whenever you add two or more fields to the Values area of a PivotTable, Excel automatically creates a placeholder item named 'Σ Values' and places it in the Columns area. Relocating this placeholder will instantly change the visual layout of your table from horizontal to vertical.

Open the PivotTable Fields Pane

Click anywhere inside your existing PivotTable. This action will reveal the PivotTable Fields pane on the right side of your screen.

Locate the Σ Values Field

Look at the four layout quadrants at the bottom of the pane (Filters, Columns, Rows, Values). Find the 'Σ Values' tag, which is currently sitting in the Columns box.

Drag to the Rows Area

Click and hold the 'Σ Values' tag, then drag it from the Columns box and drop it into the Rows box. Drop it below your existing row categories for a cleaner look.

Move the Values Field from Columns to Rows

Layout Updated: Your data metrics will immediately refresh and display stacked vertically beneath each row category.

WPS Spreadsheet Pivot Tables

Easily Format PivotTable Layouts in WPS Spreadsheet

WPS Spreadsheet provides a highly compatible and intuitive PivotTable feature. You can effortlessly manage complex datasets, toggle between vertical and horizontal value layouts, and perform advanced data analysis just like in Microsoft Excel.

1. Insert a PivotTable: Open your dataset in WPS Spreadsheet, select your data range, go to the Insert tab, and click PivotTable.
2. Add Multiple Values: In the PivotTable layout pane on the right, drag your desired data metrics (e.g., Sales, Units) into the Values box.
3. Find the Values Tag: Notice the 'Σ Values' tag that automatically appears in the Columns box to accommodate the multiple metrics.
4. Stack Vertically: Simply drag the 'Σ Values' tag from the Columns box into the Rows box to stack all your value metrics vertically.

Fully compatible with Microsoft Excel (.xlsx) file formatsFamiliar drag-and-drop PivotTable Fields interfaceEasily toggle between horizontal and vertical value layoutsFree and lightweight spreadsheet data analysis tool

microsoft office alternative - wps office

Frequently Asked Questions

Why does my PivotTable automatically put multiple values side by side?

By default, when you add more than one field to the Values area, spreadsheet programs automatically place the 'Σ Values' tag in the Columns area. This is designed to prevent rows from becoming excessively long and to keep comparative data side by side.

How do I change the display order of the vertically stacked values?

To rearrange the order of the stacked values, go to the Values area in the PivotTable Fields pane. Click and drag the individual value fields up or down. The vertical layout in your table will automatically update to reflect this new order.

What should I do if the PivotTable Fields pane is missing?

If you don't see the pane on the right, ensure you have clicked a cell inside the PivotTable. If it still doesn't appear, go to the PivotTable Analyze tab on the top ribbon and click the 'Field List' button to toggle its visibility.

Can I format the vertically stacked values independently?

Yes, even when stacked vertically, each value field maintains its own formatting rules. You can right-click any individual value cell, select 'Value Field Settings', and adjust the Number Format (such as Currency or Percentage) independently from the other stacked values.

Excel & Data Problems