The default plot area is not square on the display. The code basically stretches the plot area to be square on the display. The actual values to be used will depend on your display resolution.
Right-click on the axes, select "format axis" and set the scales to the same value.
------------------------------------------
"...students of traffic are beginning to realize the false economy of mechanically controlled traffic, and hand work by trained officers will again prevail."
It looks like you'd need to use IRstuff's macro as well for that to work. Any other ideas?
------------------------------------------
"...students of traffic are beginning to realize the false economy of mechanically controlled traffic, and hand work by trained officers will again prevail."
Manually you can quite obviously control whatever you want by manually resizing the chart area with the mouse and adjusting the graph axes. One problem – every time you change the data beyond the bounds you will again have to manually adjust the graph axis.
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.