Create a PivotChart

Sometimes visualising the big picture can be difficult when your raw data hasn’t been collated. Your first action could be to create a PivotTable, but some people prefer other ways to decipher the meaning of numbers and their associated data. PivotCharts are an easy way to insert data visualisations to your data.

Household expense dataCorresponding PivotChart
Sample household expense data to create a PivotTable with Months, Categories and AmountsExample of an Excel PivotChart


Create a PivotChart

  1. Pick a cell in your table.
  1. Choose Insert > PivotChart PivotChart option on the ribbon .
  1. Press OK.

Create a chart from a PivotTable

  1. Choose a cell in your table.
  2. Click PivotTable Tools > Analyse > PivotChart PivotChart option on the ribbon .
  1. Pick a chart.
  1. Click OK.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Create a PivotTable

Use the Field List to arrange fields in a PivotTable

Use slicers to filter data

Create a PivotTable timeline to filter dates

Leave a Reply

%d bloggers like this: