Search

Advertisements

SSRS - In Bar Charts , how to adjust the size of the bars

In this post , I will shown an example on how to adjust the size of the bars  in SSRS bar charts .

Below query is going to be my dataset


DECLARE @SalesbyMonth TABLE (Months VARCHAR(20),Sales INT,MonthNo INT)
INSERT @SalesbyMonth SELECT 'January',1000,1
INSERT @SalesbyMonth SELECT 'February',100,2
INSERT @SalesbyMonth SELECT 'March',100,3
INSERT @SalesbyMonth SELECT 'April',200,4
INSERT @SalesbyMonth SELECT 'May',500,5
INSERT @SalesbyMonth SELECT 'June',800,6
INSERT @SalesbyMonth SELECT 'July',500,7
INSERT @SalesbyMonth SELECT 'August',100,8
INSERT @SalesbyMonth SELECT 'September',900,9
INSERT @SalesbyMonth SELECT 'October',600,110
INSERT @SalesbyMonth SELECT 'November',100,11
INSERT @SalesbyMonth SELECT 'December',100,12
SELECT * FROM @SalesbyMonth


Create Column chart with Sales as summation value and Months as Category Groups 

  Try like below (as shown in below image) 

 Click on any bars on the chart - > Press F4 - > Properties - > CustomAttributes - > PointWidth - > Change according to your requirement



Report Preview : 


 

1 comment:

Anonymous said...

Thank you for this helpful advice.

Advertisements