MrExcel Publishing
Your One Stop for Excel Tips & Solutions

X-Axis Categories

Posted by EJ on January 03, 2001 1:21 PM

I'm creating a report for a new account in my company that has a scoring scale of 1 to 5. On this scale, 1 is a perfect while 5 is horrible. All the other contractual scales are the exact opposite. The report should show that as we progess upward (on the graph) the contract is doing better. However, when I go to, "Format Axis" I select "categories in reverse order" it moves the x-axis categories to the top of the graph. I have made sure that I was only formatting the y-axis. How can I resolve this issue? I want the x-axis to stay where it is.

Please help,

Posted by Tim Francis-Wright on January 03, 2001 1:51 PM

I think that all you need to do is to check
Category (X) axis crosses at maximum value--
unless you do this, Excel tries to keep the
X axis crossing at the lowest Y value. (Just
keep saying, "It's a feature, not a bug!")

Hope this helps.