Yes. In Excel for Microsoft 365 on Windows, select a cell in your PivotTable, choose PivotTable Analyze > PivotChart, then select Bar > Stacked Bar and click OK. Put the category field on the axis, the parts you want to compare in the legend, and the numeric field in Values; the chart will follow the PivotTable’s filters and layout.
What a stacked bar PivotChart shows
A stacked bar chart uses horizontal bars to show a total split into component series. Each bar represents a category, and each colored segment represents one part of that category’s total. For example, a chart could show quarterly sales by region, with one bar per quarter and colored segments for each region. The segment lengths show the regions’ contributions, while the complete bar gives the combined sales for that quarter.
In Excel, a chart created from a PivotTable is a PivotChart. It is connected to the PivotTable, so filtering or rearranging the underlying fields changes the chart too. This is useful when you want to explore summarized data interactively rather than maintain a separate chart range. A regular stacked bar chart can also be made from summarized data, but it does not automatically share a PivotTable’s field layout and filters.
Do not confuse a stacked bar chart with a stacked column chart. Bars run horizontally; columns run vertically. Both can display the same data, so the choice is mainly about readability and the kind of comparison you want to emphasize.
Arrange the source data and PivotTable fields
A PivotTable works best when its source is a rectangular list with one header row, one record per row, and no merged cells or entirely blank rows within the list. For instance, a sales list might have columns for Date, Region, Product, and Amount. Each row records one transaction or other observation. Consistent field names and data types make it easier for Excel to summarize and group the data correctly.
When you create or arrange the PivotTable, think of the chart as a comparison of categories and components. For a chart of quarterly sales split by region, a useful starting arrangement is:
- Rows / Axis (Categories): Quarter, so each quarter has one horizontal bar.
- Columns / Legend (Series): Region, so each region becomes a colored segment.
- Values: Amount, summarized as Sum rather than Count if the field contains numeric sales amounts.
- Filters: An optional field such as Product, if you want to filter the report without adding another segment.
Excel may put a numeric field into Values as Sum or Count depending on the source data it detects. If the result says Count of Amount when you expect a total, inspect the source column for text values, blanks, or inconsistent entries. In the PivotTable, open the field’s value settings and choose Sum when the data supports summing.
Create the chart from an existing PivotTable
With the fields arranged, click a cell inside the PivotTable. On Windows, use PivotTable Analyze > PivotChart. In the Insert Chart window, choose Bar, select Stacked Bar (not Clustered Bar or 100% Stacked Bar), and confirm. Excel inserts a chart connected to the PivotTable. Depending on the workbook and ribbon layout, chart-specific options appear when the chart is selected.
You can also build a PivotChart while creating a PivotTable: select the source data, choose Insert > PivotChart, and follow the prompts to choose where the PivotTable and chart should go. Starting with an existing PivotTable is often easier when you have already checked the field arrangement and aggregation.
To change the chart type later, select the chart and choose Chart Design > Change Chart Type, then choose the desired option under Bar. If you already have an ordinary chart rather than a PivotChart, changing its type does not connect it to a PivotTable; you need to create a PivotChart from the PivotTable to get that connection.
Choose between stacked and 100% stacked bars
A standard Stacked Bar chart preserves the actual values. Bar lengths can therefore be compared to see which categories have larger totals, while segments show the contributions to those totals. Use it when both the total amount and the composition matter—for example, comparing the number of support requests across teams while showing how many belong to each request type.
A 100% Stacked Bar chart scales every bar to the same length. It emphasizes the percentage mix within each category, not differences in total size. A team with 20 requests and a team with 200 requests will each fill the same full bar, so the chart alone will not reveal that one team handled ten times as many. If totals matter too, include them in labels, a companion table, or a separate chart.
Use a standard stack when quantities are meaningful and comparable. Choose 100% stacking when relative proportions are the main question. Neither choice makes the other information disappear from the source, but the visual emphasis changes substantially.
Format the chart for clear comparisons
Start with an informative chart title that states the measure and grouping, such as Sales by Quarter and Region. If Excel adds field buttons to the chart, you can use them to filter or change fields; you can also hide them when they distract from a presentation. Select the chart and look for PivotChart Analyze > Field Buttons to control their display. Their availability and exact placement can depend on the selected chart and ribbon layout.
Consider adding data labels when readers need exact values, but avoid labeling every segment if the chart becomes crowded. For a chart with many categories, sort the PivotTable categories in a meaningful order, such as chronological order, or sort by a relevant total when ranking is the goal. If categories appear in an unexpected top-to-bottom order, select the category axis and check its formatting options; Excel may display the category order in a way that differs from the PivotTable’s row order.
Keep the number of series manageable. A stacked bar with many tiny segments can be hard to read, especially when colors are similar. Use a consistent, distinct color for each series and keep the legend visible. If readers need to compare one component precisely across many categories, a clustered bar chart may communicate that comparison better because the bars for that component share a common baseline.
Refresh the PivotTable and keep new records included
A PivotChart reflects the PivotTable, and the PivotTable may need a refresh after its source data changes. Choose Data > Refresh All to refresh workbook connections and PivotTables, or use the PivotTable’s refresh command. If you add records outside the original source range, refreshing alone may not include them: the PivotTable’s data source must cover the new rows.
One practical way to make a source list expand as records are added is to format it as an Excel Table before creating the PivotTable. Select the source list and choose Insert > Table, confirming that the table has headers. Use that table as the PivotTable source. After adding records to the table, refresh the PivotTable so the summary and chart include them. If the PivotTable was made from a fixed cell range instead, use PivotTable Analyze > Change Data Source to check or update the range.
Common problems and what to check
- The chart is clustered instead of stacked: Select the chart and use Chart Design > Change Chart Type > Bar > Stacked Bar.
- There is only one color or one segment: Check that the field intended to split each bar is in Columns / Legend (Series), not only in Filters or Rows.
- The chart shows counts instead of totals: Check the Value Field Settings and the source values. Text-formatted numbers can lead Excel to count records instead of summing amounts.
- New rows do not appear: Refresh, then verify that the PivotTable source includes those rows. A fixed range does not necessarily grow when data is appended.
- Totals are hard to compare: Confirm you chose standard Stacked Bar, not 100% Stacked Bar. The latter deliberately makes every bar the same overall length.
- Labels or segments are confusing: Reduce the number of series, improve category sorting, or use a clustered chart if comparing individual series is more important than showing a total.
Negative values need special care. In a stacked chart, positive and negative values are plotted on opposite sides of the zero baseline, so the visual may not read like a simple sum of positive contributions. If your data includes returns, losses, or adjustments, explain the sign convention and inspect whether stacking is the clearest way to present it.
PivotChart versus a regular chart
A PivotChart is a good fit when you want the chart to respond to PivotTable filters, slicers, or changes in field arrangement. It is also convenient for summarizing a large list without first building a separate summary range. The trade-off is that chart structure is tied to the PivotTable: moving a field can change the chart, and the chart is not simply an independent view of arbitrary worksheet cells.
A regular chart can be preferable when you need a highly customized layout, want to plot a hand-built summary, or need chart behavior that is not available for the PivotChart setup you are using. You can copy PivotTable results to a separate range and build a standard chart from that range, but those copied values may not update automatically. A formula-driven summary or refreshed reporting process may be needed if the source changes often.
Excel on Mac and Excel for the web
The steps above use Excel for Microsoft 365 on Windows. Excel for Mac also supports PivotTables and PivotCharts, but ribbon placement and dialog details can vary by release. Select the PivotTable and look for PivotChart on the PivotTable or Insert ribbon, then choose the stacked bar type. If you cannot find a particular formatting control, check the chart-specific ribbon tabs after selecting the chart.
Excel for the web can handle many workbook and PivotTable tasks, but some chart creation and formatting controls differ from the desktop application and may not be available in every situation. If the web interface does not offer the PivotChart option or formatting you need, open the workbook in the desktop Excel app. The PivotChart remains part of the workbook and can be edited there.
Frequently Asked Questions
Can you make a stacked bar chart directly from a PivotTable?
Yes. Select a PivotTable cell, choose PivotTable Analyze > PivotChart, then choose Bar > Stacked Bar. The chart is linked to the PivotTable.
What is the difference between stacked bar and 100% stacked bar?
Stacked Bar shows actual values and total bar lengths. 100% Stacked Bar makes every bar the same length to emphasize the proportions of its component series, so totals are not apparent from bar length.
Why does my PivotChart show Count instead of Sum?
Excel may have detected text, blanks, or inconsistent values in the source field, or the value field may be set to Count. Check the source data and the field’s value settings; select Sum when it is appropriate for the data.
How do I add another series to a PivotChart?
Add or drag the relevant categorical field into the PivotTable’s Columns area, which corresponds to the chart legend series. Refresh the PivotTable first if the field or its new values come from recently added source records.
Why are new rows missing from the chart?
Refresh the PivotTable and confirm its source includes the added rows. A PivotTable based on an Excel Table can use the table’s expanded range after a refresh; a PivotTable based on a fixed range may need its data source changed.
Related
- Excel Custom Number Format for Millions
- Excel Custom Number Format: Show Numbers in Thousands
- Excel Shortcut to Select the Rest of a Column Down
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Put a Pivot Table in Google Sheets: Step by StepTo put a pivot table in Google Sheets, select a cell in your data, choose Insert > Pivot…
- Excel to PowerPoint Org Chart: Build and Update ItTo make an Excel org chart in PowerPoint, organize the people and reporting relationships in Excel, then create…
- Double Doughnut Chart in Excel: How to Create OneTo create a double doughnut chart in Excel for Microsoft 365, put the category names in the first…
- Excel Pie Chart: How to Change the Order of SlicesTo change the order of slices in an Excel pie chart, reorder the category and value rows in…
- Excel Pivot Table: How to Remove Zero ValuesTo remove zero-valued results from an Excel PivotTable, open the drop-down for the row or column field, choose…
- Stacked Bar Chart in Excel: How to Add and Format OneTo add a stacked bar chart in Excel for Microsoft 365 on Windows, select a table with category…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.