If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|