Pivot Chart Formatting Options in Excel 365 Explained

In Excel for Microsoft 365 on Windows, format a PivotChart with the contextual Chart Design and Format tabs: adjust its chart type, layout, colors, titles, axes, labels, legend, and individual series. Select the chart to reveal those tabs, then use the chart’s field buttons, filters, or connected slicers to control which PivotTable data it displays.

What a PivotChart is and what formatting controls

A PivotChart is a chart linked to a PivotTable. Its categories, series, and values come from the PivotTable’s fields, so changing a field arrangement or filter can change the chart’s content. Formatting controls the presentation of that content; it does not normally change the underlying calculation or the PivotTable’s source data.

This link is useful for exploring data interactively. For example, a PivotTable might summarize sales by month and product category. A PivotChart can display the monthly totals as columns, while a report filter or slicer narrows the view to one region. The chart updates to reflect the PivotTable selection.

To create one, select a cell in the PivotTable and choose PivotTable Analyze > PivotChart, then select a chart type. You can also create a PivotTable and PivotChart together from a data range using Insert > PivotChart. Exact ribbon labels can vary slightly with window size or Excel updates, but selecting the chart exposes the chart-specific tabs.

Chart type, layout, and style options

The chart type is one of the most consequential choices because it affects how readers interpret comparisons and trends. Use columns or bars to compare categories, lines to emphasize change over an ordered time scale, and a pie chart only for a small set of parts that make up a meaningful whole. A stacked chart shows composition as well as totals, but can make comparisons between middle segments harder.

With the chart selected, use Chart Design > Change Chart Type to choose a different supported type. The same tab offers Add Chart Element for elements such as titles, axis titles, data labels, gridlines, and a legend. Quick Layout applies a set of element placements, while the chart style gallery changes the overall visual treatment. These are starting points: individual elements can still be adjusted afterward.

Keep the chart type aligned with the question. If the example is monthly sales by category, clustered columns make side-by-side comparisons visible; a line chart may better show the direction of each category over time. Avoid adding decorative effects that compete with the data. Three-dimensional effects, for instance, can distort apparent sizes and make comparisons less reliable.

Titles, axes, labels, and number formats

A descriptive chart title should say what is being summarized and, when useful, identify the time period or unit. Add or edit a title through Chart Design > Add Chart Element > Chart Title, or select the existing title and type. Axis titles can clarify units such as dollars, units sold, or months. If a title needs to update with a worksheet cell, select the chart title, click the formula bar, type a reference such as =Sheet1!$A$1, and press Enter. The referenced cell supplies the displayed title.

For more control, right-click an axis and choose Format Axis. The Format Axis pane can provide settings for bounds, units, tick marks, label position, and number formatting, depending on the selected axis and chart. For example, setting a value axis minimum to zero can make column comparisons easier to judge. A nonzero minimum may be appropriate in some contexts, but make the scale clear because it can exaggerate differences.

Data labels can show values directly on bars, columns, points, or slices. Add them through Chart Design > Add Chart Element > Data Labels, then use the label-formatting options to choose placement and displayed details. Labels are helpful when readers need exact values, but can clutter charts with many categories. Consider labeling only a few important points or using a clear axis instead.

For a PivotChart based on currency or percentages, format the PivotTable value field as well as the chart where appropriate. In the PivotTable, right-click a value, choose Value Field Settings, then Number Format. This sets the number format for that value field and is generally more reliable across refreshes than changing only how a chart label looks. Check the chart afterward, since axis and data-label formatting may have separate settings.

Colors, fonts, and individual data series

Use Chart Design > Change Colors to apply a coordinated palette, or choose a style from the chart-style gallery. For a specific series, select one of its bars, lines, or points and use the Format tab or right-click and choose Format Data Series. The formatting pane may offer fill, outline, marker, and line settings depending on the chart type. Selecting a single data point a second time can let you format that point separately.

Consistent color helps readers recognize a category across reports. Use colors with enough contrast against the chart background, and do not rely on color alone to communicate a critical distinction. Direct labels, clear legends, and sensible category names help readers who cannot distinguish particular colors. Keep fonts readable at the chart’s final size; a chart that looks clear on a large monitor may become difficult to read when pasted into a slide or printed.

To change the chart area or plot area, select the relevant region and open its formatting options. The chart area includes the full chart object; the plot area is where the data is drawn. Distinguishing them is useful when, for example, you want a clean white plot area but a different background around the title and legend. Avoid background fills or borders that make the data harder to see.

Field buttons, filters, and slicers

PivotCharts can show field buttons over the chart. These let users filter or rearrange fields directly, but they can obscure labels or make a presentation chart look busy. To hide them, select the chart and choose PivotChart Analyze > Field Buttons > Hide All. The field buttons are controls, not part of the plotted data, so hiding them does not remove the corresponding fields or filters from the PivotTable.

