How to Make a Pie Chart in Excel?

A Pie Chart in Excel or a Circle Chart helps to represent statistical data in the form of parts of a circle. Each part or section displays a piece of the pie. This type of Chart in Excel is used to display only a single sort of data set. As a result, users find it easy to learn How to Make a Pie Chart in Excel and work with them.  

Now, if you’re new to Excel and pie charts seem tricky, don’t worry! You’re about to become a Pie-chart pro. Just a few simple steps, and you’ll be slicing up data like a chef slices a pie. You can create Pie Charts by following a few simple steps. Read on to learn How to Make a Pie Chart in Excel.

Table of Contents

1) What is a Pie Chart in Excel?  

2) How to Make a Pie Chart in Excel?  

3) How to Read a Pie Chart    

4) How to edit a Pie Chart in Excel?  

5) How to customise a Pie Chart in Excel?  

6) How to explode an Excel Pie Chart?  

7) How to rotate an Excel Pie Chart?  

8) How to create a Pie Chart in Excel easily?  

9) Conclusion

What is a Pie Chart in Excel?

A Pie Chart, also known as a circle chart, serves as a visual tool to present statistical data in a circular format, where each segment represents a part of the whole, much like slices in a pie. This type of chart is limited to illustrating only one dataset and cannot accommodate zero or negative figures. Negative numbers are converted to their positive counterparts, while zero values are omitted from the display.

In constructing a Pie Chart, each slice is labelled with a category, and the corresponding numerical value is referred to as the value. The sum of all categories equates to 100%, reflecting the entirety of the data set. Each slice’s proportionate size visually conveys its share of the total. It’s important to ensure that categories do not overlap; for instance, categorising by “Women” and “People Over Fifty” could lead to double-counting since some individuals may belong to both groups.

How to make a Pie Chart in Excel?

Creating a Pie Chart is simple with the use of Excel. Here's a complete breakdown of the steps to follow if you are confused about How to Make a Pie Chart in Excel:

Organising the data for your Pie Chart in Excel

To get started, you’ll have to organise the data in one row or column so that you can plot only a single data series in the Pie Chart. Your spreadsheet can also include a separate row or column representing category names. The category names are included in the first row or column that needs to be selected. These category names are displayed as data labels in the Pie Chart. You should keep the following in mind when organising your data for an Excel Pie Chart:

1) Remember to plot only a single data series in your chart.  

2) The data values should be more than zero. 

3) Don't leave any column or row empty. 

4) The number of categories should be at most seven or nine. A Pie Chart with multiple pie slices is challenging to analyse and understand.   

In our Excel Pie Chart tutorial, we are using the following data to create a pie graph: 

Include a Pie Chart in the xcel worksheet 

Once your source data is organised properly, you’ll have to select it. Next, click on the Insert tab. Now, choose the type of chart you want. In our example, we will create a 2-D Pie Chart: 


 

Tip: You can select the headings of the row and column if you want these headings to appear in the Pie Chart’s title.    

Choose the style of the Pie Chart you want 

Once the Pie Chart is included in the worksheet, you can visit the Design tab > Change Chart Type. You can click on different Pie Chart styles and select the one that best suits your data.
  

Build your career as a Data Analyst - sign up for Data Analysis Training using MS Excel!

How to read a Pie Chart?

Pie Charts are very simple to understand and usually don't need much explanation. The total of all the slices in a Pie Chart adds up to 100%. If the chart doesn't have data labels, you can hover your cursor over any slice, which is also known as a category, to see the specific data for that section.

Besides being easy to read, Pie Charts are also valuable because they pack a lot of information into a small space. They allow you to quickly see how each category compares to others and how each contributes to the whole. This makes it easy to analyse the relationships within the data at a glance.

How to edit a Pie Chart in Excel?

Are you not satisfied with how your chart looks? Then you can modify it to fit your needs. Follow the below-mentioned steps to edit your Chart:

a) If you want to change the background colour of your Chart, then click on the paint bucket icon under the ‘Format Chart Area’ sidebar. Now, choose the fill type and the background colour.

b) If you want to rewrite anything, expand the text, or move the text to a new area of your pie chart, then click on the text within the pie chart itself.

c) You can change the border of your pie chart including border transparency, width, and colour in the Format Chart Area.

d) Click on the pentagon shape in the Format Chart Area sidebar to change the pie chart box itself. Get the shadow you want by toggling the bar across ‘Transparency’, ‘Size’, ‘Blur’, and ‘Angle’.

