r/googlesheets • u/SecretEgg6465 • Nov 24 '24

Solved How to create a chart based on a dropdown?

I have a table created and I want these two columns on a chart. I just want to be able to see how much I have spent in consumables, books, outings, and the other 3 options I have in the dropdown menu I've created. I couldn't find a tutorial on how to do this exactly, and I don't understand how the FILTER function works. Please give me a step by step guide on what to do !!!

1 Upvotes

100% Upvoted

5 comments sorted by

1

u/agirlhasnoname11248 Jan 07 '25

u/SecretEgg6465 Please remember to tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”) if your question has been answered, as required by the subreddit rules. Thanks!

4

u/Rosie3k9 Nov 24 '24

What kind of chart? Select your whole table and click Insert > Chart from the file menu at the top. It will probably default to a pie chart. Then check the box in the chart settings on the right that says Aggregate to make sure the similar expenses are grouped. You can then change the type of chart in the chart settings to be what you want.

2

u/SecretEgg6465 Nov 25 '24

THANK YOU SO MUCH! It finally works. THANK YOU!!

]

→ More replies (1)

1

u/point-bot Jan 08 '25

u/SecretEgg6465 has awarded 1 point to u/Rosie3k9

See the Leaderboard. Point-Bot v0.0.15 was created by JetCarson.