x-axis label dates in alphabetical order (but unwanted)

[vinch999]

Hi,
I have a problem to display dates on a bar chart.
I have a data value every day.

I display the Day([Date]) and the monthName([Date]) on x-axis labels.
But the months are displayed in alphabetical order  >:(. I don't understand because I haven't this problem with other charts...

So I have April-----February-----March rather than February-----March------April

How to correct it?

Vinc

[PRIT AMRIT]

 A quick solution :)

Create a data item called [Sort Month]:

Case  monthName([Date])
when 'Jan' then '1'
when 'Feb' then '2'
so on
when 'Dec' then '12'
end

Sort your x-axis on [Sort Month]

Hope it helps?

Thanks

[vinch999]

Thank you Prit , it works fine !  8)