In this section, we're going to create a pie chart to show the relationship of parts to the whole. Learn how to create all types of charts and more with our hands-on Excel classes in NYC or online, with top instructors, step-by-step exercises, and more, at a state-of-the-art training facility.
You can think of a pie that is broken up into several slices. We'll be able to see the entire pie as well as each individual piece that makes up the pie to create a 2D pie chart. All you need to do is click one cell within the data.
You don't have to select all the data unless you want to make a pie chart just using a subsection. Then you'll actually select multiple parts of the table. But if I want to include the whole table, all I need to do is select one cell. I'll go over to the insert tab because I am inserting a chart and the type of chart that I want to insert is a pie chart. This icon is gonna be the most recognizable because it looks like a circle.
I'll click here and then I'll create a 2D pie chart. And now I have a 2D pie chart. Now I want to change this chart and I want to turn it into a 3D pie chart. I'm following along with the exercise that's in the sheet. So after created 2D creating a 2D pie chart, I want to change it to a 3D pie chart.
I'll head over to the chart design tab that is only going to be visibly defined in the chart. Then I'll click change chart type here. I'll look at the several options I have for the pie chart. And here's 3D. I could also create a donut pie chart as well, but I'll choose 3D pie. When I click ok. Now I have a 3D pie chart and you might say, hey, wait a minute. That doesn't look like 3D pie charts. Not that much different than what we just saw.
Well, if you take a look closely, you see towards the bottom is a little bit of shadow here. But let's say I wanted to accentuate the 3D nature of the pie. This is not in your instructions, but here's a cool way that you can do that without going to charge styles. Because I can simply go to chart styles. I'm going to right-click.
And if you're working with a 3D pie chart, you will see an option called 3D rotation one click on 3D. The rotation opens up a side pane that will give you options for customizing your chart. Now I'm going to focus on the Y rotation and if I decrease the Y rotation, I will accentuate the 3D nature of the pie chart.
Now you might be wondering what is X rotation? If I increase X rotation, this will begin to rotate the PI in three-dimensional space. So this might be useful if I want a certain part of the pie facing in a certain direction like maybe that blue slice right here in the instructions, they're asking you to pull away a piece of the pie pertaining to Sykes. And what I would like to do, though, is pull away the piece pertaining to Green.
I can tell it's green because when I hover my mouse over the blue slice, a little tooltip comes up and says that it displays the total sales as well as green. Now, in auto, in order to pull away from this particular slice, I'm going to click three times in a very specific way. When I click the first time, I see dots all around the pie. That means the entire pie is being selected.
So I need to click again just to select the blue slice. Second click. Now there are only three dots just around the slice. But I need one more click and this is a special click. It's gonna be a click and drag. So I'm going to click and drag this particular slice away from the rest of the pie. Now I'm able to separate that particular slice and during my presentation, I can highlight that particular part of the pie if I'm referring to a certain piece of the pie.
So that is one type of pie chart that you can create in the class. You'll have an exercise that you can work on where you can try this yourself. So let's head over to that exercise. I'm going to close this format chart area pain. I'll scroll down towards the bottom and here's the exercise that we're gonna work with.
Exercise: 2D Chart & Design
I'm going to click anywhere in the data. And the first task is to use the above data to create a 2D pie chart. So I'll go to insert go to the 3D pie icon and choose 2D pie chart. Next, I want to make some changes to the layout, colors, and styles so I'll head over to layout quick layout and choose layout 6. Layout 6 is actually named layout 6.
If you just hover your mouse. Were the different layouts you'll be able to make sure you're selecting the right one. Then monochromatic palette 9. If I don't know what that is, I'll head over to the monochromatic section and it's basically the ninth palette going down. So this is one, two, three, four, five, six, seven, eight, nine. And if I hover my mouse for just a bit, I'll see that that's the palette I'm supposed to select. Then I'll go to style eight. One, two, three, four, five, six, seven, eight, five. Hover. I can just confirm it actually says dilate. And there we go.
Donut Pie Chart
I've now completed Task 2 and now I need to go and change this 2D pie chart into a donut pie chart. So I'll click on change chart type because I want to change the type and of all the icons that over here that looks like a donut. This is the one that I'm going to guess is the type I'm looking for. And if I hover my mouse over that particular icon, I see a pop-up, a little tooltip that says Donut. I'll select that and click, OK.
The final part of the exercise. I want to pull away the piece pertaining to green. If I'm not too good with colors, I don't have to be, because if I hover my mouse over the slices, I'll see the name of the person that slice belongs to and the 7 percent is green. I'll click once, I'll click twice third time, click and drag.
Now I'm selecting the labels. You want to be careful. Don't select the label. You want to select the slice. So I'm going to go back here and make sure I don't do that. I'll go to the outer edge. One-click, two clicks. Now I'm going to click and drag and pull that piece away. So I was actually fortunate that I did select the label. If that happens to you, you'll know what to do. Just make sure you're selecting the pie slice and not the label.
So in this section, we covered how to create a pie chart. Turn it into a 3D or donut pie chart and pull away a piece. If you're looking to focus on a certain slice of the pie when you're creating your reports.
Learn Excel Live Online or Corporate Training
Learn Excel from the comfort of your home with live online training from anywhere or have us come to your offices anywhere in the US for corporate training in Excel. Learn more about Excel training in your location: