Skip navigation

Creating a pie chart based on Pop-up Menu in Numbers

422 Views 2 Replies Latest reply: Apr 30, 2013 2:53 PM by AliM1987 RSS
AliM1987 Level 1 Level 1 (10 points)
Currently Being Moderated
Apr 30, 2013 11:50 AM

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

Screen Shot 2013-04-30 at 19.38.31.png

Numbers, OS X Mountain Lion (10.8.2)
  • Wayne Contello Level 6 Level 6 (12,660 points)
    Currently Being Moderated
    Apr 30, 2013 12:46 PM (in response to AliM1987)

    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

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

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.