## How to create a pie chart from a pop-up menu in Numbers?

443 Views 5 Replies Latest reply: Jul 27, 2013 3:12 PM by AliM1987
Level 1 (10 points)
Currently Being Moderated
Jul 27, 2013 8:03 AM

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)
• 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?

• 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.

• 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.

#### More Like This

• Retrieving data ...

#### Legend

• This solved my question - 10 points
• This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.