Data Labels, Axis Interval, Rotate Label Text: SSRS Nugget

Charts present summary data in a visually appealing format. Following is a chart for sales over month:



I frequently use a few options along with charts to get most out of them.

Show data labels:

It’ll be easier for the users to quickly read, if the chart shows the actual numbers along with bars. Steps: From the chart data pane, click data value, and choose Show Data Labels.


Display all categories on horizontal axis:

Notice in the above chart, all the categories (Months in our example) are not displayed. By default, auto fit property determines the interval of horizontal axis labels. Changing the interval to 1 will force the axis to display all categories. Steps are depicted in the below screen prints.



Rotate Labels:

Sometimes you may notice the labels are rotated automatically to better fit them, other times labels overlap with each other. Labels can be forced to rotate by disabling auto-fit and changing the label rotation angle to 90 degrees.





In this post, I’ve looked at simple properties that can extend chart’s functionality: Showing data labels, configuring axis interval, and rotating axis labels.



9 thoughts on “Data Labels, Axis Interval, Rotate Label Text: SSRS Nugget

  1. Sam,

    Do you know how to rotate the data label when you position it on top of the bar graph? I’d like to rotate them at 45 degree angle so that the data doesn’t overlap the adjacent bar. Thanks. Dave

    • Hi Dave – Did you try the rotation property for labels. Select data labels on the chart –> browse to rotation property in the properties window –> default is 0, change it to 45. Click Yes when you are prompted to turn on smart data labels.

      Hope this helps.

  2. May I ask what version of SSRS the above example is demonstrating? I don’t see those options in my version.

  3. Hi ,
    I want to create line chart that show the week start date and data is classified by datetime , How can I do this , please provide any suggestion .

    Thank You

  4. Is there any way to change date in x-axis to weekdays, I also want to highlight saturday and sunday in axis label.

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s