For a more polished interactive report, use slicers. Select the PivotTable and choose PivotTable Analyze > Insert Slicer, then select the fields to filter. A timeline can be inserted for a date field when the PivotTable supports it, using PivotTable Analyze > Insert Timeline. If several PivotTables share the same source or compatible PivotCache, a slicer can sometimes control more than one: select the slicer and use Slicer > Report Connections or PivotTable Connections, where available, to choose the connected reports.

Before hiding field buttons, make sure readers still have an obvious way to change the view if interactivity is part of the report’s purpose. A chart intended as a static snapshot may not need visible controls; a dashboard intended for exploration should provide accessible slicers or clearly documented filters.

What happens when the PivotTable changes or refreshes

Because the chart is linked to a PivotTable, refreshing its source or changing the PivotTable layout can alter what the chart displays. A refresh can add new categories, remove categories no longer present, or change totals. Formatting applied to a particular series, point, or axis may not always behave as expected when the chart’s structure changes. Check the chart after refreshes, especially if the source data gains new products, dates, or regions.

If formatting of the PivotTable’s value cells is being lost, right-click the PivotTable and choose PivotTable Options. On the Layout & Format tab, review Preserve cell formatting on update. This option concerns PivotTable cell formatting; it is not a universal switch that preserves every chart setting. For a chart-specific number display, set the value field’s number format and verify the axis or labels after updating.

For a recurring report, test a refresh with representative new data before distributing the workbook. Confirm that the chart still has the intended series, title, axis scale, number format, and filter state. Keep the PivotTable and chart together in a sensible worksheet layout so users can see how the visual relates to its summary data.

Limitations and choosing between chart types

PivotCharts are designed to visualize PivotTable summaries, not to act like fully independent charts based on arbitrary cell ranges. Their series and categories are controlled by the PivotTable fields, so you cannot freely edit the chart’s data series in the same way as a standard chart. Some chart types are not available for PivotCharts, including XY (scatter), stock, and bubble charts. If you need one of these, or need to combine data series that do not fit the PivotTable layout, consider building a regular chart from a separate summary range.

Use a PivotChart when users need to filter, group, or rearrange summarized data and see the chart respond. Use a standard chart when the data arrangement is fixed, you need a chart type that PivotCharts do not support, or you need precise control over series drawn from different ranges. A standard chart can still be based on values calculated from a PivotTable, but it will not have the same direct PivotChart field controls.

Chart-type availability and controls can differ by chart structure and Excel version. Excel for the web supports working with many charts but may not expose every advanced formatting or PivotChart command available in desktop Excel. Excel for Mac also has chart and PivotTable tools, though ribbon placement and some options can differ from Windows; use the chart-specific tabs and formatting pane available in that version rather than assuming every Windows command is in the same location.

Common formatting problems and practical fixes

The chart looks crowded: hide field buttons, reduce unnecessary gridlines, shorten category labels, or move the legend. Remove data labels that repeat information already easy to read from the axis.
The colors change the wrong thing: click the intended series once to select the whole series. If you need one point only, select that point again before applying formatting.
The chart shows unexpected categories: inspect the PivotTable field filters and slicers. The chart reflects the PivotTable’s current selection, so changing a chart style will not correct a filter.
Numbers display as decimals or without currency: format the PivotTable value field using Value Field Settings > Number Format, then check the chart axis and labels separately.
A refresh changes the layout: check for new or missing categories and verify axis bounds and series formatting after refresh. Do not assume the previous visual arrangement remains appropriate for changed data.

For accessibility and readability, give the chart a meaningful title, use sufficient contrast, and ensure that the takeaway is understandable without relying only on color. If the chart is shared as an image or printed, include enough context—such as units and period—that it remains interpretable outside the workbook.

Frequently Asked Questions

How do I change the colors in an Excel PivotChart?
Select the chart and choose Chart Design > Change Colors for a palette, or select a specific series and use its formatting options to change its fill or line.

How do I remove the filter buttons from a PivotChart?
Select the chart, then choose PivotChart Analyze > Field Buttons > Hide All. This hides the on-chart controls; it does not remove the PivotTable fields or change the chart data.

Can I add data labels to a PivotChart?
Yes. Select the chart and choose Chart Design > Add Chart Element > Data Labels. Choose a position, then check that labels remain readable and do not overlap.

Can I change a PivotChart to a scatter chart?
No. XY (scatter), stock, and bubble charts are among the chart types not supported as PivotCharts. Create a standard chart from a suitable worksheet range if you need one of those types.

Why does my PivotChart change after I refresh the data?
The chart reflects its linked PivotTable. A refresh can add or remove categories and change the data structure, which may affect the displayed series or formatting. Review the chart after refreshing.

Can I format a PivotChart without changing the PivotTable?
You can change chart presentation—such as its title, colors, labels, and axis display—without changing the PivotTable’s layout. However, the chart’s underlying categories and values still come from that PivotTable and its filters.

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.