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.

Possible Duplicate:
Weird Excel bar diagram behaviour

I have a very simple question. I want to have a diagram with the following table:

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

The weird thing is, when I try to draw a bar diagram the order of the bars changes. So Excel first draws the bananas, then the pears, and finally the apple bar... Is there anyway to tell Excel 2003 to keep the original order?

Thank you very much

share|improve this question

marked as duplicate by Snark, quack quixote, Ivo Flipse Mar 14 '10 at 21:13

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

    
Exactly which type of bar chart: horizontal, vertical, stacked, etc.? –  sblair Mar 14 '10 at 16:24
1  
Duplicate of this: superuser.com/questions/119853/… where I answered it. –  Snark Mar 14 '10 at 20:31

1 Answer 1

For horizontal bar graph the order is: from the bottom to the top. If you want to change it, select category (X) axis > Properties > Scale and check "categories in reversed order".

share|improve this answer
    
Thanks for that, it works but the problem is that also the axis label moves to the top which looks a bit odd... Is there any possibility to just change the order and leave the label where it belongs to? Thanks! –  Simon Mar 14 '10 at 19:41
    
All the times I have the same need I solve by adding dummy data series (with only title and no data), ordering the series so that they are according to my wishes and then removing the unwanted labels from the legend. –  Toc Mar 15 '10 at 8:30