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