How do I create pie chart from one column in Numbers?

[Fuzzyreets]

HI. I'm relatively new to Numbers so maybe this is something really easy. Basically I have a table in a document that has a column for pool game matches which involve 3 different players. Each cell shows the 2 players that are playing in the match and the second column, each cell shows one name which is the winner. All I want to do is take the winners column and make a pie chart out of it so we can see who is winning the most. I've spent at least 2 hours on this and all I get is a pie chart that is one solid color. I can't figure out how this works. Help would be GREATLY appreciated as I'm very frustrated at this point. Thanks.

 

[Raz0rEdge]

Please put some sample data here (or take a screenshot of your existing tables) to make it clear how you have to data setup which will make it easy to respond..

 

[Fuzzyreets]

Please put some sample data here (or take a screenshot of your existing tables) to make it clear how you have to data setup which will make it easy to respond..

Thanks for the reply. Here you go.

 

[Raz0rEdge]

OK, thank you for the data sample. You can't get a chart of out of data like that. You'll need to do a little bit of work. I took your data and created the following..

So what you'll want to do is to create two more columns after the Winner column. One of them will be the names of the winner and the other will be the number of times they've won. So using the names Jiles, Biles, and Stiles here, you would enter those three names in the first new column. In the second column, enter the formula=COUNTIF(C2:C13, "=Jiles") for the first row, use =COUNTIF(C2:C13, "=Biles" for the second row and "=Stiles" for the third row.

You will now have names and numbers similar to what I have.

Now create your Pie chart and use the column with the name for the Name part of the Data and the count column for the Value part.

Lemme know if any of that was confusing..

 

[Fuzzyreets]

OK, thank you for the data sample. You can't get a chart of out of data like that. You'll need to do a little bit of work. I took your data and created the following..

So what you'll want to do is to create two more columns after the Winner column. One of them will be the names of the winner and the other will be the number of times they've won. So using the names Jiles, Biles, and Stiles here, you would enter those three names in the first new column. In the second column, enter the formula=COUNTIF(C2:C13, "=Jiles") for the first row, use =COUNTIF(C2:C13, "=Biles" for the second row and "=Stiles" for the third row.

You will now have names and numbers similar to what I have.

Now create your Pie chart and use the column with the name for the Name part of the Data and the count column for the Value part.

Lemme know if any of that was confusing..

This is EXACTLY what I was looking for. Can't thank you enough. I got it working. One follow up question. For that formula, how do I tell the result cell to just keep adding the cells for the formula in column C for the entire column ongoing no matter how many more cells I make in that row? Right now it goes from like cell 2 to 13 (based on your example). I just want it to keep going forever regardless of how many cells I put in column C.

Again, many many thanks for explaining this to me. You made it so understandable. Thank you!

 

[Raz0rEdge]

Instead of doing C2:C13 in the formula, you can change that to C2:C1000 and if there are no values after say row 13 or whatever then that's fine and as you continue to add rows, they will show up in the count.

 

[Fuzzyreets]

Instead of doing C2:C13 in the formula, you can change that to C2:C1000 and if there are no values after say row 13 or whatever then that's fine and as you continue to add rows, they will show up in the count.

Okay so no way to just tell it to keep going regardless of how many cells i end up with over time? That's a bummer but changing the formula is pretty easy. Thank you!

 

[Raz0rEdge]

These formulas are designed on a set of data. So if you were you add new rows or columns, the expectation is that you'd update the formula appropriately. Using an arbitrary value like the 1000 I suggested, while will get you want you want, is wasting resources checking fields where there is no useful data. You are MUCH better off limiting the formula to rows that have valid data..

 

[Fuzzyreets]

These formulas are designed on a set of data. So if you were you add new rows or columns, the expectation is that you'd update the formula appropriately. Using an arbitrary value like the 1000 I suggested, while will get you want you want, is wasting resources checking fields where there is no useful data. You are MUCH better off limiting the formula to rows that have valid data..

Totally makes sense. You make a good point. Thanks!

 

[Fuzzyreets]

Help with a similar sheet?

These formulas are designed on a set of data. So if you were you add new rows or columns, the expectation is that you'd update the formula appropriately. Using an arbitrary value like the 1000 I suggested, while will get you want you want, is wasting resources checking fields where there is no useful data. You are MUCH better off limiting the formula to rows that have valid data..

Hi Raz0r. Not sure if you're still monitoring this or not but I thought I'd give it a shot as I continue to use Numbers more. I'm trying to work on a new sheet for monthly budgeting that will include a pie chart. I love pie charts. I have a column that has a few different categories utilizing drop down menu, next to that I have the amount of the purchase related to that category, and next to that I have the beginning of the data that I will use for the pie chart, much like how you explained this other sheet in this thread. I want to make a pie chart that charts out the amounts associated with the category as shown in the screenshot I took which I've added to this. I want the pie chart to chart out the amounts based on the category. Help would be greatly appreciated! Thanks.