Answered by:

How To Remove Space Between Bars in Column Chart

Question

I have a column chart and I'm displaying some data in that chart. Now i have a problem when displaying that whenever the data is not there for some "Data Fields" then it is showing blank. For example in the below chart if the data for Delayed is
not available means then it is showing blank. Now I want to adjust that space dynamically. Is it possible?

In Reporting Services, if the chart type is a linear chart type (bar, column, scatter, line, area, range), null values are shown on the chart as empty spaces or gaps between data points in a series. If we only have Category Groups, we can add a filter by
using the “is nothing” clause in the expression to remove empty values from the dataset. However, once we add Series Groups under the Category Groups, for each instance value of the category group, the series bar reserves the area for each value of the series
group, the area will be filled with white space if there is no data for specific values of the series group. So in your scenario, we cannot remove the space between columns in column chart. This is by design.

In Reporting Services, if the chart type is a linear chart type (bar, column, scatter, line, area, range), null values are shown on the chart as empty spaces or gaps between data points in a series. If we only have Category Groups, we can add a filter by
using the “is nothing” clause in the expression to remove empty values from the dataset. However, once we add Series Groups under the Category Groups, for each instance value of the category group, the series bar reserves the area for each value of the series
group, the area will be filled with white space if there is no data for specific values of the series group. So in your scenario, we cannot remove the space between columns in column chart. This is by design.