# Adding Progress Bars to the Savings Budget **URL:** \ **Category:** gSheets Templates\ **Tags:** budgeting, tcs-savings-budget\ **Created:** [January 27, 2021, 4:50am UTC](https://community.tiller.com/t/adding-progress-bars-to-the-savings-budget/7355 "2021-01-27T04:50:09Z")\ **Posts on this page:** 1\ **Showing post:** 14
**Author:** ![cculber2](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/cculber2/32/4099_2.png) [@cculber2](https://community.tiller.com/u/cculber2)\ **Post date:** [February 4, 2021, 6:13pm UTC](https://community.tiller.com/t/adding-progress-bars-to-the-savings-budget/7355/14 "2021-02-04T18:13:13Z")
I did some more investigation, and it seems the solution was far simpler [than I was imagining](https://community.tiller.com/t/tiller-money-labs-roundup-2-2-21-savings-budget-improvements/7474/8). I was able to update the `Actuals, Expense` formula in `K22` and the `Actuals, Income` formula in `K23` to sum the `Modified Actuals` in `AO11:AO` rather than the `Period Actuals` in `AI11:AI`. Making this change yielded the expected expense and income values in the sparkline. **Actuals, Expense, `K22`** > `=sumproduct(($AE$11:$AE="Expense"),($AG$11:$AG<>"Hide"),$AO$11:$AO)` **Actuals, Income, `K23`** > `=sumproduct(($AE$11:$AE="Income"),($AG$11:$AG<>"Hide"),$AO$11:$AO)` On a side note, I do _not_ recommend adjusting the formulas for `Actuals Prior to Period` in `P10` and `Actuals in Period` in `S10`, as it throws off the `ACTUAL` calculation in `E12`, and possibly elsewhere. I also noticed a polarity issue for `Net Budgets` in `K13` for all periods. The formula is set to `Budget, Expense - Budget, Income` whereas the current period calculates it in `K21` as `Budget, Income - Budget, Expense`. I made a simple correction of swapping the terms. **Net Budgets, `K13`** > `=K12-K11` --- _[View the full topic](https://community.tiller.com/t/adding-progress-bars-to-the-savings-budget/7355)._