Columns on a graph

[jeff2813]

Hi there, just wondering if a column on a graph can be made to change as different cells are chosen. As an example, Column c, cell C2 is $400. The graph shows $400. If i take $200 from the total, Column c, cell C3 becomes $200. I would like the graph to now show the new balance from C3 instead of the old balance in cell C2. As i make multiple transactions i would like only the last balance showing in the column cell to be on the graph. I hope this makes sense. Thank you.

 

[Caleeco]

Hi Jeff,

So you're looking to plot just the last value in Column C? Something like this?

https://gifyu.com/image/kCQB

I achieved this with a helper cell, with the following formula:

=INDIRECT("C"&COUNTA(C:C))

Hope that helps
Caleeco