Format Group Access Labels in Bar Chart

[ddnh]

I created a chart for count of a field on change of a date. The date is in the group (Y) axis. How do I format the labels?

If I go to Chart Options/Grid I can select the format for the data axis on the Numbers tab. The Numbers tab is greyed out for the group axis. Any suggestions?

Right now it's showing as 1/2004. I'd like it to show as January 2004.

 

[DallasAggie]

hey ddnh.

I think you should use a formula that converts the value over to year

DatePart("yyyy", {yourfieldHere})

I was actaully just working on the same thing and this works fine for me.

Regards,
Robert
The Boeing Company.