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