Is there a reason why these bars wont line up in my excel chart

Question

That's why I'm having issues. To this bar graph, I've added two extra bars. In the second image, the blue one fits in perfectly with the others. The bar simply lands in front of the other bars when I add the bronze column, though. I have no idea how to repair this. Any guidance is appreciated.

Answer 1

STEPS

1. Hover your mouse over any of the bars in the chart and right click to display the context menu with the following set of options: 
2. Now select the option right at the bottom - i.e. "Format Data Series..."
3. This should open the relevant side pane menu bar - vide-licit : 
4. Vary the Series Overlap and Gap Width options to resolve - voila! ☺