Months out of order on Pivot Chart

Hello, I've been running into this problem a lot lately as I've been having to make more and more data charts.

I have a series of data from October 1, 2006 through yesterday April 23, 2007.

I wanted to make two things with the data, a pivot table, and a pivot chart of the data.

I'm grouping by months. When I made the pivot table, it puts the months out of order (Jan 07, Feb 07, Mar 07, Apr 07, Oct 06, Nov 06, Dec 06), This was fixed by right clicking the month, and chosing move up on the 3 months from 2006. This made the data run in chronological order.

Then I make a pivot chart once I have my data looking how I want and summed how I want on the data values. The pivot chart does the same thing with the months. The 2006 months are placed at the end of the report.

Problem is, there is no move up and down option on the chart data for me to move those months up front. So my live graph shows the 2007 data followed by the 2006 data in the same month order as listed above. Jan 07-Apr 07, Oct 06-Dec 06.

Does anyone know how to fix this? My chart looks how I want it to look, all the data is visible, but these months will not for the life of me go into chronological order which is driving me nuts. I can't figure out why Excel would continually order it like this. I need to get the 2006 data at the front of the chart.

Thanks for any help anyone can offer.

You can make your pivot chart based from your pivot table. On the pivot table just right click and choose pivot chart. If you have the month in the right order in the pivot table, your pivot chart should give you the same result.

I actually figured this out. I was telling the pivot table to group by months. I only had about 6 months of data, so that seemed logical, I needed to group by years however. Doing that put things in the correct order. Year 2006 months, then year 2007 months.