how to make a pie chart in excel using select data

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. Once you’ve selected the most applicable chart for you, click it so that it can be added to your page in Excel.In this article, we will learn how we can prepare a Pie chart in Microsoft Excel 2010.However, you can hover the cursor over your preferred pie chart option to see a sneak preview of what it will look like for your data. This includes 2-dimensional and 3-dimensional pie charts. You should now be able to see various options for creating your pie chart.Then click the Insert Pie or Doughnut Chart option (you can’t miss it, it’s in the shape of a small pie chart). Do not select the sum of any numbers as you probably don’t want to display it on your chart. In your spreadsheet, highlight the data that you want to plot on your pie chart.If you opt to label your data then these will be transferred to your pie chart later on. Create your columns or rows of data (or both if need be).Though there are different types of pie charts available to choose from on Excel, it won’t be difficult finding the perfect way to showcase your data.Īll you need to do is follow these steps and you’ll be on your way to visualizing your data in no time at all! This is the most straightforward way to create a pie chart in Excel.

How to make a pie chart in excel using select data