Plotting x-y data to same physical dimension on plot

  • Thread starter Thread starter Opsimath1939
  • Start date Start date
O

Opsimath1939

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?
 
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
 
Back
Top