Same scale for primary and secondary axis

Hi!
I am using primary and secondary axis for creating overlapping bars using VBA. The problem is that there should be same scale for both axis, which changes (every time I run the code, there can be different Max value). I was thinking - is it possible:

1) to find max value in column E and assign this value to variable "variable_containing_max_value";
2) Put this variable as maximum scale something like this:

Please Login or Register  to view this content.

3) The same for secondary axis.

Thank you very much!

Thank you very much!
I appreciate your efforts!