How to format the bar graphs in excel to make the columns line up next to one another

%3CLINGO-SUB%20id%3D%22lingo-sub-2779056%22%20slang%3D%22en-US%22%3EHow%20to%20format%20the%20bar%20graphs%20in%20excel%20to%20make%20the%20columns%20line%20up%20next%20to%20one%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2779056%22%20slang%3D%22en-US%22%3EI%20am%20currently%20having%20trouble%20with%20a%20bar%20graph%20and%20want%20to%20know%20how%20to%20make%20the%20columns%20stand%20directly%20next%20to%20each%20other%20from%20current%20year%20to%20last%20year.%20Any%20guidance%20on%20this%20would%20be%20much%20appreciated!%20Thank%20you!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2779056%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2779142%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20format%20the%20bar%20graphs%20in%20excel%20to%20make%20the%20columns%20line%20up%20next%20to%20one%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2779142%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1164748%22%20target%3D%22_blank%22%3E%40mavs2208%3C%2FA%3E%26nbsp%3Bclick%20on%20the%20data%20series%20and%20go%20to%20set%20properties%20and%20change%20the%20gap%20width%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mtarler_0-1632414082112.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F312451i43FEF3C5523BC468%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mtarler_0-1632414082112.png%22%20alt%3D%22mtarler_0-1632414082112.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
I am currently having trouble with a bar graph and want to know how to make the columns stand directly next to each other from current year to last year. Any guidance on this would be much appreciated! Thank you!
1 Reply

@mavs2208 click on the data series and go to set properties and change the gap width:

mtarler_0-1632414082112.png