pivot charts in access 2007

[YoManKeith]

I would like to do a scatter chart of the following data. When I do the
pivot chart, it defaults to auto calculating sum of x data and count of y
data. I want the chart to calculate neither. Just want it to plot the data
in the chart. I can at least change the autocalc in the x data, but cannot
even move it off count in the y data (all other methods of calc are gray).
Further, there is not a "none" selection in the autocalc menu.

I have also attempted to adapt a line chart (without the lines) to sort of
make the scatter chart. Again the chart wants to autocalc and has no means
that I see to not calculate the data. Any help would be great!
Var1 Var2
2402 173000
2548 195000
2570 220000
3002 282000
2458 167500
2598 165000
2920 199900
2742 194900
2573 287000
2590 187000
2553 231500
2673 274000
2443 252000
2431 345000
3188 297000
2428 346000
3045 320000
2650 428000
2910 312000
3021 299000
2533 245000
2654 297000
2772 185000
2323 179500
2463 216000
3200 192000
2724 219500
2902 300000
2521 230000
2945 205000
2916 255000
2488 155000
2323 189000
2896 278000
2342 323000
2415 238079
2265 295000
3105 235000
2589 245000
3204 340000
3147 320000
2850 351000
2657 259700
3219 253000
2766 409000
2272 201600
2793 375000
2423 244800
3041 375000
3032 450000
2578 279000
2943 312000
2870 285000
2268 226000
3000 295000
2808 265000
2959 235000
2423 267900
3170 335000
2948 395000
2514 259000
3156 410000
2268 230500
2443 259900
3010 267000
2741 329900
2959 314000
3140 325000
2660 322000
3034 200000
3131 450000
3105 292500
3204 450000
3051 305000
2443 269900
2569 370000
2273 400000
3028 325000
2493 349900
2766 435000
3012 290000
2671 275250
2703 275000
2930 935000
2540 335000
2899 394000
3069 465000
2429 415000
3224 370000
2717 425000
2823 220000
2926 297000
3001 330000
2741 279000
2966 407000
3224 308000
2505 196000
2817 298000
2932 389000
2665 238000
2732 214500
3193 445000

 

[efj]

Hi,

I've got exactly the same problem I have a simple x,y series that I want to
plot via an access 2007 scatter x,y pivot chart. I cannot turn off the auto
cacl option. If I leave it on SUM function the data is actually plotted
correctly. so

x,y
1,23
2,34

plots ok, but if any x data is a duplicate e.g.

1,23
2,34
2,30

it will then plot..
1,23
4,64 (it has summed the pair of values - as per the autocalc).

Am I going mad or is there someway of turning the autocalc off....??