 Now, I'm going to pull this over to our other Excel report that we've been putting all of our data into so that we can practice putting our pie chart along with all of our other reports possibly being able to print them out all on one PDF form. If you don't have that other form, that's okay. You could just use this one to practice with. But I'm going to take the whole thing, put it in my cursor on the triangle, right-click and copy the whole thing and then I'm going to go to this report that has all of my reports on it, go to the last tab and then hit the plus button. I'll put it in A1 or I can select the entire sheet, right-click and paste it and then I'm going to rename it double-clicking down here. This is going to be the sales by customer data. This is going to be the data tab because I'm going to create another tab where the actual graphs are going to go and then I'm going to hide the data tab so that I can print all of this stuff on one PDF file without the data tab but just the nice charts that we want to be adding. So I'm going to hold control, scroll up on this a bit and we've got all we need here but I'm just going to clean it up like I typically like to do. I'm going to change the font so I don't have this funny font situation. In other words, over here I'm in Calibri 11. Over here I'm in Ario 8. I want to pick one. Everything should be the same. I don't like this funny business with all this different fonts. I'm going to make it the standard Excel Calibri 11 by going to the home tab, paint brushy that cell and then I'm going to paint brushy the whole thing with the triangle so everything's the same. And then I'm going to right-click and then format it the way I want to format it because this is my Excel worksheet. I'm going to go to the currency down below. Let's put some brackets around the negative numbers. Get rid of the dollar sign, decimals. Those need to go to and OK. All right, and then I'm just going to delete all the stuff I don't need. All I want is the raw data. I don't want the title. So I'm going to put my cursor on row one and drag on down to row five. Let go right-click on that stuff and delete it. Get out of here. And then I'm going to go down. I don't need the total. I'm going to put my cursor on row 23. Drag down to row 30 or whatever. Right-click and delete all that stuff. So that looks good. And then sometimes these cells still have a formula in it. It still says equal. So I just want to make sure there's no formulae, just raw data. So I'm going to put my cursor on column B and then right-click the selected area and copy it. And I'm just going to paste it right down on top, but this time just with the one, two, three. So it'll paste just the values only, just the raw data. Don't give me any formulas. Just give me the data. There we have it. And then I'm going to make it a skinnerize this. I'm going to put my cursor between the B, the C, and skinnerize it, dragging to the left. That's how you put a cell on a diet in Excel. You just drag it to the left like that. It's really easy. So then we need to sort this from highest to lowest, Z to A, as they say, in Excel sorting terms. Now you could do this by selecting this whole thing and then go to the data and then go to the filters and then you've got your filters. But I don't like to do that because sometimes I think stuff gets jumbled up. I want a table. I'm going to add a table. So you know by now that I like the table thing. So I'm going to put my cursor. I don't need to highlight the whole thing. I could just put it anywhere in the data as long as the data is all stuck together and then go to the Insert tab and then Table. And it'll pick the data that we want typically. It should. And then we're going to say, OK, you want to double check these things. And then I'm in the table design. I'm going to add a total to it. The total there it is, 10, 280. Does that still tie out to what's in QuickBooks? Did I mess anything up yet? I'm going to close this out. Let's check it out. 10, 280. So I'm still good. It's still good. It's still good. So then I'm going to hit the dropdown and sort it from Z to A, top to bottom. Boom. So now there's too many things to make up a pie chart. But I'll just show you just to show you what the issue is. If I select just the meat, not the total, not the header columns, just the data. And then I go to Insert. I can make a pie chart out of it by just selecting the pie chart and boom. But the slices, you see? You see the problem? The slices are too small. No individual can get any sustenance that's at all satisfactory from a pie slice that's small. So we have to fix it. So I'm going to close it here. Now note before I do that, just what it is doing with the pie charts is just making a percent. So I'm going to skinnerize the C column, putting my cursor between the C and the D. And then in D2, I'm going to say this equals this number divided by the total. That's all we're doing to make the percent. I'm going to put my cursor on column D and home tab number group, percent ties the whole column, put my cursor and drag down with the fill handle, and then sum it up at the bottom. Equals the sum. And that should be 100%. So you would think you might need to use this column to make your pie chart. But no, you just choose the data. And of course, Excel does that calculation for us. But there's too many. So we have to say some of this stuff isn't going to make the cut. So we're going to say 1, 2, 3, 4, 5, 6, 7, 8. Let's stop it like there. And let's say that all this other stuff underneath is just going to be an other. They didn't make the cut. You're not going to be in my pie chart because you're not a good enough customer. Buy more stuff and you can make it in my pie chart. Anyways, so we're at the 2, 9, 2, 1. So I'm going to put that in here, 2, 9, 2, 1. Call this other. And then all these people down below, they're off the team. You're off the team. You guys are out of here until you start picking up your sales, buying more stuff. So I'm going to delete that, get out of here. And then I can still see the total is at the 10, 2, 8, 1. That's pretty close here. I rounded it. I did a rounding thing because I'm not showing the pennies here. So that's good. I'm OK with that. And then I can create a pie chart. So now let's select the data and see if the slices are good enough to serve to people. They have to be big enough to serve to someone. It's not worth putting it on a plate if you've got a skinny slice. OK, good enough. Good enough that some people don't like super big slices. So we're going to say, there we go. And we could pull some of it. And then of course, you can adjust this. You can get rid of the title. You can do what you want. You can change the color, and so on. You've got a bunch more flexibility in here.