Reverse chart column and row order
 

I'm running Office 2007 and all my charts are showing up in reverse
order:

I want a bar graph that looks like this:

Series 1 --------------------------------Column 1
Series 1 -------------------------Column 2
Series 1 -------------------------------------Column 3

Series 2 --------------------------------------Column 1
Series 2------------------Column 2
Series 2--------------------------Column 3

What I'm getting is:

Series 2--------------------------Column 3
Series 2------------------Column 2
Series 2----------------------Column 1

D3M -------------------------------------Column 3
D3M -------------------------Column 2
D3M --------------------------------Column 1

All column and row headers are set to General, but I've tried setting
them to text as well. I need to have the columns in a certain order
for reporting.

I can only switch one column so the other still ends up out of order.
Ideally, I would just be able to click the button like Office 2007
says you're supposed to be able to and it would work.

Is there a setting somewhere that needs to be changed or has anyone
else experienced this problem?

Reverse chart column and row order
 

Your description of what you've tried is rather confusing, but what if you
right click on the axis and choose Format Axis. Then on the Axis Options
tab, check the box for Categories in Reverse Order and select the Maximum
for Vertical Axis Crosses.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Divinite" wrote in message
oups.com...
I'm running Office 2007 and all my charts are showing up in reverse
order:

I want a bar graph that looks like this:

Series 1 --------------------------------Column 1
Series 1 -------------------------Column 2
Series 1 -------------------------------------Column 3

Series 2 --------------------------------------Column 1
Series 2------------------Column 2
Series 2--------------------------Column 3

What I'm getting is:

Series 2--------------------------Column 3
Series 2------------------Column 2
Series 2----------------------Column 1

D3M -------------------------------------Column 3
D3M -------------------------Column 2
D3M --------------------------------Column 1

All column and row headers are set to General, but I've tried setting
them to text as well. I need to have the columns in a certain order
for reporting.

I can only switch one column so the other still ends up out of order.
Ideally, I would just be able to click the button like Office 2007
says you're supposed to be able to and it would work.

Is there a setting somewhere that needs to be changed or has anyone
else experienced this problem?