Chart and Graph formatting

[#1]

Hello everyone,

Just a quick simple one, but I can't seem to find where to make the change.

I have months on the x axis of my chart, and want to change the format of the date to go from DD/MM/YYYY to MMM YY, how can I go about this?

With many thanks,

Simon

[MayilVahanan · Accepted solution]

HI

Try like this

= Date(Datefield, 'MMM YY') as dimension

Hope it helps

[CELAMBARASAN]

Better you can create a field in script itself.

or try with this in charts

=Date(MonthStart(DateField), 'MMM YYYY')

or

=Month(DateField) &' ' & Year(DateField)

Hope it helps

[#4]

That works perfectly, thank you