If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
pivot charts in access 2007
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 |
#2
|
|||
|
|||
pivot charts in access 2007
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....?? -- Cheers Elliott |
Thread Tools | |
Display Modes | |
|
|