Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    XL Order of Table & Graph Changing? (XP)

    Hello,

    Pls. see attached XL file with embedded Questions

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: XL Order of Table & Graph Changing? (XP)

    1/ Reverse order in which M&S etc are displayed.

    Once the chart has been created right click on one of the names and select "Format Axis"
    On the Scale tab select "Catagories in reverse order"
    Though the chart wizard has many options AFAIK this is not one of them.

    2/ Change order in which melons etc are displayed

    Right click on one of the bars and select "Format Data Series..."
    On the "Series order" tab you have the options to put the series in any order you like.

    Side question. Personally I do not mind if the full question is in the attachment or the main window. The main window should give an indication as to what the question is about, if not the full details. Somebody else may well give a different answer to this, it's a matter of personal choice.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: XL Order of Table & Graph Changing? (XP)

    1. The categories or values on a chart axis start at the origin (where the axes intersect) by default, so the order in your chart is not reversed, it is the normal one. This order is a property of the axis, so if you want to change it, double click the vertical axis to display the Format Axis dialog. In the Scale tab, there is a check box "Categories in reverse order".

    2. The order in which the series are displayed is a property of the series. If you want to change it, double click one of the series in the chart to display the Format Data Series dialog. In the Series Order tab, you can select a series and use the Move Up and Move Down buttons.

    There is no very easy way to reverse the order of the rows in a table, or of the columns. You would need a macro for that.

    About your side question: it would probably be easier for others reading the threads if you put the questions in the post itself, but it is not terribly important.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: XL Order of Table & Graph Changing? (XP)

    I prefer the questions in the post rather than the attachment:
    1) it allows seeing something about the question without having to open another program
    2) it allows the question to be better "searchable" later. Questions and keywords in the attachment, will not be found when you use the WOPR search engine.

    Steve

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XL Order of Table & Graph Changing? (XP)

    As one who answers a lot of questions, I prefer that the question is in the message. That way, if the question is about something that I would not be able to answer, I don't have to waste time downloading the file and opening Excel or some other application, It gives me more time to spend on questions that I can answer.
    Legare Coleman

  6. #6
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XL Order of Table & Graph Changing? (XP)

    Thanks for all your replies.

    I will put future Q's in the post & not the attachment as it seems most of you prefer.

    Also as Steve highlighted, it allows the words to be indexed & Searched on for later reference.

    Best regards,

    Bob Duncan

Posting Permissions

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