Home

Sort questions by values (not how it was organized)

%3CLINGO-SUB%20id%3D%22lingo-sub-869473%22%20slang%3D%22en-US%22%3ESort%20questions%20by%20values%20(not%20how%20it%20was%20organized)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-869473%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20675px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133049i84C0A8EE09E72548%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202019-09-22%20at%204.37.00%20PM.png%22%20title%3D%22Screen%20Shot%202019-09-22%20at%204.37.00%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHow%20do%20I%20sort%20the%20questions%20(on%20the%20left%20side%20of%20the%20graph)%20to%20be%20in%20the%20order%20with%20the%20most%20agreement%20(i.e.%20question%201.4%2C%20question%201.6%2C%20question%201.3%2C%20question%201.1%2C%20question%201.5%2C%20question%201.7%20and%20question%201.2)%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-869473%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Egraph%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-873460%22%20slang%3D%22en-US%22%3ERe%3A%20Sort%20questions%20by%20values%20(not%20how%20it%20was%20organized)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873460%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F413299%22%20target%3D%22_blank%22%3E%40betsy2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Echange%20the%20order%20of%20the%20data%20in%20the%20chart%20source.%20Excel%20will%20plot%20the%20chart%20in%20the%20order%20of%20the%20data%20in%20the%20spreadsheet.%20If%20you%20want%20to%20change%20the%20plot%20order%2C%20you%20need%20to%20re-arrange%20the%20data%20in%20the%20grid.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
betsy2020
Occasional Visitor

Screen Shot 2019-09-22 at 4.37.00 PM.png

How do I sort the questions (on the left side of the graph) to be in the order with the most agreement (i.e. question 1.4, question 1.6, question 1.3, question 1.1, question 1.5, question 1.7 and question 1.2)? 

 

Thank you!

1 Reply
Highlighted

Hello @betsy2020 

 

change the order of the data in the chart source. Excel will plot the chart in the order of the data in the spreadsheet. If you want to change the plot order, you need to re-arrange the data in the grid. 

 

 

Related Conversations
Favorites Management
SmlBizAdmin in Discussions on
4 Replies
Pivot table
gabriellerocha in Excel on
5 Replies
Q&A examples
Dean Gross in Microsoft Search on
0 Replies
Sort Data Table
Tim Hunter in PowerApps & Flow on
2 Replies
Gain your competitive edge through ITFM
TiffanyRose in IT Transformation on
0 Replies
Gain your competitive edge with ITFM
TiffanyRose in IT Resources & Training on
0 Replies