Weird Excel diagram behaviour

  • Thread starter Thread starter Marcus
  • Start date Start date
M

Marcus

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
 
Back
Top