Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a very simple question. I wanna have a diagram with the following table

Apple   30  40  50
Pears   200 300 400
Bananas 10  20  30

The weird thing, when I try to draw a bar diagram the order of the bars change. So Excel draws me first the Bananas, the the pears and finally the apple bar... Is there anyway to tell Excel 2003 that it keeps the order?

Thank you very much

share|improve this question

migrated from Mar 14 '10 at 19:54

This question came from our site for professional and enthusiast programmers.

Click on the vertical axis to select it. Right-click on it and select "Format Axis...".

In the "Axis Options", check the "Categories in reverse order".

alt text

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.