Yearly Category Chart for Google Sheets

See a chart of your actual vs budget for a single category over the course of a year.

About the Yearly Category Chart for Google Sheets

This sheet shows you a chart of your actual vs budget for a single category over the course of a year. For non-regular categories which vary from month to month, this sheet gives a quick visual representation of how I’m doing.

The bars show the actual (black) and budget (blue) amounts for each month.

The lines show the running totals for the actuals (up to the current month) and budget (for the whole year.)

Support & Documentation


This is a free template built by a member of the Tiller Community. While it’s free for anyone to use, it’s designed for spreadsheets automated by Tiller. Additionally, it’s recommended for use within the Foundation Template.

Tiller is the only automated personal finance service for Google Sheets and Microsoft Excel. Tiller automatically imports your daily spending, income, and balances in your spreadsheets, so you can see all your finances in one place and manage your money, your way. Learn more →

Unless otherwise noted above, this free template is installed with the Tiller Community Solutions add-on for Google Sheets. It's an easy way to browse and install dozens of free, prebuilt sheets for tracking budgets, debt payoff goals, net worth, savings, and more, all from the Google Sheets sidebar.

This template for Excel works best when installed in Tiller’s Foundation Template.

Visit the Tiller Community with any questions about this template.

Notable Replies

  1. Avatar for randy randy says:

    This is simple but sleek, @jono. I’m enjoying it.
    Thanks for sharing!

  2. LOVE this sheet, and so very helpful. It is simple, sleek, clear in its presentation and data. Thanks!

  3. This is FABULOUS!! Thanks so much for sharing it. I love the simplicity of it and that it’s a visualization vs most of my analysis is just numbers, so this is way more “fun” to look at. haha!

  4. Very nice, thank you!

Continue the discussion at community.tillerhq.com

15 more replies


Avatar for heather Avatar for randy Avatar for jono Avatar for GregC Avatar for john.warren3 Avatar for kirsti.rehler Avatar for wreed4 Avatar for branadonshutter Avatar for morgan Avatar for chasbaker03 Avatar for jstrilich Avatar for whuisit

Start Your Free Trial

"There isn’t another tool on the market that does what Tiller can do.”
Will Hinton, Google Review October 30, 2023