5 Replies Latest reply: Jul 27, 2013 3:12 PM by AliM1987
Level 1 (10 points)

I would like to be able to select a persons name from the Pop-up menu in the E column to chose who has bought an item. I would then like to create a pie chart showing how much money each person has spent on buying the items and have this update automatically. I have no idea how I would go about doing this. Any help would be greatly appreciated.

Thanks

MacBook Pro, OS X Mountain Lion (10.8.4)
• ###### 1. Re: How to create a pie chart from a pop-up menu in Numbers?
Level 1 (105 points)

Just to be clear - Do you want a separate pie chart for each individual, with breakdowns for what they bought?

Or - a single pie chart showing what each person's total expenditure?

• ###### 2. Re: How to create a pie chart from a pop-up menu in Numbers?
Level 1 (105 points)

Costs per person, with "Ali & Baker" as a separate entity (since no provision for separating costs)

The formula is this:

=SUMIFS(\$Cost, \$Who Bought it?, "="&\$Who Bought it?, \$Bought?, "=TRUE")

The reasoning is:

Sum all Costs, if the following conditions are true:

\$Who Bought it?, "="&\$Who Bought it?

Group items in the 'Who Bought it? column that match the item in the same row as the formula.

\$Bought?, "=TRUE"

Only include items that have actually been bought.

Screenshot

I have highlighted the selected cell in red.

The coloured columns show which ones are relevant to the formula.

To create the totals, I added Footer rows to the table.

You could make a separate table if you prefer.

To create the pie chart, I selected just the costs in the footer rows, and clicked on Charts.

• ###### 3. Re: How to create a pie chart from a pop-up menu in Numbers?
Level 1 (10 points)

Thank you for the reply. I have put the formula =SUMIFS(\$Cost, \$Who Bought it?, "="&\$Who Bought it?, \$Bought?, "=TRUE")  into cell D24 and all it does is brings up a price of £0.00. Is there something I am doing wrong? I am quite new to Numbers so haven't tried anything like this before. Cheers

• ###### 4. Re: How to create a pie chart from a pop-up menu in Numbers?
Level 1 (105 points)

Note that I put the person into the Who Bought it? column, next to the SUMIFS

Please reproduce exactly what I showed in the screenshot.

• ###### 5. Re: How to create a pie chart from a pop-up menu in Numbers?
Level 1 (10 points)

Fantastic. Thank you