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" wrote in message
oups.com...
is there a way i can tighten the range using a macro for two y-axis in
the same chart.