How to Make Pie Charts and Graphs in Excel

5.7 min read|Last Updated: August 8th, 2023|Categories: excel|
table of content

Microsoft Excel contains a variety of charts and graphs for data visualization. One of these graphs is the pie chart, which can show a lot of information in a small amount of space. In this blog, we are going to discuss pie charts and their features.

What is a Pie Chart?

A pie chart is a useful tool for displaying different values as a proportion of a whole. It is a circle which is divided into slices that represent a percentage of the total. You can add numbers as percentages or their actual values. There are three types of pie charts: 2-D, 3-D, and doughnut charts.

When to Use a Pie Chart?

Using a pie chart has many advantages, such as:

It can show a lot of information in one look; it allows the viewer to analyze the data at a glance; it doesn’t need much additional explanation, etc.

Like any other kind of graph, the pie chart has its disadvantages as well:

For a large number of data points, the pie chart gets complicated and hard to read. In this case, a bar chart could be better; since pie charts cannot show trends within the data.

How to Make Pie Chart

To make a pie chart, follow these steps:

  1. Select the range of the data you want to visualize.
  2.  Click on the Insert tab from the ribbon.
  3. From the chart group, click on Insert Pie or Doughnut Chart.

Choose “Pie” from 2-D Pie icons.

How to make a Pie chart in Excel

Note: The pie chart does not display the data points with zero value. Also, when you enter the negative values, it shows their absolute value in the chart.

Formatting Pie Chart

Excel makes graphs with the default formatting. You can customize the pie chart you have created as you like. Let’s see some of your options.

Formatting data Labels

There are three easy ways to add data labels to the pie charts.

  • The first method is the easiest. To add data labels using this technique, you should just right click on the chart and select the “Add Data Labels” option.
  • The second method is shown below:
  1. Click on the chart.
  2. Click on the