View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
smartin smartin is offline
external usenet poster
 
Posts: 915
Default 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.