- Open your Excel document
- In the worksheet, in an empty cell click the 'Insert' tab next to the 'Home' tab at the top of the worksheet and then click 'Insert Pivot Table'
- Drag your mouse over the column headers to select the data you intend to use
- Click 'OK'
- Select the fields you wish to use. e.g. 'Orders' and 'Age Range'
- Drag the field you're working with to the 'Rows' box
- Select all the fields and click 'Insert' and then 'Pie Chart
- Change the name of the chart