Hi, how do I change the scale of x axis to a larger time scale than the data ?
Data is in quarters and I want that to be displayed in a line graph, but I want the labels to show hours
(it becomes messy otherwise when showing several days)
Thank You,
Regards
G?ran
You may want to take a look at the chart label section of the following article: http://msdn2.microsoft.com/en-us/library/aa964128.aspx#moressrscharts_topic3
-- Robert
|||Thanks, a useful article.
Guess I figured it out myself, I grouped on this to avoid quarter labels:
SELECT DATEPART(DAY,QuarterDate) as DayGroup, DATEPART(HOUR,QuarterDate) as HourGroup
No comments:
Post a Comment