Benches Uncategorized

5

How can I chart values from a dropdown?

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

Hi,

I created a Numbers file where one column contains a dropdown. The dropdown contains values for expense categories, such as Bill, Fuel, Groceries, Supplies, Home, Entertainment, etc.

I'd like to create a chart, where the horizontal (X) axis would contain the values from the dropdown (Bill, Fuel, Groceries, etc) and the vertical (Y) axis would contain the monthly values. Eg, it would show how much you spent each month for Groceries, Supplies, etc.

I don't seem to be able to plot values based on a dropdown because I can only select cell values. Is there any way to do this?

Thanks.

5 replies

Sign in or join Beachball Help to reply.

  1. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi TadWi,

    Have a look at the Personal Budget template in Template Chooser. The Transactions Sheet has Pop-Up Menus for the categories. The Budget Sheet uses the SUMIF function to sum each category. This could be extended by using the SUMIFS function to sum over categories and months. In fact SGIII has written a Numbers document to do just that. Perhaps SGIII will call in here later.

    Regards,

    Ian.

  2. 0

    TadWi

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Sorry, I meant "Pop-Up Menu" - just in case...

  3. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi TadWi,

    Have a look at the Personal Budget template in Template Chooser. The Transactions Sheet has Pop-Up Menus for the categories. The Budget Sheet uses the SUMIF function to sum each category. This could be extended by using the SUMIFS function to sum over categories and months. In fact SGIII has written a Numbers document to do just that. Perhaps SGIII will call in here later.

    Regards,

    Ian.

  4. 0

    SGIII

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Here's an expanded version (Dropbox download) version of the 'Personal Budget' template that sums over categories and months.

    SG

  5. 0

    TadWi

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thank you all! I was able to get it going.