SOLVED

Sorting 'Row Labels' by month

%3CLINGO-SUB%20id%3D%22lingo-sub-2618926%22%20slang%3D%22en-US%22%3ESorting%20'Row%20Labels'%20by%20month%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2618926%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Experts%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Excel%20for%20Mac.%20In%20attached%20chart%2C%20you%20can%20see%20months%20are%20not%20in%20order.%26nbsp%3BIf%20I%20have%20this%20chart%20in%20Windows%20OS%2C%20I%20can%20simply%20right-click%20a%20bar%20and%20move%20to%20end.%20But%20in%20Excel%20for%20Mac%2C%20I%20don't%20have%20this%20option.%20Kindly%20help%20with%20inputs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sharath79_1-1628241854543.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F301047iE098B0D65D549360%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Sharath79_1-1628241854543.png%22%20alt%3D%22Sharath79_1-1628241854543.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3ESharath%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2618926%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2619093%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20'Row%20Labels'%20by%20month%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2619093%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1122049%22%20target%3D%22_blank%22%3E%40Sharath79%3C%2FA%3E%26nbsp%3BYou%20haven't%20attached%20the%20chart%2C%20just%20a%20picture%20of%20it.%20Axis%20labels%20are%20presented%20in%20the%20same%20order%20as%20in%20the%20underlying%20data%20table.%20If%20you%20make%20sure%20that%20the%20months'%20labels%20are%20based%20on%20real%20dates%20(custom%20formatted%20as%20mmm'yy)%20you%20can%20sort%20the%20table%20and%20the%20chart%20will%20follow.%20Example%20attached.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-08-06%20at%2011.52.26.png%22%20style%3D%22width%3A%20481px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F301049i086F56182463BBBD%2Fimage-dimensions%2F481x214%3Fv%3Dv2%22%20width%3D%22481%22%20height%3D%22214%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-08-06%20at%2011.52.26.png%22%20alt%3D%22Screenshot%202021-08-06%20at%2011.52.26.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E(Created%20on%20a%20Mac)%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2619114%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20'Row%20Labels'%20by%20month%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2619114%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B-%20Thanks%20a%20lot%20for%20your%20response.%3C%2FP%3E%3CP%3EMy%20chart%20is%20as%20below%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sharath79_0-1628244018185.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F301050i40D1E4D3378BB3E9%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Sharath79_0-1628244018185.png%22%20alt%3D%22Sharath79_0-1628244018185.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20sort%20the%20months%20under%20'Row%20Labels%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3ESharath%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

 

 

Sharath79_1-1628241854543.png

 

Regards

Sharath

4 Replies
best response confirmed by Sharath79 (New Contributor)
Solution

@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.

Screenshot 2021-08-06 at 11.52.26.png

(Created on a Mac)

@Riny_van_Eekelen - Thanks a lot for your response.

My chart is as below:

Sharath79_0-1628244018185.png

 

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.

 

Thanks so much @Riny_van_Eekelen .

The source code had dates correctly organised as you suggested. But still I had this issue. I found a workaround to fix this. Please see screenshot below. I had to move these months manually and then chart reflected as I wanted. Thanks again for your inputs regarding this issue.

 

Sharath79_0-1628251506361.png

 

Regards

Sharath