Hi

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

This is not 'weird'; this is how Excel works
Right click, the category axis; open the Format Axis dialog and locate the
"Reverse Categories" box and check it
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Marcus" wrote in message
...


Hi

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