In XL, turn on the macro recorder (Tools | Macro > Record new
macro...), change the y-axis scale maximum by hand, and turn off the
recorder. XL will give you the necessary code.

Signature
Regards,
Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
> Does anyone know to set the maximum Y-Axis value by using VB6.0.
>
[quoted text clipped - 4 lines]
>
> Daniel.