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

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
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies