Excel Pivot Chart: Show Only Certain Columns

Yes. In Excel for Microsoft 365 on Windows, select the PivotChart and use the drop-down on the relevant field button to filter its categories or series; the chart will show only the items you keep. If you mean particular value columns, such as Sales but not Profit, remove or filter the corresponding value field instead. These actions usually affect the PivotTable connected to the chart, so the right method depends on whether you want to change both or only the chart.

What “columns” means in a PivotChart

People use “columns” to mean several things in a PivotChart. In a clustered column chart, the vertical bars represent data values, the horizontal axis usually lists categories, and the legend identifies series. For a chart of sales by month and region, months might be the categories while regions are the series. Filtering months removes selected groups along the horizontal axis; filtering regions removes selected colored bar series.

A third possibility is that your PivotTable has multiple measures, such as Sum of Sales and Sum of Profit, in its Values area. Those measures can appear as separate series in a chart. Removing Profit from the chart’s value fields is different from hiding a region or month. Identify which part you want to keep before changing the filter.

Filter categories to keep selected bars

Use this method when the chart contains too many categories—for example, you want to show only three products out of a dozen. A category filter controls which items from the field on the chart’s axis appear. In many layouts, its field button is displayed along the chart’s bottom edge.

Click the PivotChart. If its field buttons are hidden, open the PivotChart Analyze tab, choose Field Buttons, and choose Show All.
On the chart, click the drop-down for the axis field, such as Product or Month.
Clear Select All, select the items you want to retain, and click OK. The chart updates to show only those categories.

For example, a chart with twelve monthly categories can be filtered to show January, April, July, and October. The remaining months are omitted from the chart; Excel does not combine them into an “Other” bar. If the option to select multiple items is available, it must be enabled for the field’s filter menu to let you choose several individual entries.

Filter series to keep selected column groups

Use a series filter when the horizontal categories should stay in place but you want fewer colored bars per category. For example, a chart of quarterly sales by region might retain all four quarters while displaying only East and West. Find the field button associated with the legend or series field, open its drop-down, clear Select All, select East and West, and apply the filter.

The field button’s position can vary with the chart layout. If you are unsure which field it controls, click the chart and look at the field names shown on its buttons, or open the PivotChart Fields pane. The pane divides fields among areas such as Axis (Categories), Legend (Series), and Values. A field in Legend (Series) generally controls the separate colored series; a field in Axis (Categories) generally controls the labels along the bottom.

Show one value field and remove the others

If by columns you mean measures such as Sum of Sales and Sum of Profit, inspect the Values area in the PivotChart Fields pane. Clear or drag out the value field you do not want. For example, removing Sum of Profit leaves the chart displaying Sum of Sales. The chart’s appearance depends on the selected chart type and the remaining fields.

Be aware that a PivotChart is connected to its PivotTable. Changing a field or filter through the chart can change the associated PivotTable as well, and changing the PivotTable can change the chart. If the Values area contains several measures, removing one may also remove it from the PivotTable’s report. Check the table after editing if it is used for other analysis or reporting.

Use label and value filters for larger lists

For a field with many items, manually checking boxes can be inconvenient. The field menu may offer label filters and value filters, depending on the field and context. A label filter selects items based on their names—for example, products beginning with a particular word. A value filter selects items based on their summarized numbers, such as products whose total sales exceed a threshold.

To apply one, open the relevant field button’s menu and look for Label Filters or Value Filters. Choose a condition, provide the comparison value or text, and confirm it. The available conditions depend on the field and Excel’s current PivotTable layout. A value filter is useful for questions such as “Which products have sales above 10,000?” but it is not the same as sorting the chart: filtering removes items that do not meet the rule, while sorting changes their order.

Top 10 filters can also be useful when you want a compact chart of leading or trailing items. Check whether the filter is set to count items or summarize a particular value field, and confirm whether it means top or bottom. The result can change after refreshing the PivotTable if the source data or totals change.

Keep the PivotTable unchanged

