Format Y-axis value ? Urgent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know to set the maximum Y-Axis value by using VB6.0

remarks
the chart automatically create on excel sheet by using Vb 6.

thanx in advance

Daniel.
 
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.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top