Hi,
I have a table of x and y values that I want to show them in a X-Y graph inside an access form.
Pivot table is not giving me the right XY presentation and always adds the sum of all X and all Y values to the chart and gives me one point as Sum of X and the second point as Sum of Y.
What I need is exactly like the X-Y chart I can have in excel.
any hint will be highly appreciated.
Kia
I have a table of x and y values that I want to show them in a X-Y graph inside an access form.
Pivot table is not giving me the right XY presentation and always adds the sum of all X and all Y values to the chart and gives me one point as Sum of X and the second point as Sum of Y.
What I need is exactly like the X-Y chart I can have in excel.
any hint will be highly appreciated.
Kia