Last cell on column graph

28130

New Member
Joined
Sep 6, 2019
Messages
7
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

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,851
Office Version
365
Platform
Windows, MacOS
Are you only plotting one cell in the chart?
 

Watch MrExcel Video

Forum statistics

Threads
1,099,540
Messages
5,469,301
Members
406,647
Latest member
ssinovec

This Week's Hot Topics

Top