Trying to sort chart by month

[dmorand]

I've got a chart that I'm trying to sort the bottom rows by month, but I keep getting them in this order:

1 10 11 12

I need it to be

10 11 12 1

I need it in this order because it's really 200710, 200711, 200712, 200801

How do I go about doing this?

[dmorand]

I figured it out, I'm a dummy. I needed to add the year into the sort so that it would work correctly.