Locking gridlines to be square - axes to same scale ?

  • Thread starter Thread starter Nigel M
  • Start date Start date
N

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.
 
Jon Peltier's "Make Gridlines Square" example can probably help:

http://peltiertech.com/Excel/Charts/SquareGrid.html
Click to expand...

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?
 
Back
Top