+ Reply to Thread
Results 1 to 7 of 7
  1. #1
    Registered User
    Join Date
    05-02-2008
    Posts
    10

    Plotting problem

    hey all,

    assume I have data from 1 to 10 on my y axis. How can I plot them inversely, from 10 to 0?

    thanks,
    Tuugii

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,941
    Do you mean Y (Value) axis?

    Can you post example. Maybe use a couple of shape to demonstrate the effect you are after.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-02-2008
    Posts
    10
    yes in y-axis.

    so for example, on my attached file you have [1,10] to be plotted on my y-axis; and [100,190] to be plotted on my x-axis.

    When I plot them I will have values on my y-axis starting from the lowest getting bigger as it goes up.

    But I wanted inversely, starting from the biggest getting lower as it goes up. How do I do that?

    thanks for the help,
    Tuugii
    Attached Files Attached Files

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,941
    If you reverse the order of the Y axis the data will go from highest DOWN to lowest along the X axis.

    If you reverse the order of both Y and X axis the data will go highest UP to Lowest.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    05-02-2008
    Posts
    10
    thanks a lot!

    but how do I reverse it?

  6. #6
    Forum Guru Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    Cheshire, UK
    MS-Off Ver
    MS 97, 2003, 2007, 2010
    Posts
    2,895
    Thread moved to correct forum!

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,941
    Double click the axis and on the scale tab is the option to reverse the axis.
    Also check the Crosses at maximum in order to keep the axis on the left or bottom.
    Cheers
    Andy
    www.andypope.info

Thread Information

Users Browsing this Thread

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

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.2.0