I'm thinking of drawing a line chart using months on the x-axis and some numbers on the y-axis.

It will display monthly totals, where the months is represented by its numerical value. All the data is available from the sql query so I just need to select the correct axis.

But then the axis displays by year. Is there a way to show it in months?

Edited by Keikoku - 27 Jul 2011 at 5:01am

It was the order. I didn't set it properly.

Edited by Keikoku - 27 Jul 2011 at 9:07am