Bar Chart Pivot Table: How to Create and Format in Excel

A bar chart pivot table is a PivotChart that displays summarized PivotTable data as horizontal bars. In Excel for Microsoft 365 on Windows, select a cell in your PivotTable, choose PivotTable Analyze > PivotChart, select Bar, and choose a bar-chart subtype; Excel links the chart to the PivotTable so it changes when you filter or rearrange the summary.

What a bar chart pivot table means

The phrase usually refers to a bar PivotChart connected to a PivotTable, rather than a special kind of table. The PivotTable organizes and aggregates source records—for example, sales by product—while the chart turns those summarized values into a visual comparison. A horizontal bar chart places categories on the vertical axis and values along the horizontal axis.

This combination is useful when you want to compare categories and also explore the underlying summary without rebuilding a chart every time. You can move fields between rows, columns, filters, and values in the PivotTable Fields pane. The linked PivotChart reflects those changes, subject to the chart type and fields used.

For example, a sales list with Date, Region, Product, and Revenue columns could be summarized to show total revenue by product. A bar PivotChart would make it easy to spot the strongest products. Add Region as a filter or slicer to compare one region at a time, or put Region in the legend to show separate series for each region.

Prepare the source data

A PivotTable depends on a well-structured source. Put one header in each column and one record in each row. Avoid blank header cells, merged cells, and completely blank rows or columns inside the data. Keep each column consistent: for instance, store dates as dates and revenue as numbers rather than mixing numeric values with text such as “unknown.”

It is often helpful to convert the source range into an Excel Table before creating the PivotTable. Select a cell in the data and choose Insert > Table, confirm the range and whether it has headers, then select OK. A table can expand as records are added, which is more reliable than relying on a fixed range. If you already have a PivotTable, changing the source to a table may require updating its data source.

Check the grain of the data before summarizing it. If each row is one order line, summing Revenue by Product answers a different question from counting order lines by Product. Repeated customer or product names are normal; inconsistent spellings, such as “North” and “NORTH,” can produce separate categories.

Create the PivotTable and bar PivotChart

Select a cell in the source data. Choose Insert > PivotTable. Check the proposed table or range, select where to place the PivotTable, and choose OK.
In the PivotTable Fields pane, drag the category you want to compare, such as Product, to Rows. Drag the measure, such as Revenue, to Values. Excel will usually sum numeric values; text fields commonly default to a count.
Click inside the PivotTable, then choose PivotTable Analyze > PivotChart. In the Insert Chart dialog, select Bar, choose a subtype such as Clustered Bar, and select OK.
Resize and position the chart. Use the Chart Design and Format tabs to change its style, colors, labels, and layout. Rename the chart title so it states what is being compared and, where helpful, the unit or time period.

You can also start from source data: select a cell and use Insert > PivotChart. Excel creates a PivotChart with an associated PivotTable and lets you choose where to place it. The exact dialog arrangement can vary with the workbook and Excel update, but the essential task is assigning fields to categories and values.

Excel for Mac also supports PivotTables and PivotCharts, although ribbon labels and dialog layouts can differ slightly by release. If a command is not visible, look for PivotTable Analyze or the PivotChart command after selecting the PivotTable. Excel for the web has PivotTable and chart capabilities too, but some chart formatting and data-model options are more limited than in the Windows desktop app.

Choose the right bar-chart layout

Clustered Bar is a useful starting point when each category has one value, or when you want side-by-side comparisons across a small number of series. Stacked Bar displays series segments that add to a category total. Use it when both the total and each component matter. A 100% Stacked Bar shows each series as a share of the category total, making proportions easier to compare than absolute amounts.

These layouts answer different questions. If a chart shows revenue by product and Region is in the legend, a clustered chart compares regional revenue for each product. A stacked chart emphasizes total revenue by product and its regional makeup. A 100% stacked chart emphasizes the regional mix, but hides differences in total revenue because every bar has the same full length.

For many categories, bars can be easier to read than vertical columns because category names have room to sit beside the bars. If you have only a few time periods and the order of time is central, a column or line chart may communicate the pattern more naturally. Bar charts are best suited to comparing values across distinct categories, not showing a continuous trend by themselves.

Arrange fields and improve readability

The PivotTable Fields pane controls the chart’s structure. Rows generally become the chart’s category axis; Values become the plotted measurements; and Columns commonly become series shown in the legend. Filters can limit the records included. Dragging a field to another area changes the analysis, not just the appearance.

For a simple comparison, keep one category field and one value field. Adding multiple fields can create nested categories or many series, which may make the chart crowded. A useful review checklist is:

