How-to change perspective in an Excel chart

Oh my, I had no idea you could do this with an Excel chart! What am I raving about? You can reverse the order of the axis values. You have to see this in action to appreciate it. First, look at a simple column graph that compares sales for the past four years: 2003 through 2006. The picture's rather dismal—sales are going down.


Now, look again. The second graph displays the same information but conveys an entirely different message. In fact, it's so different that you might find it deceptive!


All I did was reverse the order of the axis values as follows:

  1. Right-click the horizontal axis values.
  2. Choose Format Axis from the resulting context menu.
  3. Click the Scale tab.
  4. Check (or uncheck) the Categories in Reverse Order option.

I'm not suggesting that you use this feature to fool anyone. Rather, it's a warning. You might have a good reason for reversing the order, but be careful. If the readers aren't paying attention, they could easily misinterpret the chart. On the other hand, let it be a warning to you to review graphs carefully, especially if you didn't prepare them. What looks good might not be so great!


Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks

Free Newsletters, In your Inbox