Pivot Chart Examples for Excel: Sales, Trends, and More

Useful Excel PivotChart examples include monthly sales by region, expenses by department, inventory by product category, and support tickets by status. To make one in Excel for Microsoft 365 on Windows, select a table or data range, choose Insert > PivotChart, select where to place the PivotTable and chart, and arrange fields in the PivotChart Fields pane.

Practical PivotChart Examples

A PivotChart turns summarized data into a chart that can be rearranged and filtered through its associated PivotTable fields. The best examples start with a question, such as which region contributes the most revenue, rather than with a chart type chosen at random. These are common setups:

Sales by month and region: Put Order Date on the horizontal axis, Sales in Values, and Region in Legend (Series). A line chart can show how each region changes over time; a clustered column chart is useful for comparing regions month by month.
Revenue by product category: Put Category on the axis and Sales in Values. A bar chart makes it easy to rank categories, especially when labels are long.
Expenses by department: Use Department on the axis, Expense in Values, and Expense Type in Legend. A stacked column chart shows both total department spending and its composition.
Inventory by warehouse: Put Warehouse on the axis, Units in Values, and Product Category in Legend. A clustered bar chart can reveal where stock is concentrated.
Customer-service tickets by status: Use Status on the axis, Ticket ID in Values, and Priority in Legend. Set the value calculation to Count rather than Sum when each row represents one ticket.
Orders by sales channel and quarter: Use Order Date grouped by quarter on the axis, Order ID counted in Values, and Channel in Legend. This compares order volume rather than sales dollars.

These are layouts, not fixed templates. For example, a sales chart can answer a different question by putting Product in the axis, Month in the legend, and Sales in Values. The field arrangement determines what the chart emphasizes.

A Worked Sales-Analysis Scenario

Imagine a source table with one row per order line and columns for Order Date, Region, Product, Category, Units, and Sales. A manager wants to know whether each region’s sales are rising and which category contributes most. Make a PivotChart with Order Date on the axis, Sales in Values, and Region in Legend. Choose a line chart to compare the direction of each region’s monthly sales. Then use a date filter or timeline to focus on a particular period.

For the category question, rearrange the fields: put Category on the axis, Sales in Values, and Region in the legend. A clustered bar chart compares regional totals within each category. If the chart becomes crowded, remove Region from the legend or filter the chart to one region. The underlying source rows are unchanged; Excel recalculates the summary as the PivotTable fields or filters change.

Check the meaning of the values before interpreting the picture. If Sales contains transaction amounts, Sum is usually appropriate for revenue. If the goal is the typical order value, an average may be more relevant, but an average of order-line amounts is not necessarily the average of complete orders. The row structure and business question determine what the summary should mean.

How PivotCharts Work

A PivotChart is connected to a PivotTable, which groups and summarizes the source records. Its fields correspond to four areas: Axis (Categories), Legend (Series), Values, and Filters. In a sales chart, for instance, Month might define categories, Region might define series, and Sum of Sales supplies the plotted values. Dragging a field to another area changes the summary and the chart together.

Excel chooses a calculation based on the field and its data. Numeric fields are commonly summed, while text fields are commonly counted, but the default is not a guarantee that the result answers the right question. In the PivotTable, open the field’s value settings to select an available summary such as Sum, Count, or Average. The chart reflects that setting.

PivotCharts can also respond to PivotTable filters, slicers, and date controls. This makes them useful for exploring one dataset from several angles. A regular chart can be linked to ordinary worksheet cells, but it does not provide the same PivotTable field arrangement and filtering behavior.

Create a PivotChart in Excel

Organize the source data as a simple rectangular table: one header row, one record per row, no blank header cells, and consistent data types in each column. Converting the range to an Excel Table with Insert > Table helps the source expand when new rows are added.
Select a cell in the table or range. Choose Insert > PivotChart, confirm the table or range, and choose whether the PivotTable and chart should go on a new or existing worksheet. The exact dialog wording can vary slightly by Excel build.
In the PivotChart Fields pane, drag fields into Axis (Categories), Legend (Series), Values, and Filters. Start with one category field and one value field; add series only if the comparison remains readable.
Use the chart controls or Chart Design tab to choose a suitable chart type. For example, use a line chart for change over time, bars or columns for category comparisons, and a stacked chart when part-to-whole composition matters.
Review the PivotTable’s summarized figures and the chart title, units, and labels. If the source changes, refresh the PivotTable or use Data > Refresh All to update connected data.

On Excel for Mac, PivotTables and PivotCharts are available, although ribbon labels and dialog layouts can differ from Windows. Excel for the web also supports PivotTables and charts, but some creation, layout, and formatting controls may be more limited or appear differently. If a particular field arrangement is unavailable in the web interface, open the workbook in the desktop app.

Choose a Chart Type That Fits the Question

Chart type changes how readers interpret a summary. A line chart is generally suited to ordered time periods, while a bar or column chart is effective for comparing separate groups. A stacked chart can show component contributions, but it becomes hard to compare individual series when there are many categories or when precise comparisons across segments matter. A pie chart is usually most readable with a small number of parts that add to a meaningful whole.

Use a line chart for a time trend with a manageable number of series.
Use a clustered bar or column chart to compare groups side by side.
Use a stacked bar or column chart when both totals and composition are relevant.
Use a single-series bar chart to rank many categories; sort the PivotTable values to make the ranking clear.

Do not use a chart just because Excel offers it. A date field displayed as individual timestamps may create too many categories; grouping dates by month, quarter, or year can make the pattern visible. In a PivotTable, date grouping is available through the date field’s context menu when Excel recognizes the values as dates. Text-formatted dates or blank and invalid entries can prevent suitable grouping.

Filters, Slicers, and Refreshing

Filters let a reader focus on a subset without rebuilding the chart. A report filter can restrict the whole PivotChart to one region or year. A slicer presents clickable buttons for a field such as Region or Product Category, making the current selection visible. Select the PivotTable or PivotChart and use PivotTable Analyze > Insert Slicer; available commands can differ somewhat across Excel releases. For dates, Insert Timeline is available for PivotTables when the source contains recognized date values.

A slicer can control more than one PivotTable when those PivotTables share a compatible data source or PivotTable cache. Use the slicer’s Report Connections or PivotTable Connections option to choose connected reports. If a chart does not respond, check those connections and verify that the PivotTables can share the slicer.

When records are appended to an Excel Table, refresh the PivotTable so its summary includes them. A chart based on stale PivotTable results will also be stale. If the new records sit outside a fixed source range, update the PivotTable data source or convert the original range to a Table and confirm the PivotTable uses it.

Common Problems and Misconceptions

The chart shows counts instead of totals: Check the value field settings. Excel may count a field if it contains text or mixed types; clean the source and choose the intended summary.
Dates appear as separate labels: Confirm that the source values are real Excel dates, then group them at an appropriate level. A text date is not automatically equivalent to a date value.
New rows do not appear: Refresh the PivotTable and check that its data source includes the new records. An Excel Table can make an expanding source easier to manage.
The chart changes when the PivotTable changes: That is expected. A PivotChart is tied to its PivotTable’s fields and filters, so rearranging or filtering the table can alter the chart.
There are too many colors or labels: Remove unnecessary series, filter the categories, group dates, or use a sorted bar chart. More detail is not always more informative.

A related misconception is that a PivotChart is simply a normal chart with a different name. Its PivotTable connection is what enables field-based rearrangement and filtering, but it also means the chart behaves differently from a chart built directly from a manually maintained cell range. If you need a highly customized visual or a chart type not supported for PivotCharts, a regular chart based on summarized worksheet cells may be a better choice.

PivotChart or Regular Chart?

Choose a PivotChart when the viewer needs to interactively slice, regroup, or filter a summary, or when the data will be examined from multiple perspectives. It is especially effective for recurring reports in which a user may switch from region to product or from monthly to quarterly views without creating separate charts for every combination.

Choose a regular chart when the presentation needs a fixed layout, the source is already summarized, or precise control over plotted ranges and chart behavior is more important than PivotTable interaction. You can build a standard chart from PivotTable results, but it may need adjustment if the summarized range changes size. In either case, label the measure and period clearly, and make sure the chart’s filters do not conceal the scope of the data.

Frequently Asked Questions

What is a good example of a PivotChart?
A monthly sales-by-region line chart is a practical starting point: Month goes on the axis, Sales goes in Values, and Region goes in the legend. It shows both the sales trend and differences among regions.

What data do I need to create a PivotChart?
Use a rectangular list with one header row and one record per row. Clear headers and consistent values—especially in date and numeric columns—help Excel summarize the records accurately.

Can a PivotChart show percentages instead of totals?
Yes. In the PivotTable value field settings, use Show Values As options such as percent of grand total or percent of row or column total, where appropriate. Check the PivotTable result because each percentage answers a different question.

Why does changing my PivotTable change the chart?
The chart is linked to the PivotTable, so field moves, filters, and value calculations affect what it plots. That connection is the source of its interactive behavior, not a sign that the chart is broken.

Can I add a slicer to a PivotChart?
Yes. Insert a slicer for a PivotTable field and use it to filter the connected PivotTable and chart. If the workbook has multiple PivotTables, confirm that the slicer is connected to the intended reports.

Should I use a PivotChart or a normal chart?
Use a PivotChart for interactive summaries that readers will filter or regroup. Use a regular chart for a fixed presentation or when you need a chart setup that is not supported by PivotCharts.

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.