CODEWITHSUNDEEP
reporting-servicesreportbuilder3.0
Paul Lor
Paul Lor

Reputation: 59

SSRS Report Builder - Align/Shift Stepped Line Chart with Bar Chart

in SSRS Report Builder is it possible to move the stepped line chart to align perfectly on top of the bar chart below? E.g. Shift a little left.

enter image description here

Upvotes: 0

Views: 784

Answers (1)

Jonnus
Jonnus

Reputation: 3038

I realise this is an old question but what you want to achieve can be possible.

I assume your values along the X axis are dates (and if not, they could be). All you need to do is offset the Stepped Line series to be 15 days less than the Stacked Column series.

This can be set using under Series Properties -> Series Data -> Category Field, and set the expression to be 

=dateadd("d", -15, Fields!Expiry_Date.Value)

Where Expiry_Date is the name of the field used for the X-axis (Or the Category Group in the Chart Data window).

This method will render a chart as shown, with the Stepped Line lined up with the Stacked Column

enter image description here

Upvotes: 1

Related Questions