How to create a Pie Chart in Microsoft Excel 2013

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.

Pie chart

Figure - a pie chart divides 100% into segments

Figure – a pie chart divides 100% into segments

  1. Select the data
  2. Click on the Insert Ribbon
  3. Click on the drop down below the Pie Chart Icon
  4. Choose which type of pie chart you want to use
  5. 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.

 

Happy Learning!

Shelley Fishel

This topic has been taken from my free eBook on Microsoft Excel Core: Advanced 2013 which can be downloaded here:

excel-2013-core-part-ii (1)

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 enquiries@theittrainingsurgery.com – we would love to chat.

Related Posts Plugin for WordPress, Blogger...

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge
 
Textbox Section
 

Terms & Conditions

Welcome to the IT Training Surgery Website. Here are the legal pages for using this site. Please …

Contact us

Would you like to talk through your IT Training needs? Just send through your details and we'll get back to you.