e) To change the colour of your Pie Chart, you can click the colour paint palette at the top left of Excel. You can also simply click on the Pie Chart  and toggle onto the paint section to choose a new colour.

f) You can change the Chart title by clicking on the three bars graph icon in the top left of the Excel.

g) You can change the place of your labels on the pie chart by clicking the ‘Data Labels’ on the same three bar graph icon.

h) If you wish to switch the data in the pie chart, then click ‘Switch Row/column ‘ to view alternate information aligned from your original data set.

How to prepare different types of Pie Charts in Excel?

Excel allows you to create different types of Pie Charts. Some of these are as follows: 

2-D Pie Chart 

A 2-D Pie Chart is a commonly used Pie Chart in Excel. You can create it by clicking on the Insert tab. Next, you’ll have to click on the Charts group. Now, you can choose the 2-D Pie Chart icon. 

This pie chart always shows the items’ size making up the data series which is proportional with the total of items in the series.

The following are the data requirements for 2D Pie Charts:

a) The data set has a numeric column with values that can be interpreted as numbers.

b) The data set contains one numeric row.

c) The column meant for wedges in the chart must be specified by setting the ColumnIndex property to 0. For automatic search of data, set this data to –1. In this case, the first numeric column encountered will be used for            the wedge's values.

d) If you want to bind the 2-D pie chart to a series object, then you have to gather information on the series binding requirements.

3-D Pie Chart 

The features of 3-D Pie Charts are similar to 2-D Pie Charts. However, the data entered is displayed on a third-depth axis. Below are the steps to create a 3-D Pie Chart:

a) You can write your data in a table with appropriate information in each column.

b) Select all the elements of the table. Now, go to the insert section and locate Pie Charts under the Charts sub-section. Then, choose a 3-D Chart that best suits the purpose of your work.

You can create a different pie if there are several small slices in your Pie Chart. Then, you can display the remaining pieces on it. A Bar of Pie Chart or a Piece Pie of Pie can be created by following these steps:

a) Select the data range.

b) Click on the Pie and Doughnut button in the Charts group on the Insert tab.

c) Choose a Bar of Pie or Pie of Pie.

d) Right-click in the chart area and select Format Data Series in the popup menu.

e) Select the data to be displayed in the second pie by clicking on the Format Data Series in the Series Options Tab.

There are several ways to choose which slice goes in the secondary Pie or bar chart: Split series by position, Split series by Value, Split series by Percentage Value, and Split series by Custom.

Doughnut Chart 

The Doughnut Charts show data in various rings. Each ring of a Doughnut Chart shows a different data series. Follow the below steps to create a Doughnut Chart using Excel:

a) First, select the data range that needs to be shown. Then, click Insert> Other Charts>Doughnut

b) A Doughnut Chart will gte inserted into your worksheet.

c) Now, you can right-click at all series and select Data Labels from the context menu to add the data labels.

d)  A Simple Doughnut Chart has now been created.

How to customise a Pie Chart in Excel?​

If the objective of the Pie Chart you are creating in Excel is to showcase trends in the data, you can create the default chart. However, if you want to create a professional graph for your next presentation, you should make a few enhancements. So, let’s learn about a few customisation tips:

How to add labels to your Pie Chart?

A good Pie Chart should be easy to understand. You can add data labels to your Pie Charts as it will simplify the message of your graph. However, a Pie Chart with a data label can make calculating the exact percentage of the slices easier. Thus, you can include a title for the whole data series or each data point.   

These labels can vary as per the data you’re willing to outline in the pie graph. You'll have to follow the below-mentioned steps to add data labels to an Excel Pie Chart: 

Add data labels to an Excel Pie Chart

You can add labels to different data points. You’ll have to tap the Chart Elements button on the pie graph’s upper-right corner to add a label. 




Now, you’ll have to choose the Data Labels option. 
 

If you’re willing to change the location of labels on the Excel Pie Chart, you can get started by selecting the arrow near the Data Labels.  


 

Show data categories on various data labels 

If the Excel pie graph you’ve created includes more than two-three slices, you should add levels to them directly. Then, your users will no longer have to browse between the pie and the legend to discover the description of each slice.   

An easy way to show data categories on different labels is to choose the best-predefined chart layouts. You’ll have to select the Design tab > Chart Styles group> Quick Layout to do this. Then, choose the layouts that consist of data category labels.

 

