How to sort/order x-axis in chart

[khoinh]

Hi,

I have the chart with x-axis is name of month (Jan, Feb, Mar,...). At now, x-axis of my chart is sorted by alphabetically. I want to apply order from Jan to Dec into my chart. Is there any way to accomplish this?   ???

Thanks
Khoi

[imts]

u must be having some column like MONTH_ID in ur DB ; get it in ur query and sort on it.

Else create a data item like
case
when ( 'jan') then (1)
when ('feb') then (2)
...end

like this.

And do an advance sort on this data item.

-TS