Access charts (again!)

[Renster]

Folks, I *had* thought I had fixed a problem, but I haven't - and now
I look at my claimed solution, its hardly surprising!

I am trying to create a chart that plots the *value* of "Run_Metric1"
per "Run" record. By default, when using the chart wizard, Access
nobbles the rowsource to so the chart shows the count of Run1 values
for a given run:

TRANSFORM Count([Run_Metric1]) AS [CountOfRun_Metric1] SELECT
(Format([Run_Date],"MMM 'YY")) FROM [GraphQuery] WHERE Run_Machine =
1 AND Run_Platform = 1 AND Run_FuncArea = 1 GROUP BY
(Year([Run_Date])*12 + Month([Run_Date])-1),(Format([Run_Date],"MMM
'YY")) PIVOT [Release_Metric1];

I changed this to use Sum instead of Count, which was better:

TRANSFORM Sum([Run_Metric1]) AS [SumOfRun_Metric1] SELECT
(Format([Run_Date],"MMM 'YY")) FROM [GraphQuery] WHERE Run_Machine =
1 AND Run_Platform = 1 AND Run_FuncArea = 1 GROUP BY
(Year([Run_Date])*12 + Month([Run_Date])-1),(Format([Run_Date],"MMM
'YY")) PIVOT [Release_Metric1];

However, the way the columns are being grouped, this only works if
there is one run per month. The problem is there is not definite rule
as to when runs may occur... may be daily this week, then none for the
rest of the month, then once a week etc.. What I need is the
individual values, per run, grouped by run, but with date as the x
axis. I've tried all sorts - the number of times Ive seen an error
such as "You tried to execute a query that does not include the
specified expression as part of an aggregate function" isnt funny!

Can anyone offer the correct rowsource to do this?

Thanks

Steve