Delta Pivot Chart in Excel: Meaning and How to Build One

A “Delta PivotChart” is not a separate, built-in Excel chart type. It usually means a PivotChart that displays the change, or delta, between periods or categories; in Microsoft Excel for Microsoft 365 on Windows, you can calculate that change in a PivotTable with Show Values As > Difference From, then chart the result.

What “delta” means in a PivotChart

Delta is a general term for the difference between two values. Depending on the question, it can mean an absolute change, such as sales rising by $1,500, or a relative change, such as sales rising by 12.5%. A PivotChart is Excel’s chart linked to a PivotTable, so it can display summarized source data and respond to PivotTable filters. “Delta PivotChart” describes a way of using those tools together, not an official feature name or a special chart format.

For example, suppose monthly sales are $12,000 in January, $13,500 in February, and $11,900 in March. The month-to-month deltas are +$1,500 for February and −$1,600 for March. A chart of the original totals answers “How much did we sell?” A chart of the deltas answers “How much did sales change?” That distinction matters: a positive delta is an increase, while a negative delta is a decrease.

How the PivotTable calculates the change

A PivotTable first summarizes the underlying records, such as by summing sales for each month. Its Show Values As options can then display a value as a difference from another item. For a sequential comparison, choose the relevant date or period field as the base field and Previous as the base item. Excel subtracts the earlier item’s summarized value from the current item’s value. The first item normally has no earlier comparison and therefore appears blank.

This is different from adding a new “delta” column to every row in the original transaction data. The PivotTable calculation happens after aggregation. That is useful when the source has many individual sales records: Excel compares the monthly totals, rather than comparing one transaction with another. It also means the result follows the PivotTable’s grouping and filters. If a filter removes a period or changes the items being shown, inspect the comparison carefully because the displayed sequence may no longer represent the comparison you intended.

Build a month-to-month delta PivotChart

Start with a clean source range containing a date or period, a category if needed, and a numeric measure such as Sales. Use one header row, avoid blank rows and merged cells, and make sure dates are genuine Excel dates rather than text that merely looks like a date. For a growing source, format the records as an Excel table with Insert > Table; a table is easier to extend than a fixed range.

Select a cell in the source data and choose Insert > PivotChart. In the dialog, confirm the table or range and choose where to place the PivotTable and chart.
In the PivotChart Fields pane, drag the date or period field to Axis (Categories) and Sales to Values. Check that Excel summarizes sales as Sum, not Count. If the dates are individual days, group them into the required period in the PivotTable: right-click a date and choose Group, then select the desired units, such as Months and Years.
Drag Sales into Values a second time. The PivotTable will now show two copies of the measure, which lets one show the total and the other show its change.
In the PivotTable, right-click a number in the second Sales value field and choose Show Values As > Difference From. If that option is not visible in the context menu, open Value Field Settings, use the Show Values As tab, and select Difference From there.
Set Base field to the period field and Base item to Previous. If you grouped dates, select the period level that represents the sequence you want to compare. Rename the second value field to something clear, such as Monthly Delta, and format it as currency or another appropriate number format.
Review the PivotChart. It should now display the delta series, or both the original total and delta if both value fields are plotted. Add a descriptive title and verify that the category order is chronological before sharing it.

For instance, with the example totals above, the delta series should show January as blank, February as +$1,500, and March as −$1,600. If the chart shows a large difference between January and March rather than between neighboring months, check the base item and the order of the periods.

Choose the right delta and chart design

Use an absolute delta when readers need the size of the change in the original unit: dollars, units sold, hours, or cases. Use a percentage change when they need to compare relative movement across categories with different scales. These are not interchangeable. An increase of $1,000 is substantial for a $2,000 baseline but modest for a $200,000 baseline.

The built-in Difference From display produces an absolute difference. For a percentage comparison, use Show Values As > % Difference From and set the same base field and base item. This calculates the relative change against the selected comparison item. A zero or missing baseline can make a percentage comparison undefined or misleading, so explain how those cases are treated.

Column chart: useful for comparing a small number of period-to-period changes. Positive and negative columns make increases and decreases easy to spot.
Line chart: useful when the sequence is long and the direction of change matters. A delta line crossing zero indicates a switch between increases and decreases.
Bar chart: useful when comparing deltas across many named categories, especially when labels are long.

Keep a zero reference visible where possible, use a consistent number format, and label negative values clearly. If the chart includes both totals and deltas, the totals may be much larger in scale than the changes. A standard chart can then make the delta hard to read. Consider separate charts or a carefully designed summary instead of forcing unlike measures onto one scale.

