I have two stacked column charts which I am using to compare two similar data sets.
Each chart depicts one of the data sets. The purpose of the charts is to compare these two data sets.

The data sets comprise of 40 and 28 data series respectively.
The stacked column charts have been constructed in a way that allows a subset of the data sets to be displayed at any instance.
I have programmed several command buttons to toggle particular sets of data series on and off.
For example, I can set chart 1 to display only data series 1 to 4, 24 to 29 and 40. In this scenario, Chart 2 would data display series 5 to 10.

My question is simple: how do I make both charts have the same maximum on the vertical axis?

As I have little experience using VBA, I would prefer to avoid it. However, I'm prepared to work through some code if it is deemed necessary to achieve my desired result. Also, it is clear that the common maximum must be equal to the greater of the maximums of each of the individual charts. Currently both maximums are set to 'automatic' and it would be preferable if the common maximum was set to be the greater of the 'automatic' maximums generated by excel for each chart.

Would appreciate it if someone could at least point me in the right direction.