2 Replies Latest reply: Apr 30, 2013 2:53 PM by AliM1987
AliM1987 Level 1 Level 1 (10 points)

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.



Screen Shot 2013-04-30 at 19.38.31.png

Numbers, OS X Mountain Lion (10.8.2)
  • Wayne Contello Level 6 Level 6 (16,400 points)

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


    Screen Shot 2013-04-30 at 2.43.47 PM.png


    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"):

    Screen Shot 2013-04-30 at 2.45.14 PM.png

    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

  • AliM1987 Level 1 Level 1 (10 points)

    Thank you. Sorted my problem perfectly