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?
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.
0
TadWi·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Sorry, I meant "Pop-Up Menu" - just in case...
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.
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
0
TadWi·
Imported from the Apple Support Forums via the Wayback Machine 🔗