How to create XY scatter plot in MS Access

Creating scatter plots in Microsoft Access is a challenging problem. Follow these steps to create your own scatter plot:

1. Under forms tab, click New
2. On the New form window select Chart Wizard and Select the table, which has your data, hit OK
3. On the next screen, add two fields for which you want to plot a scatter graph, Hit next
4. On this screen where you have option to select the type of the graph(you’ll see pictures of various types of plots) , select XY scatter, hit next
5. Hit next again
6. On the next screen, Enter the title for your plot, Select Modify the design of the form or chart, hit Finish
7. When you see the sample plot, in design view, double click the plot to edit it, while plot is still selected, Click on the Data menu from the toolbar above, then click on Series on Columns
8. Select the chart and right click on it, click on properties
9. Go on the Data tab, change the row source property something like this

SELECT[x],[y] FROM [DATA];

                 SELECT[x],[y] FROM [data];

10. If you want a trendline, double click to edit the chart and right click on the data line, click on Add Trendline, and if you want to see R-square and equation, click on options and check the box for equation and R-square.

These steps are clearer in this video of creating a XY scatter plot in MS Access: