Setting SSRS Chart Axis Interval Behaviour to Prevent Skipping every 2nd

By default, the Interval Auto setting for the Reporting Services chart axis can cause the labels of your X axis to show only every 2nd interval.

Setting the Interval property for the Chart axis to 1 will prevent this behaviour.    Select the X Axis on your chart, search the properties window for the Interval property and set this to 1 (will be Auto by default). This article illustrates how to set the interval and provides some basic examples of before and after

Show All Intervals.

You may find it useful to additionally set the Label and Label font properties for the axis.   Setting the label font to 6 pt, then disabling autofit and setting a rotation of -30degrees, will ensure you have a better chance of squeezing in longer interval names.

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s