I'm so confused about scatter chart in access. It is very easy to create in excel, but in access things look very different.
I have a query that includes x and y columns, I'd like to create a scatter chart on a form that use x column as x axis and use y column as y axis.
I'm using access 2010, I went to created --> pivot chart, and changed the chart type to scatter chart, there were "drop field here" and "drop category here" areas, where should I drop the x and y field? I tried different ways nothing was shown.
Thanks for any help.
I have a query that includes x and y columns, I'd like to create a scatter chart on a form that use x column as x axis and use y column as y axis.
I'm using access 2010, I went to created --> pivot chart, and changed the chart type to scatter chart, there were "drop field here" and "drop category here" areas, where should I drop the x and y field? I tried different ways nothing was shown.
Thanks for any help.
