Pie Chart in Excel

Previously we have learned about creating “Column Charts in Excel” and “Bar Charts in Excel”. Now, in this blog post we will learn how to create “Pie Chart in Excel”.

We will take very simple example to create “Pie Chart in Excel”. We have listed 05 products: Product A, Product B, Product C, Product D and Product E along with their costs.

Now we have to convert this data into Pie Chart for better data visualization. Just follow below steps:

1. Select the above data which we want to convert into Pie Chart.

2. Go to “Insert” Tab, Select Insert Pie or Doughnut Chart command under “Charts” group.

3. We will get further options for selecting Insert Pie or Doughnut Chart. Out of these appeared option we have to select “Pie” under “2-D Pie” option as shown in below image.

4. We can see that “Pie Chart” is now created for our selected data.

Changing Chart Style:

To change the formatting of our Pie Chart, click on the existing “Pie Chart” and this will appear two additional tabs on our Ribbon. These tabs are:

1. Design Tab

2. Format Tab

Once we click on the “Design” tab, we can see various Chart Styles for “Pie Chart”.

As an example we can click on “Style 3” which will change the Style of our appeared “Pie Chart” as shown in following image.

Similarly we can select any of the Chart Style from available options as per our own choice to give special effect to our Pie chart.

Changing Color of Slices:

We can also change the colors of slices of our “Pie Chart”. For this we have to select the existing “Pie Chart” and then click on “Design” tab and then click on “Change Colors” option.

Once we click on “Change Colors” option, various color options will pop up on screen. As an example we will click on the option “Color 3”.

Now, our “Pie Chart” with “Color 3” and “Style 3” will look like as shown in below image:

Similarly we can try various Chart Styles and Color options to make our Pie chart beautiful.