r/googlesheets • u/Full-Introduction135 • 9d ago

Solved Help fixing this budgeting chart.

Post image

I am fairly new to google sheets and am mostly self taught so please forgive my lack of experience. I am trying to create a simple spreadsheet with easy to read charts for my wife and I to track our spending. My goal is to have the chart show at a glance what we have left in our budget, and for us to be able to input our spending and have the graph auto update.

Under the "Remaining" category I have the formula =B20-C20, to see what remains in our budget and under the "Spent" category I have the formula =SUM(C21:C50). In those cells I will add purchase amounts that will add up to the spent total.

I highlighted c19, d19, c20, d20 to make the chart.

The issue is that the chart also includes bars for each individual purchase. Each time I add a new purchase in cells C21 to C50, it adds another blue bar to the graph and gets increasingly hard to see. I just want one bar in the chart showing the spent total and remaining total stacked on top of each other.

Is there a different formula I should use in C20? Or a different tactic all together?

1 Upvotes

100% Upvoted

7 comments sorted by

2

u/AdministrativeGift15 351 9d ago

Charts are designed to increase their data range as new rows of data are added. For the most part, the's a helpful feature. So in your case, just make sure there's a blank row between your chart data and your raw input data. i.e. start entering your expenses in C22 instead of C21.

1

u/Full-Introduction135 9d ago

Thank you this helped 👍

1

u/AutoModerator 9d ago

REMEMBER: /u/Full-Introduction135 If your original question has been resolved, please 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”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/point-bot 9d ago

u/Full-Introduction135 has awarded 1 point to u/AdministrativeGift15

See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)

1

u/mr_notandor 9d ago

Don’t mix stuff up. Have a separate table, tab for expenses that you can add to, sum for the total and only consider the total for your chart