Different unit distance on axis

[Siberian]

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

 

[Andy Pope]

Hi,

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

Cheers
Andy

 

[Siberian]

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

 

[Andy Pope]

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

 

[MrShorty]

Seems overly complicated to me. 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.

 

[MrShorty]

Seems overly complicated to me. 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.

 

[MrShorty]

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.

 

[MrShorty]

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.