Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 stackoverflow.com Mar 14 '10 at 19:54

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

add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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