Different unit distance on axis

I would like both of the axis to have the same distance between their units. I manage to make it so that both axis increase by 1 by each tick, but the physical distance between each tick is not the same on both axis. The x-axis might have 2cm between each tick, while the y-axis has 3cm. This creates a false impression of what the graph actually looks like. I know I can drag the window sideways or up and down to change this, but that would only be approximate. Anyone?

Hi,

Maybe this article will help.
http://peltiertech.com/Excel/Charts/SquareGrid.html

Cheers
Andy

Siberian wrote:
> I would like both of the axis to have the same distance between their
> units. I manage to make it so that both axis increase by 1 by each
> tick, but the physical distance between each tick is not the same on
> both axis. The x-axis might have 2cm between each tick, while the
> y-axis has 3cm. This creates a false impression of what the graph
> actually looks like. I know I can drag the window sideways or up and
> down to change this, but that would only be approximate. Anyone?
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

No need to be scared

You should not need to install anything else.
The code can be copied from the page, just highlight the text and
CTRL+C. Use CTRL+V within a code module to paste code.

Jon also has some explanation of VBA (Visual Basic for Applications) on
his site.

If you get really lost post back.

Cheers
Andy

Siberian wrote:
> Thanks, I suppose this will help me, but I'm totally new to VBA (don't
> even know what it stands for) and so it looks a bit scary. Do I need to
> install something else? Will I find the text that is written on this
> page somewhere, and then edit it, or am I supposed to write it from
> scratch?
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

If it fits into what you want to accomplish, why not force the plotarea to be square:

sub squarechart()
With activechart.plotarea
h=.height
.width=h
end with
end sub

this will force the plotarea to be square. I'm not sure how closely this will force the axes to be equal in length, but that could be checked (using the height/width properties of the axis object) and the width/height of the plotarea adjusted accordingly.

Note that I've assumed that height is the smaller dimension. If width is the smaller dimension, switch the height and width accordingly.