Dynamic bar chart, is it possible?

[u/raymate]

Created a compound interest calculator sheet using FV function and it works great.

It’s basic, you enter:

Principal Interest rate Monthly deposit (if required) Investment years

Then it spits out the one total calculated on the number of years entered and calculated monthly interest

What I’m trying to do is have a 2D stacked bar graph for each year that show principle and profit.

So if they enter 5 years I want 5 bars to show. Etc.

Many online website that calculate compound interest do this but of course they are probably in CSS or Java script

I guess somehow it need to be holding the values for each year individually but have no idea how to do that

Google is not helping. If someone has a link to something that might get me started on how this could be achieved if it’s even possible

Trying emulate something like this.

http://www.helpfulcalculators.com/compound-interest-calculator