Now, you can go to the Chart Elements > Data Labels to open the Format Data Labels panel on the worksheet’s right side. First, click on the Label Options tab. Next, click on the Category Name tab.   



Besides, you’ll find the below-mentioned tips helpful: 

a) Below the Label Contains tab, you can click on the data that should be showcased as labels.  

b) You can click on the separator option. Now, from the drop-down list, you’ll have to choose ways to differentiate the data displayed on the labels.  

c) Below Label Position, you’ll have to select where to put data labels. 

Show percentage on Pie Charts in Excel

The source data you plot on your Pie Chart can include percentages. The % symbol will be shown automatically on the data labels. First, you’ll have to select Chart Elements and go to Data Labels. If the source data includes numbers, you’ll have to configure these data labels to represent either percentages or original values. Here's how you can do that:

a) Right-click on the slice of your Chart. Now, choose Format Data Labels.  

b) Under the Format Data Labels pane, you can choose either the Percentage or Value box. Also, you can select both boxes at the same time. Excel will calculate the percentages automatically, where the value of the entire pie is 100%.   
 

 

Organising the Pie Chart slices as per their size 

Pie charts become easy to understand when their slices are arranged in descending order (i.e., from large to small). You can do this quickly by placing the source data. You can set your source data in descending order to get started.   

Changing the colours of the Pie Chart in Excel 

If you don’t like the default colours shown in the Excel Pie Chart, you can choose from the two options listed below: 

a) Change the colour of each slice  

               Or,  

b) Modify the colour theme of your entire pie graph  

Change the colour of each slice  

The number of colour themes available for an Excel chart is limited. So, if you want to create an attractive and professional Pie Chart, you’ll have to select the colour of each slice separately. For example, if you wish to include data labels inside each slice and the theme colour is dark, the black text is not visible. To get rid of this issue, you can choose a suitable colour theme for your text.   

Additionally, if you want to modify the colour of a particular slice, select the slice and click on it. Now, click on the Format tab, choose Shape Fill, and select the colour you like. 
 

  

Modify the colour theme of your entire Pie Chart in Excel 

You'll have to choose the Design ribbon if you want to select a new colour theme for the Excel pie graph. So, click the Change Colours button and browse through the colour themes. Finally, you can choose the colour theme you like.  
 

Format a Pie Chart in Excel  

When you want to create an Excel Pie Chart for presentation purposes or export it to a new application, you should make it more appealing. To use Excel’s formatting features, you can right-click on any slice of the Excel Pie Chart.   

Next, you can open the Format Data Series panel by clicking on the Pie Chart. You'll have to choose the Effects tab from the Format Data Series pane. Now, you can apply and check effects such as Soft Edges, Glow, or Shadow. It will help you select the best one out of them. You can also browse through other options under the Format tab like: 

a) Increase or decrease the width and height of the Pie Chart  

b) Change the outline colours and shape fill 

c) Use various shape effects 

d) Use WordArt styles to modify the text elements  
 

To use the formatting mentioned above features, you’ll have to choose the element in the pie graph that needs formatting. For example, Excel allows you to format features such as chart titles, slices, data labels, or legends. Now, click on the Format tab on this ribbon. This will activate the essential formatting features. On the other hand, the non-relevant features will be represented in grey.   

Do you want to gain expertise in Data Visualisation? Register with our  Microsoft Excel Associate MO200! 

How to explode an Excel Pie Chart? 

You can use the explode option if you want to highlight a particular section in the Pie Chart. You can get started by exploding a slice of the Pie Chart. To do this, you’ll have to double-click on the slice you want to extract. Next, you can pull away the slice by dragging it with the cursor. After you have completed these steps, your Pie Chart will look like the following image:

 

How to rotate an Excel Pie Chart? 

If you want to rotate a Pie Chart in Excel, you’ll have to click on the Pie Chart twice. Next, you’ll have to select the “Format Data Point” option. Next, you have to toggle the first slice’s Angle and rotate it to a certain degree. 
 

Sign up and learn the top ten Excel shortcuts with our Microsoft Excel Masterclass!  

Conclusion

Through this blog., now you know How to Make a Pie Chart in Excel; Well, creating and editing a Pie Chart is simple and highly effective for presenting data. A Pie Chart is ideal for providing readers with an easy-to-understand visual representation, particularly for illustrating the breakdown of financial figures or showing the value and proportion of different items in a dataset. It offers a clear pictorial representation of categories with minimal explanation needed. 

Learn how to create advanced formulas in MS Excel by joining our Microsoft Excel Expert course!