SSRS and Microsoft Chart Control How To: Change the Width of Bars and Columns

Every once and I while I get asked this question, and it fits nicely with a series I've been planning to blog on what you can do with custom attributes in charts in SQL Server Reporting Services 2008.  The question is, "How do I change the width of the bars and columns on the charts?". 

To change the width of bars or columns on a chart, you need to access the custom attributes for the charts.  In Report Builder 2.0, you do this by going to the ribbon under the View area and check the "Properties" checkbox.  This will enable the property grid that people who use the BI Development Studio are familiar with.  Next, select the series you are interested in on the chart, either via the chart flange or by selecting the bar or column on the chart.  Look over to the property grid and look for a section called "General".  Under the "General" heading there is an area for custom attributes. Expand the custom attributes node and you will see the following.

customatt

 

Right there under custom attributes you can change the relative size of the point widths.  Anything less than 1 will create space between the bars and columns.  Anything greater than 1 will cause the bars or columns to overlap.

Custom attributes also work on the ASP.Net and Winforms chart that we just released.

Here's a code snippet that'll do the same thing if you are using the stand-alone controls.

VB ' Set the Series PointWidth. Chart1.Series(0)("PointWidth") = "1.2"

C#

// Set the Series PointWidth.

Chart1.Series[0]["PointWidth"] = "1.2";

I'll be posting more on custom attributes very soon.