+ Reply to Thread
Results 1 to 3 of 3

How to make X and Y axis equally scaled?

  1. #1
    Registered User
    Join Date
    10-26-2014
    Location
    Novi Sad
    MS-Off Ver
    2013
    Posts
    3

    How to make X and Y axis equally scaled?

    Hi all!

    Is there any way to set X and Y axis ticks to be equal? For example if Y goes from 0 to 10 I want it to be 10cm, and if in the same time I have X that goes from 0 to 20 I want it to be 20cm. I can do it manualy by draging the corner of the graph, but it would be nice for the Plot to be "properly scaled" automatically.
    I want to plot beam deformation. I attached two pictures, showing "bad" and "good" scaling.

    Thank you!
    7.jpg6.jpg

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,115

    Re: How to make X and Y axis equally scaled?

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    10-26-2014
    Location
    Novi Sad
    MS-Off Ver
    2013
    Posts
    3

    Re: How to make X and Y axis equally scaled?

    Green cells contain values that are linked to Graph (change them to see how graph changes). In second sheet (named "Changed") that is virtually the same as the firs one, I manually scaled graph-as good as I manually could; I used blue square as a reference.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to plot discrete data on a large scaled axis?
    By Parv in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 10-31-2013, 05:03 AM
  2. [SOLVED] Pivot Chart Date Axis, need dates seperated proportionally not equally
    By Peter.M in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 10-18-2013, 09:51 AM
  3. Reading values from a logarithmic scaled x-axis
    By lightning87 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-27-2007, 04:03 PM
  4. [SOLVED] Charts with scaled axis
    By Steve in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-13-2006, 03:15 AM
  5. can I make the vertical axis the category axis in Excel line graph
    By power1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2006, 04:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1