How to Create a Pie Chart in Excel 2010

A pie chart is a useful way to track and summarize your information in a graphical form. If you’d like to know how to create a Pie chart in Excel 2010, follow the steps below.

The Data-set used to Create a Pie Chart in Excel 2010

In order to create a Pie chart in Excel 2010, you’ll need a data-set that will be displayed in your pie chart.

For example, suppose you are running a project and you would like to track the status of your tasks.

In that case, you may wish to track your tasks across the following 3 categories:

(1) Tasks Pending

(2) Tasks Ongoing

(3) Tasks Completed

Now, you’ll need the number of tasks associated with each of the 3 categories. Here, I chose the following numbers for each of the 3 categories:

Tasks Pending300
Tasks Ongoing500
Tasks Completed700

Steps to Create a Pie Chart in Excel 2010

Here are the steps you can follow in order to create your Pie chart:

(1) First, you’ll need to copy (or type) the above table into Excel. Your table should look like this in Excel:

 

Copy table into Excel 2010

 

(2) Go to the ‘Insert’ tab:

 

Insert Tab in Excel 2010

 

(3) Now you’ll need to select the range of cells that will be used in the Pie chart. In our example, I selected the range of cells C4:D6

 

Select range of cells to be used in the pie chart in Excel 2010

 

(4) Press the ‘Pie’ Icon and then select the ‘3-D Pie’ chart type.

I personally like to use the 3-D Pie charts, but feel free to choose another Pie chart type, such as 2-D Pie chart…

 

3-D Pie Chart in Excel 2010

 

(5) Congratulation, you just created a Pie chart. Your Pie chart should look like this:

 

Create a Pie chart in Excel 2010

 

(6) If you’d like to change the chart layout, choose your desired layout from the Chart Layouts section.

Here, I chose the second chart layout. This layout will display the percentages associated with each of our 3 categories:

 

Pie chart layouts in Excel 2010

 

(7) Additionally, the second chart layout allows you to type a chart tittle. Here, I typed the title ‘Tasks Status’

 

Type a chart title for a pie chart in Excel 2010

 

(8) To change the colors of your Pie chart, you can simply select among the options under the Chart Styles section.

For illustration, I chose a green color scheme:

 

Chart styles in Excel 2010

 

If you’d like to create other types of charts, such as a column chart, please visit our post that shows a step-by-step guide on How to Create a Column Chart in MS Excel 2010