Give the chart a descriptive title, such as “Revenue by Product, 2025,” rather than leaving a generic title.
Confirm that the value field uses the intended summary—Sum, Count, Average, or another available calculation.
Format the value axis as currency, percentage, or a suitable number format when that helps interpretation.
Keep category labels readable and remove unnecessary legends, gridlines, or data labels if they add clutter.
Consider sorting the PivotTable values from largest to smallest when ranking is the main purpose.

Sorting and formatting the PivotTable can affect the chart order and labels. If the chart is difficult to scan, try shortening category names, filtering to a relevant subset, or splitting a crowded view into separate charts instead of shrinking the text.

Filter, refresh, and keep the chart current

A PivotChart can be filtered through its field buttons, the associated PivotTable, or controls such as slicers and timelines. To add a slicer, select the PivotTable and choose PivotTable Analyze > Insert Slicer, select the field, and choose OK. A timeline can be added for a date field when Excel recognizes it as a date. These controls are useful for interactive reports, but too many can make a dashboard harder to understand.

A chart does not necessarily include newly added source records immediately. If the source is an Excel Table, new rows are easier to include, but refresh the PivotTable to update its cached summary: right-click inside the PivotTable and choose Refresh, or use Data > Refresh All to update connections and PivotTables in the workbook. If new rows remain missing, check PivotTable Analyze > Change Data Source and confirm the full source is selected.

Refresh behavior matters when sharing workbooks. A recipient may see the last saved summary until the PivotTable is refreshed, depending on the workbook and data connection. For external or protected data sources, refresh can also depend on permissions and connection settings.

Common problems and fixes

If the chart shows Count of Revenue instead of Sum of Revenue, Excel may have interpreted some entries in that source column as text or found inconsistent data. Inspect the source values, correct the data type, and refresh. You can also open the value field settings from the PivotTable and select the intended summary, but a sum is meaningful only when the underlying entries are numeric.

If categories are missing, look for filters, blank values, or source records outside the PivotTable’s source range. If duplicate-looking labels appear, check for extra spaces, spelling differences, or inconsistent capitalization in the source. Fixing the source is usually better than hiding the symptoms in the chart.

If a PivotChart seems to change when you adjust a different PivotTable, the charts may share a PivotTable cache or be connected to the same underlying PivotTable. Review the field arrangement and filters, and consider creating a separate PivotTable if the two views need independent layouts. A standard chart based on a copied summary can be an alternative when independent chart behavior is more important than PivotTable interactivity.

Another common confusion is expecting a bar chart to display every source record. A PivotChart normally plots the summarized PivotTable, not the raw rows. If you need a point for each record, use a regular chart based on the source data or create a suitable summary first.

PivotChart versus a regular chart

A PivotChart is convenient when the report needs to be rearranged or filtered interactively. Its fields are tied to a PivotTable, and many changes to that PivotTable flow through to the chart. This makes it useful for exploratory analysis, recurring reports, and dashboards where the viewer needs to change categories or filter results.

A regular chart gives more direct control over a fixed range and can be simpler when the data layout is already final. It does not provide PivotChart field buttons or the same field-based rearrangement. Choose a PivotChart when exploration and linked summaries matter; choose a regular chart when you want a stable presentation or need chart behavior not supported by the PivotChart setup.

Frequently Asked Questions

How do I make a bar chart from a PivotTable in Excel?

Click inside the PivotTable, choose PivotTable Analyze > PivotChart, select Bar, choose a subtype such as Clustered Bar, and select OK. Put the category field in Rows and the numeric measure in Values before creating the chart.

What is the difference between a bar chart and a column chart?

Both compare categories using bars. A bar chart uses horizontal bars, with categories on the vertical axis; a column chart uses vertical bars, with categories on the horizontal axis. Horizontal bars often suit long labels, while columns can work well for a small number of categories or time periods.

Can I sort a PivotChart from highest to lowest?

Sort the associated PivotTable by the value field, usually by right-clicking a value and choosing a sort option such as Sort Largest to Smallest. The PivotChart follows the PivotTable’s category order. If the chart does not appear to change, check whether a filter or multiple series affects the view.

Why is my PivotChart showing counts instead of sums?

Excel may be treating the value column as text, or the field may be set to Count. Correct text-formatted numbers in the source, refresh the PivotTable, and check the value field summary settings. A field containing nonnumeric entries may default to Count.

Do PivotCharts update when new data is added?

They update after the associated PivotTable is refreshed, provided the PivotTable’s source includes the added rows. Using an Excel Table as the source helps its range expand, but a refresh is still generally needed to recalculate the summary and chart.

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.