PivotChart filters generally work with the PivotTable that supplies the chart, rather than acting like an independent filter on an ordinary chart. Consequently, filtering a category from the chart can hide it in the connected PivotTable too. If that side effect is not acceptable, choose a separate source for the chart.

Create a second PivotTable from the same source data and build a separate PivotChart from it. Apply the chart-specific filters to that second report. This keeps the original PivotTable’s layout and filter choices separate, although both reports may still refresh from the same source.
Use a regular chart built from a small helper range that references the PivotTable results. Choose only the categories or measures needed in that range, then insert a standard chart. The chart will not behave like a PivotChart, but its plotted range can be managed separately.
Copy the relevant results to a separate range if a fixed snapshot is more important than automatic updating. Remember that copied values will not change when the PivotTable refreshes.

Duplicating a PivotTable is often the most practical option when both reports need to remain refreshable. A normal chart is more flexible when the displayed selection must be independent, but it requires you to maintain the chart’s source range or helper formulas.

Use slicers for visible, repeatable filtering

A slicer provides clickable buttons for filtering a PivotTable or PivotChart field. To add one in Excel for Microsoft 365 on Windows, select the PivotTable or PivotChart and use PivotTable Analyze or PivotChart Analyze > Insert Slicer, then select the field and confirm. Select the slicer buttons for the items to show; use the slicer’s clear-filter control to remove its current selection.

Slicers are useful on dashboards because viewers can see which filter is applied without opening a small drop-down menu. They do not make the PivotChart independent of its connected PivotTable. If a slicer should control more than one report, use Report Connections (sometimes presented as PivotTable Connections) and select compatible PivotTables that share the relevant PivotCache or data model. If a report is unavailable in that list, the reports may not share a compatible source connection.

Common problems and fixes

The filter buttons are missing: Select the chart and use PivotChart Analyze > Field Buttons > Show All. If you want a cleaner presentation afterward, hide the buttons again; the filter selection remains in effect.
The wrong items disappear: Check whether you filtered the axis field or the legend field. The field button’s name and the PivotChart Fields pane help distinguish categories from series.
The PivotTable changed too: That is expected for a connected PivotChart. Restore the original filter or use a separate PivotTable or a regular chart for an independent view.
A category is missing even after clearing a filter: The source may contain no records for that category, the PivotTable may be hiding items with no data, or a different report filter may still be applied. Review all active field filters and refresh the PivotTable if its source has changed.
The chart does not update as expected: Check whether the PivotTable source range includes the new records, then refresh the PivotTable. A refresh cannot include records outside a fixed source range unless the source is expanded; formatting the source as an Excel table before creating the PivotTable can make later additions easier to include.

On Excel for Mac, the core approach is the same: use the PivotChart’s field controls or the PivotTable Fields pane to filter the relevant field. Ribbon wording and button placement can differ between Mac and Windows releases. Excel for the web also has fewer editing capabilities than the desktop app, so use the desktop version if a particular field-button or chart option is unavailable.

Frequently Asked Questions

Can I show only some columns in an Excel PivotChart?
Yes. Filter the axis field to limit categories, filter the legend field to limit series, or remove unwanted measures from Values. The correct control depends on what you mean by columns.

How do I show only certain months in a PivotChart?
Open the drop-down for the Month axis field, clear Select All, select the months to keep, and apply the selection. If Month is not on the chart axis, locate it in the PivotChart Fields pane first.

Can I filter a PivotChart without changing its PivotTable?
Usually not when they are connected: their fields and filters are linked. Use a separate PivotTable for a separate PivotChart, or create a regular chart from a helper range for a more independent display.

Why does my PivotChart show extra series?
A field in Legend (Series), or multiple fields in Values, may be creating them. Filter the series field or remove the unwanted value field in the PivotChart Fields pane.

Can I use a slicer to show only selected chart columns?
Yes. Insert a slicer for the relevant category or series field and click the items to display. The slicer filters the connected PivotTable and PivotChart, so it does not isolate the chart from the table.

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.