+ Reply to Thread
Results 1 to 9 of 9

Changing values of x-axis, and descending order axis(x-axis)

  1. #1
    Registered User
    Join Date
    01-08-2009
    Location
    Canada
    MS-Off Ver
    Excel 2000
    Posts
    12

    Changing values of x-axis, and descending order axis(x-axis)

    Hello,

    Two questions:
    1) How do make values on x-axis as words? E.g. apples, oranges, etc.
    2) Is it possible to have the numbers on x-axis in descending order? If I can figure out 1), I can do this as well, but it would be nice to know if it is possible to have the numbers on x-axis in descending order.

    Thank You in advance.
    Last edited by J10; 02-12-2009 at 10:13 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,831

    Re: Changing values of x-axis, and descending order axis(x-axis)

    It will depend on the chart type.
    If the axis is of category type then you can link the range of cells containing label text via the Source data dialog.

    You can reverse the order of the axis via the Scale tab of the Format Axis dialog.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-08-2009
    Location
    Canada
    MS-Off Ver
    Excel 2000
    Posts
    12

    Re: Changing values of x-axis, and descending order axis(x-axis)

    Got the reverse order. How do I move the numbers to the left of the y axis (maximum)?

    I have a chart type: "XY (Scatter) with data points connected by lines".
    Please see the attached settings that I have for x-axis. I still have numbers showing up on the x-axis.
    Attached Images Attached Images

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,432

    Re: Changing values of x-axis, and descending order axis(x-axis)

    An xy scatter chart compares numerical values (x versus y) if you want the x axis to be text, try line charts.
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  5. #5
    Registered User
    Join Date
    01-08-2009
    Location
    Canada
    MS-Off Ver
    Excel 2000
    Posts
    12

    Re: Changing values of x-axis, and descending order axis(x-axis)

    Great, got that.
    Also need to change Category (X) axis to Category from Automatic: Chart Options->Axes->Primary Axis-> Category (X) axis->Category.

    Still have a question about moving the numbers to the left of the y axis (maximum) when the revers is used.

  6. #6
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,432

    Re: Changing values of x-axis, and descending order axis(x-axis)

    Are you asking for the maximum space between the axis and the numbers?

  7. #7
    Registered User
    Join Date
    01-08-2009
    Location
    Canada
    MS-Off Ver
    Excel 2000
    Posts
    12

    Re: Changing values of x-axis, and descending order axis(x-axis)

    No, I would like to move y-axis values to the far left (to the left of '8' in the attached image).
    Attached Images Attached Images

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,831

    Re: Changing values of x-axis, and descending order axis(x-axis)

    On the X axis format dialog check both
    Values in Reverse Order
    Value (Y) Axis crosses at Maximum value

  9. #9
    Registered User
    Join Date
    01-08-2009
    Location
    Canada
    MS-Off Ver
    Excel 2000
    Posts
    12

    Re: Changing values of x-axis, and descending order axis(x-axis)

    Solved, thanks!

+ Reply to Thread

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.6.0 RC 1