PivotChart scatter plots

[tjrobert82]

I have a form which contains a query which calculates stress and strain (2 columns, approx. 100 records). So, to plot this data, I set the form to be a PivotChart with a XY Scatter just like I would do in Excel. I then drag the "strain" field into the "X Data" box and "stress" into the "Y Data" box. The problem is, it only let's me enter the data points as an aggregate function (I think). Instead of "strain", Access automatically calculates the total "Sum of strain" for the X Data, which is useless to me. I've tried editing the properties or looking for some automatic setting to turn off, but haven't been able to find anything yet. Any ideas?

 

[kilou]

wow that's an old thread! Did you get a solution? I'm facing the same issue.