When a formula or separate summary is better

Difference From is convenient for a straightforward comparison to the previous item in a PivotTable. It is less suitable when the required baseline is a fixed month, a custom period, a budget, or another measure that is not simply the preceding item. In those cases, a separate summary table with explicit comparison columns can make the logic easier to inspect and explain.

For example, if a summary table has month names in A2:A4 and monthly totals in C2:C4, with January in row 2 and February in row 3, enter this in D3 to calculate February’s change from January: =C3-C2. If January is $12,000 and February is $13,500, the result is $1,500. With the same layout, enter this in E3 for the relative change: =(C3-C2)/C2. The result is 12.5%; format E3 as a percentage. These formulas assume the rows are in chronological order and compare adjacent rows. Copy them down to compare each period with the row immediately above.

A formula-based summary is also useful when you need a custom comparison that should not change when a PivotTable is filtered. The trade-off is that you must maintain the summary and its formulas as new periods arrive. If you use formulas beside a PivotTable, keep them outside the PivotTable’s expanding area so a refresh does not overwrite them.

Common problems and checks

A chart that appears to show totals rather than deltas often has the wrong value field selected, or the Difference From setting was applied to the first copy of Sales instead of the second. Check the PivotTable first; the chart reflects its contents. If the PivotTable itself is wrong, the chart will not fix it.

Dates sort alphabetically or group unexpectedly: check that the source values are real dates, not text. Remove blanks or invalid date entries, refresh the PivotTable, and sort the date field chronologically.
The first period is blank: that is normal when there is no earlier item for comparison. Do not interpret the blank as zero change.
The delta seems to skip a period: inspect the order and grouping of the base field. Grouping by month name alone can combine the same month from different years; use year-aware periods when comparing across multiple years.
Changes look implausibly large: verify that Sales is summarized by Sum and that the base item is Previous. A Count, Average, or unintended base item will answer a different question.
The chart does not update after adding records: refresh the PivotTable and confirm the source includes the new rows. An Excel table used as the source usually expands more reliably than a manually fixed range.

Also check whether missing periods are absent from the source. If no records exist for a month, the PivotTable may omit it, which can make Previous refer to the previous displayed item rather than an assumed zero for the missing month. Decide whether a missing period means zero activity, unavailable data, or an excluded period, and represent that meaning explicitly before interpreting the chart.

PivotChart behavior and alternatives

A PivotChart is interactive: its filters and field buttons are connected to the underlying PivotTable. Filtering to one product, region, or year can help investigate which parts of the business account for a change. Refresh the PivotTable when the source data changes; a PivotChart does not automatically guarantee that new source rows have been included.

Use a regular chart based on a separate summary range when you need more control over chart formatting or custom comparisons. A standard chart can plot formulas that compare selected periods or compare actual results with a target. The PivotChart is often faster to explore, while a regular chart can be easier to tailor for a fixed report. If you share a workbook, explain whether the chart is intended to update with PivotTable filters or to present a fixed comparison.

On Excel for Mac, PivotTable and PivotChart capabilities are broadly similar, but ribbon placement and some dialogs can differ by release. The Windows ribbon paths above may not match the Mac interface exactly; look for PivotTable Analyze or the equivalent PivotTable options after selecting the PivotTable. Excel for the web has more limited PivotTable editing and chart controls than the Windows desktop app, so use desktop Excel if a needed grouping or value-display option is unavailable.

Frequently Asked Questions

Is Delta PivotChart an official Excel chart type?
No. Excel offers PivotCharts and PivotTable calculations such as Difference From and % Difference From. “Delta PivotChart” is an informal description of a PivotChart displaying a change measure.

Can a PivotChart show month-over-month percentage change?
Yes. Add the value field to the PivotTable, choose Show Values As > % Difference From, and set the period field and Previous as the base field and item. Check how zero or missing prior values are represented before drawing conclusions.

Why is the first delta blank?
A period-to-period difference needs an earlier period as its baseline. The first displayed period has no previous item, so Excel has no comparison to calculate.

Can I compare this month with the same month last year?
Yes, but Previous is not the right baseline if the goal is a year-over-year comparison. Use a year-aware PivotTable layout and select the appropriate prior-year item where available, or create a separate summary that explicitly matches each month with the same month in the previous year.

Why does the delta change when I filter the PivotChart?
The chart is linked to its PivotTable, and the PivotTable recalculates based on its visible items and filters. Check that the filtered sequence still contains the intended baseline period; otherwise the comparison may answer a different question.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.