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 |
![]() | ![]() |
Windows
Create a PivotChart
- Pick a cell in your table.
- Choose Insert > PivotChart
.
- Press OK.
Create a chart from a PivotTable
- Choose a cell in your table.
- Click PivotTable Tools > Analyse > PivotChart
.
- Pick a chart.
- 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.