Say Cell A1 = Net Worth and it is updated periodically (sometimes weekly, sometimes monthly).



Instead of manually creating another table to store all past values in A1, is it possible to auto transfer these historical values in A1 to create my bar graph?

I want to eliminate the extra step of creating another table if possible.

Also like to know if I can plot the % change for every value without first creating the table too. Thank you.