Introduction to Pie Chart

Pie charts are a successful solution to visually represent data sets 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 simple clicks.

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

You need to use a pie chart when:

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

How To Make a pie chart in MS Excel 2010, execute the following 3 steps.

1. Initially, you'll need to enter your listing of data in new excel file (spreadsheet) as revealed in the       figure. This is pretty easy, one order can be your forms of the ethnic groups, and one other 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: 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

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

Generally, with simple pie chart like usually the shown is that best one; the very first choice (2D) will continue to work fine. When you have clicked the 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 chart 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.

Customize the Pie chart from the Design tab

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

1. Whenever you click the pie chart it'll make Chart Tools seem on the ribbon. This 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 the case, I've picked the Layout 6. You can even utilize the Chart Designs and Chart Styles galleries to further refine the prevailing 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 styles.

How To Make A Pie Chart Ms In Excel 2010 Adding Labels to your Pie Chart

whether you need more customization for the active pie chart, simply 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 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 to 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.


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 a Twitter or Facebook. Thank you!