Group by Month - Charts

[#1]

Dears,

I have another problem.

How can I group by month the values in my chart. Coz actuallu it is showing every date like (01/01/2010, 01/02/2010, 01/03/2010...) I need to group it by month.

Follow attached is the example.

Could you please help me?

[matt_crowther]

Instead of Rolands 'month(Date)' use Monthname(Date) as I first suggested, it will return MMM-YY.

Hope that helps,

Matt - Visual Analytics Ltd

[#3]

Try Month(Date,...)&Year(Date,...) as MONTHYEAR

[#4]

Matt Crowther,

Your solution really worked to me, but in order to reduce the chart size, I would like to write (01-11) and not (January - 11).

How can I do it?

Thanks

[#5]

use this

=date(Monthname([Cal Date]),'MM-YY')

[#6 · Accepted solution]

use this

=date(Monthname([Cal Date]),'MM-YY')

[#7]

use this

=date(Monthname([Cal Date]),'MM-YY')

[#8]

use this

=date(Monthname([Cal Date]),'MM-YY')

[#9]

use this

=date(Monthname([Cal Date]),'MM-YY')

[#10]

use this

=date(Monthname([Cal Date]),'MM-YY')

[#11]

use this

=date(Monthname([Cal Date]),'MM-YY')