• 16 parts
  • Checked September 2026

Parts of a Pivot Chart

Every part of a pivot chart named on one drawing, from its field buttons to the field list.

Tap any part to read, rename or leave it out

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
More options

Each numbered ring is a button. Use the arrow keys to move between them and Enter to choose. Names are read out in Study, and once a part is answered.

All 16 parts on the diagram

Show the list

The chart 9

  1. Chart title Says what the chart shows, above the plot area.
  2. Legend The key: which color stands for which series.
  3. Plot area The space inside the axes where the bars are drawn.
  4. Data series One set of values, drawn as bars of one color.
  5. Value axis The scale that bar heights are read against.
  6. Category axis The axis that names each group of bars.
  7. Gridlines Lines across the plot at each step of the scale.
  8. Axis title Names what an axis measures.
  9. Data labels Each bar's value, written just above it.

Buttons and field list 7

  1. Report filter button Filters the whole chart to the items you pick.
  2. Axis field button Filters or sorts the field along the category axis.
  3. Legend field button Filters or sorts the field that makes the series.
  4. Filters area A field dropped here filters the whole chart.
  5. Columns area Fields here become the series in the legend.
  6. Rows area Fields here run along the category axis.
  7. Values area Numbers here are summed into the bar heights.

How this list was compiled: All read 2026-09-23 for the names only. (1) Microsoft Support, Overview of PivotTables and PivotCharts, https://support.microsoft.com/en-us/office/overview-of-pivottables-and-pivotcharts-527c8fa3-02c0-445a-a2db-7794676bce96: PivotCharts show data series, categories, data markers and axes as standard charts do, with titles, a legend and data labels. (2) Microsoft Learn, Chart.ShowReportFilterFieldButtons, Chart.ShowAxisFieldButtons, Chart.ShowLegendFieldButtons (https://learn.microsoft.com/en-us/office/vba/api/excel.chart.showaxisfieldbuttons and the pages beside it): the report filter, axis and legend field buttons on a PivotChart. (3) LibreOffice Help, Filtering Pivot Charts, https://help.libreoffice.org/latest/en-US/text/scalc/guide/pivotchart_filter.html: pivot chart field buttons are unique to pivot charts; filters are shown at the top, row fields at the bottom of the chart, and the legend shows the buttons of the column fields. (4) Microsoft Support, Use the Field List to arrange fields in a PivotTable, https://support.microsoft.com/en-us/office/use-the-field-list-to-arrange-fields-in-a-pivottable-43980e05-a585-4fcd-bd91-80160adfebec, and LibreOffice Help, Pivot Table, https://help.libreoffice.org/latest/en-US/text/scalc/01/12090102.html: the Filters, Columns (Column Fields), Rows (Row Fields) and Values (Data Fields) areas. (5) Microsoft Support, Create a chart from start to finish, https://support.microsoft.com/en-us/office/create-a-chart-from-start-to-finish-0baf399e-dd61-4e18-8a73-b3fd5d5680c2 (chart title, plot area, legend, axis titles, axis labels, gridlines; vertical (value) and horizontal (category) axis), and Wikipedia, Chart, https://en.wikipedia.org/wiki/Chart (title, axes and their labels, legend or key, gridlines). Licence: own work

The drawing: Drawn for this site by script, 2026-09-23. The chart is invented; no program or brand is shown. Licence: own work

How it works

A pivot chart has the parts of any chart (title, plot area, axes, legend, data series) plus field buttons that filter it, fed by the four areas of the field list: Filters, Columns, Rows and Values.

Read the full guide

Where each field goes

Rows fields run along the category axis and get the axis field button. Columns fields become the series and put their button over the legend. Filters fields go to the report filter button at the top, and Values fields set the bar heights.

Quiz and print

Quiz me asks the chart parts first, then the buttons and the field list. Print it blank, with lines to write on, or labeled as the key.

  • Field buttons can be hidden before you print or share a pivot chart; the chart itself does not change.

Questions and answers

What is the difference between a pivot chart and a regular chart?

A pivot chart is drawn from a pivot table and changes when the table does. It carries field buttons that a regular chart lacks, so you can filter and rearrange it on the chart itself.

What are the field buttons on a pivot chart?

The report filter button at the top filters the whole chart. The axis field button at the bottom works on the categories, and the legend field button on the series. Each opens a list to filter or sort.

What do the four areas of the field list do?

Filters limit the whole chart, Rows set the categories along the horizontal axis, Columns set the series shown in the legend, and Values hold the numbers summed into the bar heights.