I created a simple area chart using the name of months along the X-axis and the min, max and average sales figures along the Y-axis.

I entered the data in the underlying table as so:

Month      Min      Max      Average

Aug         10        20         15

Sep         8          15         11

and so on.....

Jul           22        27         24

I would like the graph to maintain the order of the month entered. Unfortunately the graph seems to apply a default sort on the X-axis where I get the month listed in the wrong order i.e. Apr, Aug, Dec and so on till Sep. When I click the "View underlying data" button, the list is automatically sorted by Month.

Is it possible to disable the automatic sort on the X-axis? If not, is there an alternative method to maintain the sort of the underlying table?

   

Cheers

Sunil