I'll right click on one of these labels and Format Data Labels. Format LabelsĪnd now we have a little more room to put things onto the slices. I'll right-click on the legend, and click Delete, and that shifts the pie over into the center. Next I'll delete this legend, because we're not going to need it. It's not telling us what region it is yet, but we're going to fix that up in a minute. We can see the values here, and it's just put that on each slice. So with this pie chart, I'm going to right click, and click Add Data Labels, and that puts the value. You shouldn't try to show too much in a pie chart, or it'll just get so crowded you won't even be able to read it. We're going to get rid of this legend, and put data labels onto the pie. So it's better if you have these labels right on the slices, or just beside them. To read that, people have to look at the color here, and then try and find it in the legend. We have colored slices on this pie and a legend tells us what each color represents. Pull the handle in or pull it out to make it bigger. So if I point there, I can drag it to the right or left.Īnd I can also make it smaller, by pointing to one of the handles on the sides or in the corner. You'll notice where I'm pointing, a pop up says Chart Area. You can move it, and you can resize it, and to move it just point to one of the borders or point somewhere. I'm going to click this one and it puts a chart right in the middle of the worksheet. I don't want an exploded pie or a pie of pie and certainly not a 3D pie, because those can distort the data, with the way that they create angles. To create the chart, I'm going to select any cell in this table, and on the Ribbon, I'll go to the Insert tab, and click PieĪnd I'm going to select this first pie chart, which is just a simple pie chart. On this sheet, I have the names of four regions, and in the column to the right,the numbers which represent the sales in each of those regions.Ī pie chart can only show one set of numbers, so we couldn't compare year to year for each region, but we can see the total sales for the current year. It might be easier to compare the values, if you create a bar chart such as this one, which easily shows the difference between each region, or in a column chart like this one.īut if you need to create a pie chart, we'll see the steps for creating one that's easy to read, and presents the data as clearly as possible. With a pie chart in Excel, you can see a representation of the total amount, and then the percentage that each value has of that total.

How do you make a pie chart in excel