Here are some guidelines for deciding when to use a pie chart in Excel: You can create a pie chart using a single data series or sophisticated tables.įor example, if you wanted to compare the number of students in each grade at a school, a pie chart would be an ideal way to do so. A pie chart is useful for visualizing small sets of data, especially when comparing similar data points. You can use these charts as alternative as they are easier to compare the values.Short on time? Grab our free Excel pie chart template to get up and running in less than a few clicks.Įxcel Pie Chart Template – Free Download FAQs What is an Excel Pie Chart?Īn Excel pie chart is a graphical representation of data that uses pies to show relative sizes. Note:- If you having the option of choosing a different chart type then, consider making a Bar chart or Column chart instead of Pie chart. To delete the legend, click on legend and then right click with the mouse.To Delete the legend, follow the below mentioned steps:

To add labels to the chart, just right click on chart with the mouse, and a pop up will appear.Then drag the handle in or out to change its size.Point the one of the dotted handles on the border of the chart where the pointer will change to a two headed arrow.To move the chart, just click and hold the mouse pointer on the chart, then drag it and release the pointer.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).Then click the first Pie option at the top left.Go to the Insert tab, and Select 3D Pie Chart from the Chart Group.To prepare the Pie chart, follow below mentioned steps:. We have another table of Targets & Require sold unit per zone. Column A contains the Zone Name, Column B Sold, & cell B11 is having total sold unit. We have a table from Range “A6 to B11”, which is having Zone & Sold unit with total sold unit. This pie chart contains the three type of charts in which 1st is 2D Pie Chart, 2 nd is 3D Pie chart and 3 rd is Doughnut Pie chart. 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: - This chart is used to show the proportion of the whole. In this article, we will learn how we can prepare a Pie chart in Microsoft Excel 2010.

How do i make a pie chart in excel 2010