here is what I do - change the axes label to vertical(Under chart properties , Dimension axis, click the radio button corresponds to vertical line) and streach the length. and change the font for axis label.
I think he wants to say that just wants to see the information by quarter. I mean, for the corresponding to january, february and march, appears accumulated in january. The same for the rest of the months.
Aji, As i can see now it is quite opposite. Current version shows all months, and the requirement is to show only hte 1st month of the quarter - but the data points must be for all months.
See what I tried - and got some result. First step is to create an artificial dimension that has "normal" value for the 1st months of the quarter, and value that contains blanks, and character chr(10) at the start and the end, for all other months. To make each "month" unique, I used different number of blanks. Here is the script of the data, see Month1 field:
// Date ===================================== LET Start = num(makedate(2010,1,1)); LET End = floor(yearend(today()));
Date: LOAD $(Start)-1+RecNo() as Date AUTOGENERATE $(End) - $(Start) + 1; JOIN (Date) LOAD Date, date(MonthStart(Date), 'MMM-YY') as Month, year(Date) as Year RESIDENT Date;
tmp: LOAD DISTINCT Month RESIDENT Date;
JOIN (Date) LOAD DISTINCT Month, if(mod(month(Month),3)=1,date(MonthStart(Month), 'MMM-YY'), chr(10)& repeat(' ', RowNo()) & chr(10)) as Month1 RESIDENT tmp ORDER BY Month;
DROP TABLE tmp: // ==================================
Field Month1 is what we need for the chart as dimension. It looks more or less OK if use vertical labels, not continuous. And, in Presentations limit legend (characters) to 6.