Forum Discussion
Sorting 'Row Labels' by month
Dear Experts,
I am using Excel for Mac. In attached chart, you can see months are not in order. If I have this chart in Windows OS, I can simply right-click a bar and move to end. But in Excel for Mac, I don't have this option. Kindly help with inputs.
Regards
Sharath
Sharath79 You haven't attached the chart, just a picture of it. Axis labels are presented in the same order as in the underlying data table. If you make sure that the months' labels are based on real dates (custom formatted as mmm'yy) you can sort the table and the chart will follow. Example attached.
(Created on a Mac)
4 Replies
Sharath79 You haven't attached the chart, just a picture of it. Axis labels are presented in the same order as in the underlying data table. If you make sure that the months' labels are based on real dates (custom formatted as mmm'yy) you can sort the table and the chart will follow. Example attached.
(Created on a Mac)
Riny_van_Eekelen - Thanks a lot for your response.
My chart is as below:
How do I sort the months under 'Row Labels?
Regards
Sharath
Sharath79 So you have a pivot chart. Given the fact that the pivot table did not sort the "months" correctly, tells me that these are texts and Excel sorted them alphabetically. If you want the pivot table to sort months correctly, you need to make sure that the underlying data (the source data) contains real dates.
Dates in Excel are, in fact, sequential numbers and you can format them in many ways to make them look like dates like dates we all recognise like "January 15, 2021", 15 jan 21", "2021/01/15" or "Jan'21", just to give a few examples.
