SSRS: Define custom X axis position on bar chart

2
votes

I have two separate bar charts but I want both to have the same X axis position. That is, I need both horizontal axis to be at the same height.

Both charts have the same height, using the properties:

  • Chart > Position > Size > Height = equal on both
  • Chart Area > Position > Custom Position > Height = 100

axis position (See the blue arrow)

Software: SSRS 2008R2 (Microsoft Reporting Services)

Thanks in advance.

1
reporting-serviceschartsssrs-2008bar-chart

1 Answers

2
votes

You can work with this by using the Chart Area -> CustomInnerPlotPosition and CustomPosition values.

I have replicated your issue with a couple of side by side charts. In Design:

enter image description here

And preview:

enter image description here

You can see these don't line up, just like yours.

However, if I set the CustomInnerPlotPosition values for Height and Top to be the same for both Charts' Chart Areas, now the bars match in location and height:

enter image description here

enter image description here

You will need to tweak the values for your specific setup.

Doug Lane's excellent article Fit Chart Labels Perfectly in Reporting Services has much more information on these properties.