Sarah has attended:
Excel Advanced course
Pie charts
how to create coloured pie chart of data from previous years' net profit
RE: pie charts
Best way to do this is to use the chart wizard.
1. Click the CHART WIZARD button on the toolbar.
2. Choose the pie chart option
3. Point the wizard to the relevant source data
4. Add any labels and heading you require
5. Select the location of the chart.
DONE.