How To Make A Pie Chart In Ms Excel 2010

  • Home
  • / How To Make A Pie Chart In Ms Excel 2010

Introduction to Pie Chart

Excel Pie charts are a successful solution to represent data sets visually, which are generally acknowledged format-presenting data to clients or management. It may seem difficult to begin with a pie chart, but Microsoft Excel is a superb application for producing them with just a couple of simple clicks.

 This article identifies how to make a pie chart in Excel 2010. It contains a selection of options for making and customizing given pie representations, including 2D and 3D designs, with a number of styles and brands to suit your needs. 

You Need To Use an Excel Pie Chart When:

You intend to show figures as a percentage of the entire (i.e. the figures identical 100%). There are certainly a limited number of pie slices. If you will find many pie slices, then a pie chart isn’t a recommended graph to use.

Execute The Following 3 Steps of Making Pie Chart in Excel

1. Initially, you’ll need to enter your listing of data in a new excel file (spreadsheet) as revealed in the figure. This is pretty easy, one order can be your form of the ethnic groups, and another order is their corresponding percentage.

For example, to create a spreadsheet featuring the percentage of ethnic groups and the percentage you are able to write “Newar” in cell C7 and “30” in cell D7, and so on. Please note: All data values are more than zero and you will find no clear lines or columns.

How To Make A Pie Chart Ms In Excel 2010 1

2. Secondly, pick the data you want to contain in the pie chart excel. To select the data, click the top left of the effective data and then pull the cursor to the bottom right. In this case, I have selected the data range C7: D12

How To Make A Pie Chart Ms In Excel 2010 2

3And once everything is selected, click the Insert ribbon, Click Pie, and Select whether you want a 2-D or even a 3-D pie; and which template you need the most. You can see the result. In that case, I am creating the most frequent 2-D excel pie chart.

 Generally, with a simple pie chart excel-like usually shown is the best one; the very first choice (2D) will continue to work finely. When you have clicked any of the pie chart icons, a pie chart will be automatically placed into your spreadsheet.

In the event that you created an error in your data, you don’t have to upgrade the entire graph; form your modification in the initial data that you entered and MS Excel can instantly make the modification to the graph (just try and get the difference).

How To Make A Pie Chart Ms In Excel 2010 3

The pie graph in excel may immediately determine the percentage for you personally.

Please note: As you hover around each choice in the drop-down menu, it will show you a preview of data in the highlighted graph format.

Customizing the Pie Chart From The Design Tab

Now your pie chart should display through your spreadsheet. The following point is to customize the excel pie chart a bit to make it more appealing. Please again check out these simple measures given below for the method:

1. Whenever you click the excel pie chart it’ll make Chart Tools seem on the ribbon. It includes a total of three various tabs: Design, Layout, and Format. Please check out the figure below.

2. Next, Click on the “Design” tab under Chart Tools to see the Chart Styles cell and Chart Layout panel. Several style types can be seen in a drop-down box when clicked. You are able to search up and down through the alternatives by clicking on the arrows to the right of the box.

 Press any pie symbol to select that model for your chart. Here, in this case, I’ve picked Layout 6. You can even utilize the Chart Designs and Chart Styles galleries to further refine the prevailing excel pie chart.

3Similarly, you are able to press the “Format” tab in the Chart Tools element of the ribbon. Select “Shape Fill,” “Shape Outline” or “Shape Effects” to improve the looks of the pie chart. In the figure, I’ve selected the second shape style.

Adding Labels To Your Pie Chart

When you need more customization for the active pie chart, you simply need to right-click the chart and select “Format Data Labels.” A pop-up dialogue box starts featuring the label options. Select “percentage” to see the values indicated as a percentage of the entire Excel pie chart, or select “value” to alter the phase labels to their numeric values as shown in the spreadsheet.

You may select or deselect some other labeling possibilities as desired. As an example, checking “Series Name” or “Category Name” includes these names in the phase labels. Choosing one of the Label Position possibilities changes where the phase labels appear. In the example, I’ve selected the Category name in the label options.


I hope that you got an idea of how to make a pie chart in excel successfully. If you enjoyed this article, I’d be very grateful if you’d help it by emailing it to a friend or sharing it on Twitter or Facebook. Thank you!

Write your comment Here