I want the chart to display the chart for the customer in the cboFindCustomer and  compare the year selected  cboReportYear  to the previous year. So it will change based on the customer selected and the year to compare. Thus all works just not the display of the months

On the chart. The months display properly in the subform for the month comparison

Brent

I would start with these:

Aggregate Query

Chart Showing Monthly Sales

-Raymond

Brent  My advice is export your Access data to Excel and create an Excel chart, which doesn't rearrange your labels and always retain the original data's sort order (picture below).  This process can be done manually or automated with VBA.  In all my years, I've never used Access charts and its modern charts (which also have the same sorting problem).  Your users would probably much rather use Excel to work with charts also.

Thanks for the  information guys!  I have it working and all the data is correct, just those dang months names only show as month nums. I agree Kevin, excel charts are much easier to work with, I was just wanting the chart on the form as a visual. Plus, I like to learn and it looks cool!

Brent To show months as names instead of numbers, use the Format() function on the date in your query:

     SELECT Format(MyDate, "mmm") AS MyMonth ...

But again, Access will sort the months alphabetically on the chart no matter what: Apr, Aug, Dec, Feb, Jan, etc.  Excel charts will not.

I got it to work exactly as I wanted and even learned how to have the labels dynamically change when the data changes(that was the easy part). The months on the bottom of the chart are even correct!! That was an ordeal but the close to end result is cool. Been a long day with this one so I am going to put the finishing touches on it tomorrow.

I have a slightly different situation -- all the above I'd got to work plus the quarters in the correct way ie next years quarter starts in April this year ( don't ask ) so I ended up with two lovely charts one for quarterly figures and one for monthly figures.
   When I showed the two charts to my boss he wants both on one chart cos that's what the format of industry standard needs to be.
    I thought no problem but oh boy. It seems I can't have two x axis ( one for months and one for quarters ) also you can't Ave or sum one series and have the other with 'none' ie no summing or averaging etc so that option is out. I've looked at a combo chart but it doesn't seem to allow a 'none' and a 'sum'.

  My queries are built for two 'nones' ie no summing, averaging or anything else and work perfectly on the two individual charts but the combo chart only works with a line and a bar not two bars ie I want to show a wide quarter bar with the individual months inside the wide bars in a different colour.

  Is this even possible?