Bars In Excel Take Up More Space Than Axis
8,247
You need to change the formatting on your horizontal axis:
- On your Ribbon's Format Tab, choose Horizontal Axis, then click Format Selection.
- In the Format Axis Dialog Box, in Axis Options, change the Position Axis option to Between Tick Marks.
Related videos on Youtube
08 : 56
3 EASY Ways to Find and Remove Duplicates in Excel
06 : 17
How-to Stop Excel Charts from Overlapping Second Axis Columns or Bars
04 : 05
How To Add Error Bars In Excel (Custom Error Bars)
00 : 55
How to change the order of the bars in your stack bar chart
04 : 34
Skip Dates in Excel Charts (ignore gaps in Excel horizontal chart axis)
09 : 53
Create Chart with Broken Axis and Bars for Scale Difference - Simple Method
01 : 48
How to Make Chart Bars Wider in Excel | Changing Column Width in Chart in Excel
01 : 50
Bars In Excel Take Up More Space Than Axis
Author by
Admin
Updated on September 18, 2022Comments
-
Admin over 1 year
I have this graph sent to me in Excel, which I have moved into Word:
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.
How do I accomplish this?