I am trying to make a personal financial tool / dashboard.
I am making a doughnut chart first off to represent savings that make up a percentage of a savings goal.
E.g. goal: 100k, savings: 50k, 50% doughnut chart.
The problem I'm facing is:
The data that will be entered will be continuous and therefore I need the doughnut chart to constantly search for the last value in a column.
I have it set up as follows:
Column A = date, Column B = Savings Column C = Goal Column D = Accumulation of savings (cell+previous cell etc)
It works fine, but I just don't know a way to make it find the last value of column D without me putting it in.