If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
X Axis Sort Order
-----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. |
#3
|
|||
|
|||
X Axis Sort Order
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 |
Thread Tools | |
Display Modes | |
|
|