+ Reply to Thread
Results 1 to 2 of 2

Error Putting Axis Categories in Reverse Order

  1. #1
    Registered User
    Join Date
    05-25-2017
    Location
    Chicago
    MS-Off Ver
    Office 2016
    Posts
    31

    Error Putting Axis Categories in Reverse Order

    Hey everyone,

    I'm coming across a strange issue with my excel graph. The data I have listed is in the wrong order. I want the months to be ascending, to match the way they're displayed in the referenced cells. I saw that I should use the 'Categories in reverse order' button in the Format Axis form, but then the positioning gets moved in a way that I can't fix. Has anyone seen this before, and/or know how to fix it?

    Regular graph but in wrong order:
    Capture2.JPG


    Graph in correct order:
    Capture.JPG

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Error Putting Axis Categories in Reverse Order

    I cannot recreate the problem. When I create a stacked bar chart, I can reverse the categories without this effect. Can you upload a sample file that illustrates your problem or describe in detail how you created and formatted this chart? I don't think we will be able to help unless one of us can recreate the problem to see what is going on.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. [SOLVED] reverse order of plotting on x-axis
    By umbata in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-10-2015, 03:07 PM
  2. Replies: 9
    Last Post: 10-10-2015, 02:32 PM
  3. Replies: 0
    Last Post: 07-09-2015, 06:21 AM
  4. [SOLVED] Reverse Order of Y Axis...keep x axis the same
    By dsciola in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-13-2014, 02:10 PM
  5. Replies: 1
    Last Post: 05-15-2013, 06:55 AM
  6. Replies: 1
    Last Post: 06-15-2012, 03:57 AM
  7. Sort data table legend in reverse order of vertical axis
    By Robertjb1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-01-2011, 11:13 AM

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