Worf
Well-known Member
- Joined
- Oct 30, 2011
- Messages
- 4,261
Worf submitted a new Excel article:
Double chart animation with VBA - This code shows how to animate two charts simultaneously.
Read more about this Excel article...
Double chart animation with VBA - This code shows how to animate two charts simultaneously.
...
- 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.
Read more about this Excel article...