Home > Reporting Services > Reporting Services 2008: Axis labels not displaying on chart

Reporting Services 2008: Axis labels not displaying on chart


The new charts introduced in Reporting Services 2008 are fantastic. There are lots of new features ( explore the property boxes to see the new little tweaks that you can make  ), and of course the guages are proving to be very popular. In case you haven’t heard already , the SQL 2008 R2 release of Reporting Services will include Dundas Maps ( I’m already playing with this and will blog on it soon !! ).
 
Anyway , a minor annoyance with the current charts is that when you create a simple bar chart , for example , you don’t see all the labels on the bottom axis. For example , I’ve created a bar chart plotting sales by month. Without changing any settings , the default result is the following :

Right , so as you can see , the labels on the bottom axis are missing a few months. To correct this , it’s actually quite simple .

  • Right click on the axis in Design View , and select "Axis Properties"
  • Change the "Interval" setting from "Auto" to 1.

That should do it. You’ll end up with the following result.

Also play with the other settings , like "Interval Type" , "Arrow Style" etc. These Dundas charts really do give you options !!

Advertisements
Categories: Reporting Services
  1. G3
    September 6, 2011 at 3:38 pm

    I have been struggling for a whole day and half until i stumbled on to your post, thanks so much mate, you saved my day!

  2. Patt
    August 16, 2012 at 5:56 pm

    Thanks! I had also been trying to figure this out

  3. Breno
    September 24, 2012 at 1:16 am

    Thanks! This saved me much time!

  4. RAcevedo
    February 19, 2013 at 6:08 am

    Great article! Saved my day!

  5. poshak
    March 17, 2013 at 5:26 pm

    Hi Thavas,
    How can I show the static X-axis interval Time (in hours) in a SSRS chart. The chart receives data in realtime.
    For example
    chart would have time range of 9AM to 8PM in the X-axis. So at 10AM the chart gets average of data collected every minute between 9-10AM so on and so forth. I am able to create 12 points on the X-axis but I dont see the label. How can I do that? Thanks

  6. Deepa
    March 19, 2013 at 10:28 pm

    I have a bar chart that is tilted meaning chart goes across and I want names of 3 items listed on the vertical axis and I am having making it work.Any help is appreciated

  1. No trackbacks yet.

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

%d bloggers like this: