Locking gridlines to be square - axes to same scale ?

[Nigel M]

I've used Excel to draw a parabola, and now I want to print it.

The trouble is that the scales of the x and y axes are arbitrary, so the
graph looks squashed. Rather than use trial and error, I figure there
must be a way to lock the axes to the same scale, so the gridlines would
be square.

I've done a Google, but didn't come up with anything useful.

I'm using Office 2003 BTW.

 

[Guest]

Nigel,

Jon Peltier's "Make Gridlines Square" example can probably help:

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

 

[Nigel M]

Jon Peltier's "Make Gridlines Square" example can probably help:

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

Thanks, I had actually found that, but didn't understand how to get the
code loaded! I think I've sorted it now anyway, I found that you could
re-size the "plot area" and after a couple of tests, I got it right.

I also needed the scale on the axes to be 1cm per major unit, so I think
trial-and-error was the only way. Why on earth can't Excel do this?