Plotting x-y data to same physical dimension on plot
 

I have a series of x-y plots to make using Excel. All values of x and y are
in range +10 units to -10 units. However when I plot the data in Excel, the
plot is distorted as the physical size per unit on the the x and y axes is
not the same. How can I plot the data so that say 1unit is say 1cm long on
both x and y axes? In other words, if the data is for say an ellipse how do I
plot the data so that the output really is an ellipse?

Plotting x-y data to same physical dimension on plot
 

Opsimath1939 wrote:
I have a series of x-y plots to make using Excel. All values of x and y are
in range +10 units to -10 units. However when I plot the data in Excel, the
plot is distorted as the physical size per unit on the the x and y axes is
not the same. How can I plot the data so that say 1unit is say 1cm long on
both x and y axes? In other words, if the data is for say an ellipse how do I
plot the data so that the output really is an ellipse?

Well an ellipse looks like an ellipse, regardless of the axis scales,
right? (^:

But I understand your frustration. AFAIK Excel provides no means to
ensure the chart axis units have the same appearance on-screen. However,
if you drag the chart corners until it looks right, then you can at
least resize the result using Shift+Drag to keep the proportions the same.

Plotting x-y data to same physical dimension on plot
 

And you can try running something like this in VBA

With Worksheets(1).ChartObjects(1)
.Height = .Width
With .Chart
.Axes(xlValue).MaximumScale = .Axes(xlCategory).MaximumScale
.Axes(xlValue).MinimumScale = .Axes(xlCategory).MinimumScale
.PlotArea.Height = .PlotArea.Width
End With
End With

Ed Ferrero
www.edferrero.com