Square graph in excel?
Square graph in excel?
(OP)
Hi,
Is there any way to force excel to draw the X and Y axes at the same scale?
Is there any way to force excel to draw the X and Y axes at the same scale?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: Square graph in excel?
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Square graph in excel?
Insert the following:
Selection.Width = 450
Selection.Height = 450
Select the chart
run the macro
TTFN
RE: Square graph in excel?
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Square graph in excel?
TTFN
RE: Square graph in excel?
For example if I plot y=x it would be 45 degree from horizontal with 1:1 aspect ratio.
But if X axis is 0-10 and Y axis is 0-100, then a plot of Y=X will be about 10 degrees from horizontal.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Square graph in excel?
------------------------------------------
"...students of traffic are beginning to realize the false economy of mechanically controlled traffic, and hand work by trained officers will again prevail."
Wm. Phelps Eno, ca. 1928
RE: Square graph in excel?
------------------------------------------
"...students of traffic are beginning to realize the false economy of mechanically controlled traffic, and hand work by trained officers will again prevail."
Wm. Phelps Eno, ca. 1928
RE: Square graph in excel?
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Square graph in excel?
There was a vba solution I posted in the linked thread 3 Dec 05 which met my needs very well (one execuation of the macro auto-scales and sets 1:1). It was based on another posters information prior to that in the thread. Subsequent modification was made but I don’t know what it did.
Also at the end of the thread, Yakpol had a suggestion for creating a phantom series that when autoscaled would accomplish the same thing. I never tried it.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Square graph in excel?