billsmith90
New Member
- Joined
- Oct 19, 2016
- Messages
- 3
https://1drv.ms/x/s!AntW1ZrWMeX2gQNq01G4gmqqiJfO
ok i am very new to excel - and it does bamboozle me a lot!!!
what i am trying to do is to get the savings total to show up on the dash board just like income, expenses show up, after several hours of research i managed to get the "chart data page" to show up.
i then added the savings line (right at the bottom of "chart data" page) but i can not get it to show the right amounts on the dashboard page. I believe it is to do with the formula i have used for savings on the "chart data" page (=INDEX(Budget!C13:O13,,period)
could someone help me get the right formula so my dashboard up dates properly (Dashboard page has a scroll button at the bottom for each month - amounts should update as you scroll through the months)
let me know if this make sense or you need more info
thank you very much
ok i am very new to excel - and it does bamboozle me a lot!!!
what i am trying to do is to get the savings total to show up on the dash board just like income, expenses show up, after several hours of research i managed to get the "chart data page" to show up.
i then added the savings line (right at the bottom of "chart data" page) but i can not get it to show the right amounts on the dashboard page. I believe it is to do with the formula i have used for savings on the "chart data" page (=INDEX(Budget!C13:O13,,period)
could someone help me get the right formula so my dashboard up dates properly (Dashboard page has a scroll button at the bottom for each month - amounts should update as you scroll through the months)
let me know if this make sense or you need more info
thank you very much
