Double chart animation with VBA

• The charts below represent the water level in two tanks. Each one has two series of stacked columns, and the data cells are A1 and B1. There is a link to the workbook on this post.
• The idea is to transfer water from one tank to another, so just enter a percent level variation for one tank, like 20 or -30, and the charts will gradually change.
• The animation speed can be adjusted in the code.
• This is part of a larger project, so the code may look a bit weird.

...

Click to expand...