How to Make Pie Chart in Microsoft Excel

Pie chart is used to show the proportion of the whole. Use it when numbers are equal to 100% and the chart contains only few pie slices (many slices make the angels hard to estimate).

Pie chart generator is containing the three type of charts: - 1st is 2D Pie Chart, 2nd is 3D Pie chart and 3rd is Doughnut Pie chart.

image 1


Let’s take an example & understand.

We have a table from Range “A6 to B11”, which is having Zone & Sold unit with total sold unit. Column A contains the Zone Name, Column B Sold, & in cell B11 is having total sold unit. We have another table of Targets & Require sold unit per zone.


image 2


To prepare the Pie chart follow below mentioned steps:-

  • Select the range “A7 to B11”.
  • Go to the Insert tab, Select 3D Pie Chart from the Chart Group.
  • Then click the first Pie option, at the top left.

image 3


  • The chart will show the heading from the number column as a chart title, and a legend with the text descriptions if your data includes those.

Move the Chart:-

  • To move the chart just click and hold the mouse pointer on the chart and drag it and release the pointer.

Pie Chart


Pie Chart 2


Re size the Chart:-

  • Point the one of the dotted handles on the border of the chart where the pointer will change to a two headed arrow.
  • Then drag the handle in or out to change its size.

Pie Chart 3


Pie chart 4


Add labels to the Chart:-

  • To add labels to the chart just right click on chart with the mouse, a pop will appear.

Pie Chart 5


  • Click on Add labels.

Pie Chart 6


Delete the legend

  • To delete the legend click on legend and then right click with the mouse.. popup will appear.

image 10


  • Click on delete.

image 11



Note:- If you having the option of choosing a different chart type consider making a Bar chart or Column chart instead of Pie chart, you can use these charts as alternative, it easier to compare the values.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.