X Axis Sort Order

I used the wizard to create a bar chart. The x axis data
reversed its order. The items and order I wanted are
Inv,AR,Int Assets and Other Assets for 03vs 02 comparison.
When I used the chart wizard the chart order was Other
Assets, Int Assets, AR, Inv. Besides actually moving my
data in a reverse order is there a way to fix this? I saw
that I could change the 02 03 sort order but not the x
axis.

Thank you,
Jason

-----Original Message-----
I used the wizard to create a bar chart. The x axis data
reversed its order. The items and order I wanted are
Inv,AR,Int Assets and Other Assets for 03vs 02
comparison.
When I used the chart wizard the chart order was Other
Assets, Int Assets, AR, Inv. Besides actually moving my
data in a reverse order is there a way to fix this? I
saw
that I could change the 02 03 sort order but not the x
axis.

Thank you,
Jason
.




The only way I know of is to reverse your data. Which
isn't that hard. Just use the Sort command.

Hi Jason,

Try selecting the axis and check the two format properties,
Categories in reverse order
Crosses at maximum value

Jason wrote:

I used the wizard to create a bar chart. The x axis data
reversed its order. The items and order I wanted are
Inv,AR,Int Assets and Other Assets for 03vs 02 comparison.
When I used the chart wizard the chart order was Other
Assets, Int Assets, AR, Inv. Besides actually moving my
data in a reverse order is there a way to fix this? I saw
that I could change the 02 03 sort order but not the x
axis.

Thank you,
Jason

--

Cheers
Andy

http://www.andypope.info