Chart Scaling
 

Hi,

I have created some charts with excel automation from VB 6, and the Y
axis scale is automatic assigned. I'd like to know how could I specify
y axis scale (minimun and maximun values). Also I'd like to know how to
assign x and y axis label to the chart.

Thank you very much,
Hsin-Ni



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Chart Scaling
 

Run the macro recorder in Excel while doing it manually to get the
appropriate syntax.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

asphalt wrote:
Hi,

I have created some charts with excel automation from VB 6, and the Y
axis scale is automatic assigned. I'd like to know how could I specify
y axis scale (minimun and maximun values). Also I'd like to know how to
assign x and y axis label to the chart.

Thank you very much,
Hsin-Ni



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/