Scaled Chart Axes

I have created a chart from data in Excel and I would like to be able to
scale the axes (both x and y) to say 2cm per gradation - ending up with a
square chart with each gridline 2cm apart.
Is this possible to achieve in vb?
All help appreciated - thanks

Jon Peltier has instructions for squaring the gridlines:

http://www.peltiertech.com/Excel/Cha...t.html#SqrGrid

patrick wrote:
> I have created a chart from data in Excel and I would like to be able to
> scale the axes (both x and y) to say 2cm per gradation - ending up with a
> square chart with each gridline 2cm apart.
> Is this possible to achieve in vb?
> All help appreciated - thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html