×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel Graph Scale

Excel Graph Scale

Excel Graph Scale

(OP)
I'm sure this topic has come up before but I couldn't find anything on it.  Say I have the x & y coordinates for a circle.  When I graph it and then print it out, it appears to be an ellipse.  How do I get the printout of the circle to actually look like a circle instead of an ellipse?

RE: Excel Graph Scale

(OP)
That did the job.  Thanks!

RE: Excel Graph Scale

I think the problem has to do with the default aspect ratio that Excel uses for plots.

For example, make a simple X-Y plot with just the points (0,0) and (4,4).  It autoscales using 4.5 as the max scale for both axes.

Now using line draw, draw a vertical line from (1,1) to (0,1).  This gives you what the vertical scale considers to be a length of 1.

If you rotate that line 90 degrees and try to match it up with a horizontal distance of 1, you'll find that the rotated line is less than the horizontal distance.  Voila!

To compensate for this, I usually just just measure off a the distance (in inches or cm) corresponding to the full scale (in this case, 4.5) for each axis.  The ratio is the aspect ratio.

To compensate for this effect, change the vertical max scale from 4.5 to 4.5 times the aspect ratio.

Once this is done, everything will be balanced and circles won't look like ellipses.   

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources