Wednesday, March 21, 2012

How change the scale of x Axis?

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