Adjusting scale of graoh

[jess_251]

I have a program that calculates the stresses at three points on a beam. Using these stresses, I want to calculate Mohr's Circle. I currently have one graph that changes when you switch between the three elements using a scroll bar. But the issue is the scale is not equal on both axes, causing the circle to be displayed as an ellipse. Also, the scale of the graph does not readjust itself as the data changes. Meaning, one element's graph looks more circular than the next. Is there any way at all to fix this? Either using VBA or general excel knowledge?

[shg]

Short of using VBA, you could fix the axes with min and max values sufficient to capture the range of values.

[Andy Pope]

If you plot a dummy series with same min and max data values for both x and y axis then the scaling should be consistent on both.
If you also use a dummy series plotted as pie you will have a square plot area.

[shg]

If you also use a dummy series plotted as pie you will have a square plot area.

Who knew ?