Yearly Category Chart for Google Sheets
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 you’re doing.
Support & Documentation
- View documentation for the Yearly Category Chart here the Tiller Community
- All Tiller Community Solutions are exclusively supported in the Tiller Community
This is simple but sleek, @jono. I’m enjoying it.
Thanks for sharing!
This is very cool. Thank you!
LOVE this sheet, and so very helpful. It is simple, sleek, clear in its presentation and data. Thanks!
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!
If it were me, I’d do a
FILTER()aroundA42for categories in the lookup group then reuse most of the formula inB42:M42to pull actuals for each by month. Total them up and put them on the chart. You could do something similar for the budgets.