Columns on a graph

jeff2813

New Member
Joined
Jul 17, 2019
Messages
29
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.
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Caleeco

Well-known Member
Joined
Jan 9, 2016
Messages
934
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:
Code:
=INDIRECT("C"&COUNTA(C:C))
Hope that helps
Caleeco
 

Watch MrExcel Video

Forum statistics

Threads
1,098,878
Messages
5,465,226
Members
406,419
Latest member
ldp124

This Week's Hot Topics

Top