How to: Add or Remove Margins from a Chart
In Bar, Column and Scatter chart types, the chart automatically adds side margins on the ends of the x-axis. In all other chart types, the chart does not add side margins. You cannot change the size of the margin.
This topic does not apply to pie, doughnut, funnel or pyramid chart types.
To enable or disable side margins
Right-click the axis and select Axis Properties. The Axis Properties dialog box appears.
On the Axis Options page, set the Side margins property. When this property has a value of Default, the chart will determine whether to add a side margin based on the chart type.