How to force chart axis to same scale

[Sandusky]

I'm graphing simple polynomial functions, but I can't figure out how
to force the x and y axis to the same scale. Can this be done?

 

[Jon Peltier]

You have to set the axis scales so they are the same: right click on the
axis, Format, Scale tab in 2003 or main tab in 2007, change min and max to
appropriate values and don't check any auto option next to the scale boxes.

Then you need to stretch the chart so that the height and width of its plot
area are the same.

- Jon

 

[Sandusky]

Thanks, Jon. Coincidentally I am on your Excel chart page right now.
Yay Google!

Can I use VBA to do this? I'm assuming the answer is yes. The reason
I ask is that my data series is based on an Xmax and an Xmin, which
are dynamic and change frequently.

 

[Jon Peltier]

This tutorial describes something similar to what you want. Maybe you can
use it as a starting point.

http://peltiertech.com/Excel/Charts/SquareGrid.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


Thanks, Jon. Coincidentally I am on your Excel chart page right now.
Yay Google!

Can I use VBA to do this? I'm assuming the answer is yes. The reason
I ask is that my data series is based on an Xmax and an Xmin, which
are dynamic and change frequently.