I'm not sure I understand the question -- perhaps because it seems so obvious to me that it feels like there is something about the question that I am missing.
As explained in the help file for the maximumscale property (https://msdn.microsoft.com/en-us/vba...property-excel linked from above help file), the maximumscale property can return or set (read/write) the maximum scale property. In my sample code above, where I have "whatever you are doing to determine what the max axis value should be", you could put the maximumscale property of the primary axis, then assign that value to the maximumscale property of the secondary axis:
Is that all there is to your question, or is there more that I am missing?
Bookmarks