Apple Event: May 7th at 7 am PT
I would like to be able to select a persons name from the Pop-up menu in the F 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
Numbers-OTHER, OS X Mountain Lion (10.8.2)
1) make sure the pop-up has all the people in the list before you start.
2) eter the data in the table as you have shown then
3) add a new summary table (called "Summary"). Let's assume your existing table is titled "LOUNGE".
Add a new column (G) to your existing table, titled "Lounge":
G2=IF(ISBLANK(F2), "",IF(IFERROR(MATCH(F2, $F$1:F1, 0), 0)=0, MAX($G$1:G1)+1, ""))
select G2 and fill down as needed
Now make a new table (and call it "Summary"):
the first row and first column are headers.
A2=IF(ROW()-1<=MAX(Lounge :: G), OFFSET(Lounge :: $F$2, SMALL(Lounge :: G, ROW()-1)-1, 0, 1, 1), "")
select A2 and fill down as needed
B2=IF(LEN(A2)>0, SUMIF(Lounge :: F, "="&A2, Lounge :: D), "")
select B2 and fill down as needed
now select the cells B2 thu the end of the column then select the pie chart from the charts menu
1) make sure the pop-up has all the people in the list before you start.
2) eter the data in the table as you have shown then
3) add a new summary table (called "Summary"). Let's assume your existing table is titled "LOUNGE".
Add a new column (G) to your existing table, titled "Lounge":
G2=IF(ISBLANK(F2), "",IF(IFERROR(MATCH(F2, $F$1:F1, 0), 0)=0, MAX($G$1:G1)+1, ""))
select G2 and fill down as needed
Now make a new table (and call it "Summary"):
the first row and first column are headers.
A2=IF(ROW()-1<=MAX(Lounge :: G), OFFSET(Lounge :: $F$2, SMALL(Lounge :: G, ROW()-1)-1, 0, 1, 1), "")
select A2 and fill down as needed
B2=IF(LEN(A2)>0, SUMIF(Lounge :: F, "="&A2, Lounge :: D), "")
select B2 and fill down as needed
now select the cells B2 thu the end of the column then select the pie chart from the charts menu
Thank you. Sorted my problem perfectly
Creating a pie chart based on Pop-up Menu in Numbers
