Format Y-axis value ? Urgent

D

Daniel

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

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Use text descriptors as Y axis units 1
Coordinate secondary y axis to primary y axis 2
Excel 2010 - Line Chart with Mulitiple Data Sets 1
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Positioning x axis at bottom of chart with negative values 5
Conditional number format of x-axis based on value? 2

Top