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?


--
Siberian
------------------------------------------------------------------------
Siberian's Profile: http://www.excelforum.com/member.php...o&userid=25361
View this thread: http://www.excelforum.com/showthread...hreadid=388441

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

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


--
Siberian
------------------------------------------------------------------------
Siberian's Profile: http://www.excelforum.com/member.php...o&userid=25361
View this thread: http://www.excelforum.com/showthread...hreadid=388441

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



--

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

Seems overly complicated to me. If it fits into what you want to
accomplish, why not force the plotarea to be squa

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
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=388441

Seems overly complicated to me. If it fits into what you want to
accomplish, why not force the plotarea to be squa

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
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=388441

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

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
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=388441

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

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
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=388441