Solved

How do I Change Labels on a Chart Axis to Show Individual Months Only

Posted on 2013-05-14
7
2,465 Views
Last Modified: 2013-05-20
I have created a series of charts in Report Builder 3.0 showing disk space usage over time.  The charts have the date along the x axis and at the moment the labels are showing every second day with the month and year.  These charts are potentially infinitely expandable so I'd like to have one label per month just showing the discrete month and year if possible. Can anybody help please?
0
Comment
Question by:BWFC
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 49

Accepted Solution

by:
PortletPaul earned 500 total points
ID: 39167234
may I suggest this url?
http://msdn.microsoft.com/en-us/library/dd239363(v=sql.105).aspx

You seem to have default major intervals (with labels on each) so you need to look at the major/minor tick mark intervals and then label only the major ones

at least that what I think you are after.
0
 

Author Closing Comment

by:BWFC
ID: 39180763
I'd already looked at altering the major and minor tick marks and I'd found that URL using Google.

I'm not sure I explained what I wanted to do particularly clearly because  after chatting with the rest of the BI team and further Google searches I don't think want I want to do is actually possible with the data I have.

Thanks for your help.
0
 
LVL 49

Expert Comment

by:PortletPaul
ID: 39180816
Thank you for the points, although seems undeserved.

Most graphic packages have their own "tricks", and a date range on the X axis can be "tricky" - however it will boil down to the tick marks in some way shape or form.

How to: Format Axis Labels as Dates or Currencies (Report Builder 3.0 and SSRS)
When you show properly formatted DateTime values on an axis, a chart will automatically display these values as days. To specify a date/time interval for the x-axis, such as an interval of months or an interval of hours, you must format the axis labels and set the type of axis interval to a valid date or time interval.
I think the secret is within the one immediately above, which is confirmed by the next reference.

How to: Specify an Axis Interval (Report Builder 3.0 and SSRS)
This topic is not applicable for date or time values on the category axis. Be default, DateTime values appear as days. To specify a different date or time interval, such as a month or time interval, you must format the axis labels and set the axis to display instances of DateTime types instead of String types. In addition, you must set the Interval property. For more information, see How to: Format Axis Labels as Dates or Currencies (Report Builder 3.0 and SSRS).
{+ edit for emphasis on "interval"}
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:BWFC
ID: 39180888
Screenshot of property settings Screenshot of property settings
Hi, I think I've got all the settings set to show months but it's still not giving me the single label per month.  The Number format I'm using is *January 2000.  Are the settings on the screenshots correct?  The expression on minimum axis range makes no difference whether it is there or not.
0
 
LVL 49

Expert Comment

by:PortletPaul
ID: 39180930
You have not "set" the interval, but allowed "auto" (in both)

You will only know for sure by "playing" with these, but I think you need to actually specify the interval (in both most likely) - can you try it?
0
 

Author Comment

by:BWFC
ID: 39180964
I've just had that realisation myself!  A lot of the internet searches came back saying "the Interval will show this" so I thought when I could only see 'Auto' as an option it was something to do with my version of Report Builder or my data (I'm very new to SQL and BI) .  I think I'm going to need something involving datediff and/or datepart to get the discrete months to show as labels.
0
 
LVL 49

Expert Comment

by:PortletPaul
ID: 39181159
maybe a new question - with your existing query? and a mock-up of your expected outcome?
a fresh start might help
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question