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

[elliott_jones]

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
the autocalc funciton? Using one of the autocalc functions appears to
be mandatory and I assume the sum function is doubling my data???

Any help /advice appreciated.

 

[elliott_jones]

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