Add or Remove Margins from a Chart (Report Builder and SSRS)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
In Column and Scatter chart types, the chart automatically adds side margins on the ends of the x-axis. In Bar chart types, the chart automatically adds side margins on the ends of the y-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.
You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.
To enable or disable side margins
Right-click the axis and select Axis Properties. The Vertical or Horizontal Axis Properties dialog box appears.
On the Axis Options page, set the Side margins property:
Auto The chart will determine whether to add a side margin based on the chart type.
Disabled Bar, column, and scatter charts will have no side margins.