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 *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube