excel should make it easier to have a 1 to 1 plot area in chart

[Andy]

Sometimes I would like the plot area to have a 1 to 1 ratio, so each little
square of the gridlines are a square. ie, the y- axis could be 10, the x-
axis could be 10, so the plot area would be square, or the y- axis could go
from -10 to 10, with the same x- axis, so the plot area would have twice the
y- axis than the x- axis.

I think the way microsoft has this place worded is misleading, cause it says
"Post your suggestion." I don't mean to put anyone off.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...6abdad4cc9&dg=microsoft.public.excel.charting

 

[T Charts ??? Litvin]

Hi Andy, have you tried formating your graph to show the axis in your
"square" ratio. When you format axis, you will be able adjust the scale, and
tweak your min and max values to show you a 1 : -1 or 10 : -10 relationship.
Try it out, hope that helps.

 

[Jon Peltier]

It's not perfect, but I have a little routine that produces square
gridlines:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______