Creatign pie charts from a set of numbers is easy. But if you have to count occurances in a long list of data and create a pie chart from the results, it can take a second table. However, if you use Categories, you can create it in fewer steps without the need of a second table or any forumlas.
You can also watch this video at YouTube.
Watch more videos about related subjects: Numbers (200 videos).
You can also watch this video at YouTube.
Watch more videos about related subjects: Numbers (200 videos).
Video Transcript
Hi this is Gary from MacMost.com. Today let me show you how to create pie charts in Numbers using a list of data.
MacMost is brought to you thanks to a great group of supporters. Go to MacMost.com/patreon. There you can read more about it. Join us and get exclusive content.
So usually creating pie charts in Numbers is pretty straight forward. But if you have a list of data it's a little more difficult. Creating pie charts in Numbers is really easy if you have a nice table that looks like this. It just has values here on the left and then a total on the right for each value. You can then select the entire thing. Click on Chart and then select Pie Chart and then you have this nice pie chart that shows a wedge for each of the values here. But we're not always that lucky to have a nice tables like that. Sometimes we have data that looks like this.
This is a table with records, in this case orders, and you have a name, which we don't really care about. Then which pie was ordered. So we want to now count these and create a pie chart that has a wedge for blueberry, and another one for pumpkin, apple, coconut cream, etc. The problem is you just can't do that. You select this table here and Chart and then Pie. You're not going to get anything that gives you a pie chart because you don't have values here. It needs numbers to work with that. So how can you get numbers from this. Well, there's a hard way and an easy way. The hard way has been around forever. But the easy was is fairly new. Let's look at the hard way first because it's still a little more versatile.
So what we need to do is create another table. I'm going to create a table here and this is going to be called Pie Orders and we'll put the Pie here and we'll put the number here. Then we can shrink this all down. Now we actually have to put a value here for every kind of pie represented. So we'll do blueberry, pumpkin. I'm just going to copy and paste. Make sure I get each one represented once. After I've got all of that done now I can put a formula here to count the number of occurrences. So I can do equals to enter the formula mode and then COUNTIF and then I can select Column B from this table and try to match that to the cell to the left here. So in this case it would be blueberry. Hit Return and I can see there are ten blueberry pies there. I can Copy and Paste this and it will still be using Column B here but it's going to be using whatever is represented on the left there. In this case a 3. In this case it would be a 4. So it's always going to match. This is how many apples. This is how many coconut cream, etc.
Now I have table that looks a lot like we had before. I can select this entire table. Do Chart. Do Pie and I get my pie chart counting everything that's here. It will even update. So if I change one of these, for instance, I can then see those numbers change and this will change as well. But there's a way to do this without having this secondary table here. You can just do it directly from this table. That's by using Categories. So let's get rid of that.
I'm going to go to this table here and I want to organize this table by category. Category from Column B. I can do that several ways. One is I can click here and then choose Add Category for Pie. I could also go to Organize and then Add Category for Pie. I could go over to the Organize sidebar over here and Add Category for Pie. There's a lot of different ways I can do it. Whichever way you're going to do it you're going to end up with the same thing. Add Category for Pie.
Now it's going to group these all together by the type of pie. So you can see they're all grouped. Now I still don't have the count of how many are in each one. I can see here how many there are but I don't have that number. But these special Category rows here. You can see there's Row 1 and Row 2. What's this one? This is a special category row here. When I go to one of the cells here I get this little Settings button. I can click that and I could say what goes in that cell. In this case I have nothing. No summary there. But I can do things like an average or a minimum value. Things like that. Or I can choose Count. If I select that now you can see it says Pie and Count and I get the number there. 10, 10, 7, etc.
So now that I've got that setup you can select the entire table again and go to Chart and go to Pie and sure enough it picks up these counts here and the category name for each one and creates exactly the pie chart that we wanted. We didn't have to create another table to do it.
Now if you want these sorted then what you would do is before you create that pie chart here go to Organize and you can see it says Sort Groups. I can say I want to Sort By pie value ascending. Now you see all the apple pies are together. All the blueberry pies. Everything is in alphabetical order so when I go to create the chart it will create it and you can see they're in alphabetical order here and as they go around the pie as well.
Don’t you ever rest and take a day off!!! 😃 Seriously, wishing you a joyous, healthy, and prosperous new year Thank you for sharing of your time and talents with all of us. Kudos and god bless...