How To Remove Space Between Bars in Column Chart

Question

Hello All,

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?

---

Gangadhar Pathi

Answer 1

Hi ,

Try these links ,

http://technet.microsoft.com/en-us/library/dd239390.aspx

http://msdn.microsoft.com/en-us/library/dd207051%28v=SQL.100%29.aspx

---

sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.

Answer 2

Hi Gangadhar,

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.

Thank you for your understanding.

Thanks,
Katherine Xiong

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
Thanks for helping make community forums a great place.

Answer 3

Thanks all for your replies..........

---

Gangadhar Pathi