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 !!
Categories: Reporting Services
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!
Thanks! I had also been trying to figure this out
Thanks! This saved me much time!
Great article! Saved my day!
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
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