Thread: Locking gridlines to be square - axes to same scale ?

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.

--
Nigel M

"Time may be a great healer,
but he's a lousy beautician"

Nigel,

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

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

----
Regards,
John Mansfield
http://www.pdbook.com


"Nigel M" wrote:

> 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.
>
> --
> Nigel M
>
> "Time may be a great healer,
> but he's a lousy beautician"
>

In microsoft.public.excel.charting, John Mansfield wrote:

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


--
Nigel M

"Time may be a great healer,
but he's a lousy beautician"