up vote 1 down vote favorite
share [g+] share [fb]

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

link|improve this 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
feedback

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

This question covers exactly the same ground as earlier questions on this topic; its answers may be merged with another identical question. See the FAQ for guidance on how to improve it.

1 Answer

up vote 1 down vote

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".

link|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
feedback