Insert ->Charts-> Pie

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.

 

Try it: Insert a Pie Chart

Select Cells A1 through B6.

Go to Insert -> Charts.

Click on Pie.

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>

Exam 77-882: Microsoft Excel 2010 Core

6. Presenting Data Visually

6.1. Create charts based on worksheet data: Select appropriate chart type