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

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

Please explain more.
Do you want a secondary axis? Do you want to change the scale on the axis/
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"HBS" <[email protected]> wrote in message
news:[email protected]...
> is there a way i can tighten the range using a macro for two y-axis in
> the same chart.
>