View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Divinite Divinite is offline
external usenet poster
 
Posts: 4
Default Reverse chart 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?