Looking for a Budget vs Actual trend charts

[ghsubs1]

Is there a BUDGET TREND solution showing budget vs actual for Google Sheets that will display a chart like this spending chart from the Dashboard sheet? I want a trendline showing budget vs actual, with x-axis granularity by day or week preferably, and hopefully I can select any or all categories (functions similar to the Dashboard)

[MarcC]

Not exactly what your looking for but the Monthly Analysis sheet gets you closer.

[ghsubs1]

Thank you…yes closer…

[Cowboy13]

Here is another possible solution…

Cash Flow forecast by month based on YTD Actuals and remaining monthly budget

Overview I have a highly variable income (and expenses) month to month and my cash flow will frequently go negative for a few months before it turns positive. Because of this, I am very interested in YTD monthly actual cash flow and what my budgeted cash flow per month looks like for the remainder of the year. With this info, I can determine which months I will need to cover expenses through other means and when I will catch up. I started with someone else’s spreadsheet template that showed …

I originally did it for Cash Flow since that did not exist.

You can choose Income, Expense, cash flow, all groups and categories or a single group or category. It will show by month and YTD totals for both actual and budget.

All the data is there; you could easily change the chart type to be a line chart like you want.

[twalane]

Thank you @Cowboy13 , does that suggestion get you closer to what you’re looking for @ghsubs1 ?

[ghsubs1]

Yeah! I’m anxious to give it a go!

[ghsubs1]

I just saw this…thank you! I’ll try to give it a go this evening!