2 y-axis want to use a macro to tighten the range on both

[HBS]

is there a way i can tighten the range using a macro for two y-axis in
the same chart.

 

[Bernard Liengme]

Please explain more.
Do you want a secondary axis? Do you want to change the scale on the axis/