unable to change labels on GroupingUnitType quarter

W

waynehirata

I have quarterly data and my category labels look like this:
01/04 04/04 07/04 10/04

I would prefer labels:
03/04 06/04 09/04 12/04

Notice I want each quarter labeled with the last month, not the first
month.

Here is some code:
ax.NumberFormat="mm/yy"
ax.GroupingType = c.chAxisGroupingManual
ax.GroupingUnitType = c.chAxisUnitMonth
ax.GroupingUnit = 3
ax.TickLabelUnitType = c.chAxisUnitMonth
ax.TickMarkUnitType = c.chAxisUnitMonth
ax.TickMarkSpacing = 3

I have tried various combinations of
GroupingType,TickLabelUnitType,Spacing AND Month,Quarter.
Thanks for any help.
 
A

Alvin Bruney [MVP]

grouping defaults to the first day of the time interval. i am not aware that
this is customizable
 
W

waynehirata

Thanks for the info.
I would prefer 03..06..09..12 because when I see that, I know
immediately it is quarterly. With 01...04...07...10, I go 'huh'.
Anyway thanks for your help. I'll have to rid the timeaxes and do more
coding.

grouping defaults to the first day of the time interval. i am not aware that
this is customizable

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
....
....
....
 
A

Alvin Bruney [MVP]

you should consider adding another title to the axis indicating that the
value is quarterly

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Thanks for the info.
I would prefer 03..06..09..12 because when I see that, I know
immediately it is quarterly. With 01...04...07...10, I go 'huh'.
Anyway thanks for your help. I'll have to rid the timeaxes and do more
coding.

grouping defaults to the first day of the time interval. i am not aware that
this is customizable

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
...
...
...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top