Organizing stacked categories of second horizontal axis label in bar chart from least to greatest

%3CLINGO-SUB%20id%3D%22lingo-sub-1298530%22%20slang%3D%22en-US%22%3EOrganizing%20stacked%20categories%20of%20second%20horizontal%20axis%20label%20in%20bar%20chart%20from%20least%20to%20greatest%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1298530%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20your%20day%20is%20going%20well.%20I%20have%20created%20a%20stacked%20column%20chart%20in%20excel%20for%20two%20data%20sets%20(i.e.%2C%20inoculum%20and%20endogenous%20decay)%20in%20the%20attached%20document.%20As%20you%20will%20notice%2C%20the%20categories%20(represented%20by%20different%20colors)%20for%20the%20inoculum%20have%20been%20organized%20from%20least%20to%20greatest.%20I%20would%20like%20to%20do%20the%20same%20with%20the%20second%20dataset%20and%20am%20seeking%20guidance%20with%20doing%20so.%20I%20have%20tried%20created%20separate%20graphs%20for%20both%20datasets%20and%20then%20copying%20and%20pasting%20one%20of%20the%20charts%20into%20the%20other.%20However%2C%20this%20has%20resulted%20in%20a%20single%20horizontal%20axis%20containing%20both%20datasets%20(see%20the%20second%20attached%20figure).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20your%20help.%20Have%20a%20wonderful%20and%20productive%20day!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESincerely.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1298530%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%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1299103%22%20slang%3D%22en-US%22%3ERe%3A%20Organizing%20stacked%20categories%20of%20second%20horizontal%20axis%20label%20in%20bar%20chart%20from%20least%20to%20greates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1299103%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F617273%22%20target%3D%22_blank%22%3E%40Erica_Dasi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChart%20shows%20data%20in%20the%20same%20order%20as%20it%20is%20in%20the%20source.%20The%20workaround%20is%20described%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.quora.com%2FHow-do-I-get-a-bar-graph-on-Excel-to-sort-from-highest-to-lowest%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.quora.com%2FHow-do-I-get-a-bar-graph-on-Excel-to-sort-from-highest-to-lowest%3C%2FA%3E%20or%20you%20may%20use%20SORT()%20if%20it%20is%20available%20for%20your%20version%20of%20EXCEL%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello, 

 

Hope your day is going well. I have created a stacked column chart in excel for two data sets (i.e., inoculum and endogenous decay) in the attached document. As you will notice, the categories (represented by different colors) for the inoculum have been organized from least to greatest. I would like to do the same with the second dataset and am seeking guidance with doing so. I have tried created separate graphs for both datasets and then copying and pasting one of the charts into the other. However, this has resulted in a single horizontal axis containing both datasets (see the second attached figure). 

 

Thank you in advance for your help. Have a wonderful and productive day!

 

Sincerely.

1 Reply
Highlighted

@Erica_Dasi 

Chart shows data in the same order as it is in the source. The workaround is described here https://www.quora.com/How-do-I-get-a-bar-graph-on-Excel-to-sort-from-highest-to-lowest or you may use SORT() if it is available for your version of EXCEL