How to create a Pie Chart in Microsoft Excel 2013
A pie chart is great for showing the way that 100% is divided between the items you are charting. I can either see how the coffee sales divide up among the months, or how each month divides up amongst the coffee types. As a pie chart looks at just 100% it is not used to compare, in the same way a column or bar chart are used.
Figure – a pie chart divides 100% into segments
- Select the data
- Click on the Insert Ribbon
- Click on the drop down below the Pie Chart Icon
- Choose which type of pie chart you want to use
- The pie chart Appears!
I am looking at how the different types of coffee divide up in January so I selected just the January figures with the types of coffee labels.
This topic has been taken from my free eBook on Microsoft Excel Core: Advanced 2013 which can be downloaded here:
To find out more about our training and to discuss your organisation’s learning needs, give us a call on 020 8203 1774 or email us email@example.com – we would love to chat.