ssrs 2012 bar chart -bar spacing and horizontal axis labels

Question

User1652530521 posted

Hi,

How do I space the bars in the bar chart? I set PointWidth=0.5 but it doesn't space.

In addition how do I change the labels in the horizontal axis to display the name of the fields? My bar consists of 3 different fields.

Also, I don't want it to display the labels next to each bar and not like it does now with the strange lines and label under each other.

example of my bar chart

http://postimg.org/image/o1eg9trrj/c2ebb8f8/

Answer 1

User1644755831 posted

Hello whisky,

Please see: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/75de565d-8543-4c90-8e37-1a6570912fbe/increase-gap-between-bars-in-ssrs-2008-charts

Please see reply of Challen Fu .

"You can change the value of PointWidth Property to increase or decrease the interval relatively. However if your chart also has Series Group not just Values and Column Groups, the different series chars at one scale on X-Axis will still be side by side without interval after changing the PointWidth Property, to work around this issue, the following detailed steps are for your reference:

1. Right-click the whole chart, and then select the Series Properties.

2. Switch to Border tab, you can set the line attributes of the border on the left side.

3. Select "Default" in the Line style drop-down list and "White" in the Line color drop-down list,

4. Set the value of Line width to '1pt'or '1.5pt'...

5. Click OK, and preview the chart you will see 2*'1pt' or 2*'1.5pt' interval between the chars at the same scale on X-Axis"

As for label positions please see: Position Labels in a Chart (Report Builder and SSRS)

With Regards,

Krunal Parekh

Answer 2

User1652530521 posted

Thanks. To increase the gaps I added 2 dummy fields with value=0. The pointwidth didn't work for me.

The only problem I am still having is with the labels. 

Answer 3

User1644755831 posted

Hello Whisky,

The only problem I am still having is with the labels. 

Did you resolve this ? I think the link I provided above should help.

Answer 4

User1652530521 posted

Hi,

Tried the link.

Seems the problem is coz I have more than one category. The only way I managed to resolve it was using unpivot in sql. If I am wrong and it can be achieved in SSRS with multiple categories please correct me.