Take the 2-minute tour ×

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.

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

Your Answer

