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, 2^ndis 3D Pie chart and 3^rd is Doughnut Pie chart.

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.

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.

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.

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.

Add labels to the Chart:-

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

Click on Add labels.

Delete the legend

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

Click on delete.

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.