Sort Day-over-Day Changes in an Excel PivotChart
Question details
The user wants to sort an Excel PivotChart by day-over-day change from largest to smallest.

- 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.
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.
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.
Click inside the PivotTable, then select PivotTable Analyze > Refresh to load the latest source data.
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.
Select the PivotChart and confirm that its category order matches the sorted PivotTable and that it displays the intended change series.

Calculate the change in a source-data helper column
Use a helper column when Excel cannot reliably sort a calculated item or a previous-item calculation.
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. Open the workbook: Open WPS Spreadsheet and select Open to choose your Excel workbook.
- 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. 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. 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.

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.




