Pivotchart sorting issue

[captaman]

I have a pivotchart that displays some scientific data collected over several months. Every datapoint has a timepoint in months (set to single since I have some data at 4.5 months). On the pivotchart the y-axis is the data result and the x-axis is the time in months (which I want to sort in ascending order).

I set the sorting option for the x-axis on the chart to ascending but it's not sorting it properly. The first few timepoints are in the correct order but then they become a mess. I'm not sure but it seems like it's first sorting the time by timepoints with the most datapoints. Then it sorts them by time so they are in pseudo-ascending order (see sample database attached). How can I force it to sort the x-axis in absolute ascending order (i.e. 0, 3, 4, 4.5, 6, etc.)?

I've attached a sample of my database to show exactly what's going on (pivotchart is chtInfect which is based on qryInfect). Any help would be greatly appreciated!

Thanks!

 

[JHB]

The problem is that there are result for some month by only one of the temperature. Ex. by -20°C is there no result for 4,5 month.
The graph for -20°C is shown first, afterwards is the graph for -60°C shown with a result for 4,5 month, then 4,5 month is put in end of the graph for -20°C.
You can see it if you only select 1 lot ex. 594-091101.
Show then only the graph for -60°C, and then show both graphs, then you'll see it is sorted correct. The same happens if one of the lots which is "plotted" in first, has lesser results as a other lots coming afterwards.
At the moment, can I only see one way to solve it, but it would involve more queries, or some VBA-coding.
My idea is, (I haven't tried it so I don't know if it works), pick up all month, then pick up all lot numbers, then combine the two queries, and at last combine the result, with the result from "qryInfect", so you have all lots listed with all months, some with a result and some without a result.

 

[captaman]

Great, thanks for your advice, I'll try making the queries that you suggested and hopefully it'll solve this issue.