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:
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 Pending | 300 |
Tasks Ongoing | 500 |
Tasks Completed | 700 |
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
Step 3: Create the pie chart in Excel
To create the pie chart, go to the ‘Insert‘ tab:
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
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):
Your 3-D pie chart would look like this:
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:
Additionally, you can add a title for your chart.
For instance, I typed the title of: Status of Tasks
You may also modify the color scheme for your chart.
For illustration purposes, I selected the green color scheme (i.e., ‘Monochromatic Palette 13’):
You may also want to check the following source that explains the steps to create a column chart in Excel.