L
Legacy 68403
Guest
Does anyone know how to change the order of the x-axis labels in a chart. I have a chart that has good, neutral, poor, very good. I'm wanting to change the order to poor, neutral, good, very good.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VicRauch
Well-known Member
- Joined
- Mar 23, 2006
- Messages
- 2,032
You use a field for ordering other than the field that will be displayed. By adding a SortBy field to the table that contains your codes (Poor, Neutral, Good, Very Good) then add this SortBy field to the Row Source query for the Chart object. By not specifying anything for the Crosstab row in the query grid, but specifying Ascending within the Sort row of the query grid, your data will be sorted in the order you want.
HTH,
HTH,
Upvote
0
Similar threads
