Excel – Bars In Excel Take Up More Space Than Axis

chartsmicrosoft excelmicrosoft word

I have this graph sent to me in Excel, which I have moved into Word:

enter image description here

As you can see, the bars of the graph take up more space than the axis, and the bars at both ends have been cut off. Compared to other graphs I've seen, the midpoints for each bar are right on the corners of the axis, rather than a distance away from the axis.

What I want is something like the graph below, where the bars are not being shoved to the side.

enter image description here

How do I accomplish this?

Best Answer

You need to change the formatting on your horizontal axis:

  1. On your Ribbon's Format Tab, choose Horizontal Axis, then click Format Selection.
  2. In the Format Axis Dialog Box, in Axis Options, change the Position Axis option to Between Tick Marks.