Vertical stacked bar charts in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3404433%22%20slang%3D%22en-US%22%3EVertical%20stacked%20bar%20charts%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3404433%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Alan_Fleming111265_0-1653033695153.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F373547iBF452EF4D43A8CB4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Alan_Fleming111265_0-1653033695153.png%22%20alt%3D%22Alan_Fleming111265_0-1653033695153.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHi.%20I've%20created%20this%20chart%20in%20Excel%20and%20want%20to%20make%20the%20entries%20in%20the%20legend%20appear%20in%20the%20same%20order%20top%20to%20bottom%20as%20they%20are%20in%20the%20chart%20(the%20legend%20reads%20A%20to%20D%20from%20the%20top%20but%20the%20bars%20read%20A%20to%20D%20from%20the%20bottom).%20I%20tried%20the%20following%3A%3C%2FP%3E%3COL%3E%3CLI%3ERight-click%20on%20one%20of%20the%20names%20listed%20on%20your%20legend.%3C%2FLI%3E%3CLI%3EClick%20on%20the%20%22Select%20Data%22%20option%20from%20the%20list%20that%20appears.%3C%2FLI%3E%3CLI%3EClick%20on%20the%20entry%20you%20want%20to%20move%20in%20the%20%22Legend%20Entries%20(Series)%22%20box.%3C%2FLI%3E%3CLI%3EClick%20the%20%22Up%22%20or%20%22Down%22%20arrows%20in%20the%20box%20to%20change%20the%20position%20of%20the%20legend.%20Click%20%E2%80%9COK%E2%80%9D%20when%20finished%20to%20save%20your%20changes.%3C%2FLI%3E%3C%2FOL%3E%3CP%3EHowever%2C%20while%20this%26nbsp%3Breverses%20the%20order%20of%20the%20legend%20entries%20it%20also%20reverses%20the%20order%20in%20which%20they%20appear%20in%20the%20chart%2C%20leading%20to%20the%20exact%20same%20issue%20remaining%20as%20per%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Alan_Fleming111265_1-1653033991142.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F373551iD21EC7A4B427E8FA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Alan_Fleming111265_1-1653033991142.png%22%20alt%3D%22Alan_Fleming111265_1-1653033991142.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAnyone%20know%20how%20to%20resolve%20this%20problem%3F%20It%20would%20even%20be%20helpful%20to%20be%20told%20that%20Excel%20can't%20do%20this%20at%20all%20(the%20problem%20doesn't%20seem%20to%20occur%20with%20horizontal%20bar%20charts).%20Many%20thanks.%20Alan%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3404433%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3404592%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20stacked%20bar%20charts%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3404592%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1395618%22%20target%3D%22_blank%22%3E%40Alan_Fleming111265%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EWhat%20happens%20if%20you%20create%20the%20chart%20again%20from%20scratch%3F%20When%20I%20tried%20to%20reproduce%20your%20problem%2C%20the%20legend%20was%20in%20the%20correct%20order%20by%20default.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S1447.png%22%20style%3D%22width%3A%20481px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F373565i8A09B460FE3CA1D2%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S1447.png%22%20alt%3D%22S1447.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3404755%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20stacked%20bar%20charts%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3404755%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3BI%20actually%20DID%20create%20it%20from%20scratch%20just%20before%20creating%20the%20post.%20It%20was%20actually%20one%20at%20my%20workplace%20that%20I%20was%20working%20on%20and%20having%20this%20problem%20with%20so%20I%20created%20the%20new%20chart%20on%20my%20home%20laptop%20but%20it%20seemed%20to%20have%20the%20same%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3404765%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20stacked%20bar%20charts%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3404765%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1395618%22%20target%3D%22_blank%22%3E%40Alan_Fleming111265%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20afraid%20I%20can't%20explain%20that.%20Sorry!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3404914%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20stacked%20bar%20charts%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3404914%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3Bthanks%20anyway!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Alan_Fleming111265_0-1653033695153.png

Hi. I've created this chart in Excel and want to make the entries in the legend appear in the same order top to bottom as they are in the chart (the legend reads A to D from the top but the bars read A to D from the bottom). I tried the following:

  1. Right-click on one of the names listed on your legend.
  2. Click on the "Select Data" option from the list that appears.
  3. Click on the entry you want to move in the "Legend Entries (Series)" box.
  4. Click the "Up" or "Down" arrows in the box to change the position of the legend. Click “OK” when finished to save your changes.

However, while this reverses the order of the legend entries it also reverses the order in which they appear in the chart, leading to the exact same issue remaining as per this:

Alan_Fleming111265_1-1653033991142.png

Anyone know how to resolve this problem? It would even be helpful to be told that Excel can't do this at all (the problem doesn't seem to occur with horizontal bar charts). Many thanks. Alan

 

4 Replies

@Alan_Fleming111265

What happens if you create the chart again from scratch? When I tried to reproduce your problem, the legend was in the correct order by default.

S1447.png

@Hans Vogelaar I actually DID create it from scratch just before creating the post. It was actually one at my workplace that I was working on and having this problem with so I created the new chart on my home laptop but it seemed to have the same problem.

@Alan_Fleming111265 

I'm afraid I can't explain that. Sorry!

@Hans Vogelaar thanks anyway!