Pivot Table Issues

Sort Day-over-Day Changes in an Excel PivotChart

Emma BrownEmma Brown Nov 18, 2026 868 views

Question details

The user wants to sort an Excel PivotChart by day-over-day change from largest to smallest.

How to Sort Day-over-Day Changes in an Excel PivotChart
Product
Microsoft Excel PivotTable and PivotChart
Device & OS
not provided
Scenario
A PivotTable calculates day-over-day changes and supplies the values for a PivotChart.
Observed behavior
Sorting the PivotChart produces a warning or an unexpected order because the chart inherits its order from the associated PivotTable.
Before you start

Identify the PivotTable connected to the chart and the value field that contains the day-over-day change. Check whether the change is calculated in the source data, displayed as a PivotTable value, or created as a calculated item.

Solution 1Recommended

Sort the PivotTable by the day-over-day change value

Use this method when the change is already available as a sortable value in the PivotTable.

1
Refresh the PivotTable

Click inside the PivotTable, then select PivotTable Analyze > Refresh to load the latest source data.

2
Sort by the change value

Right-click a number in the day-over-day change column and select Sort > Sort Largest to Smallest. If needed, use More Sort Options and choose the change value field.

3
Check the PivotChart

Select the PivotChart and confirm that its category order matches the sorted PivotTable and that it displays the intended change series.

Sort the PivotTable by the day-over-day change value
Check previous-item calculations: If the change uses Show Values As > Difference From with Previous as the base item, changing the item order can affect which item is treated as previous. Use a source-data helper column if the result is not reliable.
Work with PivotTables in WPS

Sort day-over-day changes with WPS Spreadsheet

Use a source-data helper column and a PivotTable in WPS Spreadsheet to calculate and sort changes before creating a chart.

  1. 1. Open the workbook: Open WPS Spreadsheet and select Open to choose your Excel workbook.
  2. 2. Calculate the changes: On the source worksheet, add a Day-over-Day Change column. For a single date-ordered series with values in column B, enter =B3-B2 in C3 and fill down, checking that each row compares the intended observations.
  3. 3. Create or update the PivotTable: Select the source data and choose Insert > PivotTable, or refresh an existing PivotTable after including the new column in its source range. Add the category field to rows and the change field to values.
  4. 4. Sort and chart the values: Right-click a change value in the PivotTable and choose the descending sort option. Select the resulting data and use Insert > Chart to create a chart, then verify the category order.
Calculate day-over-day changes in a source-data column.Sort PivotTable values from largest to smallest for charting.Open and save Microsoft Excel XLSX files.Use a familiar spreadsheet interface with free tools.
QA img-9

Frequently Asked Questions

Why won't my PivotChart sort independently?

A PivotChart follows the item order of its associated PivotTable. Sort the relevant value in the PivotTable, then check the chart.

How do I sort a PivotTable by change instead of date?

Right-click a value in the day-over-day change column and select Sort > Sort Largest to Smallest. In More Sort Options, select the change value field if Excel asks which value to use.

Why did my day-over-day values change after sorting?

If the value uses Difference From with Previous as its base item, sorting can change which item is treated as previous. Calculate the change in the source data if you need each date compared with a specific prior date.

What should I do if the new helper column is missing from the field list?

Click the PivotTable and select PivotTable Analyze > Change Data Source to include the helper column, then select Refresh. Look for the column header in the PivotTable Fields pane.