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 data	Corresponding PivotChart

https://www.microsoft.com/en-us/videoplayer/embed/RWfjsm?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us

Windows

Create a PivotChart

1. Pick a cell in your table.

2. Choose Insert > PivotChart  .

3. Press OK.

Create a chart from a PivotTable

1. Choose a cell in your table.
2. Click PivotTable Tools > Analyse > PivotChart  .

3. Pick a chart.

4. 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