How to Create a Pie Chart in Excel (with example)

Need to create a pie chart in Excel?

If so, I’ll show you the steps to create a pie chart using a simple example.

By the end of this short guide, you’ll be able to create the following chart:

Pie chart

Steps to Create a Pie Chart in Excel

Step 1: Gather the data for the pie chart

To start, gather the data for the pie chart. For example, I gathered the following data about the status of tasks:

Tasks Pending300
Tasks Ongoing500
Tasks Completed700

The ultimate goal is to create a pie chart in Excel based on the above data.

Step 2: Copy the data into Excel

Next, copy the data from step-1 into Excel.

For example, I copied the data into the range of cells A1:B3

Dataset in Excel

Step 3: Create the pie chart in Excel

To create the pie chart, go to the ‘Insert‘ tab:

Insert tab in Excel

Then, select the range of cells that contains the data for the pie chart. In our example, I selected the range of cells A1:B3

Range of cells in Excel

Under the Insert tab, press on the ‘pie’ icon, and then select the ‘3-D Pie‘ chart type (alternatively, you can select the ‘2-D Pie’ chart type):

How to Create a Pie Chart in Excel

Your 3-D pie chart would look like this:

Create a Pie Chart in Excel

Step 4: Choose a chart style

You may chose a different style for your chart under the Chart Styles section.

Here, I chose the third chart style:

Pie Chart in Excel

Additionally, you can add a title for your chart.

For instance, I typed the title of: Status of Tasks

How to Create a Pie Chart in Excel

You may also modify the color scheme for your chart.

For illustration purposes, I selected the green color scheme (i.e., ‘Monochromatic Palette 13’):

Style a chart in Excel

You may also want to check the following source that explains the steps to create a column chart in Excel.