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:


image

Before

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.

image

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.

image

image

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.

image


image

After

Summary:

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.

~Sam.

About these ads

4 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.

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