Creating Scatter Graph Pivot Chart without autocal on (x,y) values

[efj]

Hello,

I'm involved in a performance testing project and I'm trying to use the
pivot charts in access to quickly present results for me. I have a query
which returns my data in the format shown below:
label, timestamp, time
Action1, 2008-07-05 08:30:10.737, 13680
Action1, 2008-07-05 08:30:25.027, 1088
Action2, 2008-07-05 08:30:26.397, 935
Action2, 2008-07-05 08:30:27.603, 813

What I want to do is plot a scatterchart with the x axis as the timestamp,
the y axis as the time and the two actions as the series.

My best efforts can only get can the setup with the x and y axis as "Sum of"
Auto calc functions, rather than just the native data...as per below:

chart type - scatter chart
x-axis data - sum of timestamp
Y-axis data - sum of time
category fields - timestamp (all selected)
series fields - label (all selected)

But this plots the values as:

Action1, 09/01/2117, 27360
Action1, 09/01/2117, 2176
Action2, 09/01/2117, 1870
Action2, 09/01/2117, 1626

Surely there is a simple way to plot actual values rather than having to use
an autocalc funciton be default and hence I assume the sum function doubling
my data???

Any help appreciated/advice appreciated.

 

[efj]

Just been looking at the data again and now the plotting is accurate as per
the data. Must have been pilot error!

 

[murdle]

How did you get it to work, I'm having the same problem.

I have three fields: Students, Major, Test results. I would like to plot
test scores versus majors, but it keeps doing auto sums and I'm not getting
the actual values.

Any ideas?

Thanks