Exam 77-420 Microsoft Excel 2013
5. Create Charts and Objects 
5.1 Create a Chart: Select the Range

Insert ->Charts-> Insert Pie or Doughnut Chart
graphic2
graphic3
no

Create a Pie Chart

Our goal is to show the percentage of cost that comes from the apples, basket, bow and box. A pie chart is a good way to represent the data.

 

1. Try it: Insert a Pie Chart

Select Cells A1 through B6.

Go to Insert -> Charts.

Click on Insert Pie or Doughnut Chart.

Select the 3D Pie from the options.

 

Keep going...

Pie Chart Bonus Points: This chart automatically calculates the percentages for you if you know where to look. <grin>

 

graphic1