Written by Although, this is an Access entry but this text is Google serachble so someone who is looking for this can find it, therefore I’m posting it here.
I’ve created animation of plotting a XY scatter in MS Access and placed here.
Also, I’ve described the procedure here.
No related posts.
An easier way to get scatter plots in Access 2003 using a pivot chart:
1. Create a form based on a table or query using the form wizard. Include any fields you want to filter by as well as the fields you want for your x and y values.
2. Select PivotChart as your form layout.
3. Continue through the wizard. When you finish, select “Modify the form’s design.”
4. The form will open in design view. Switch to the PivotChart view.
5. Right click on the chart area and select Properties.
6. In the Data Details tab, select “Plot detail records.”
7. Set the chart type to X,Y (Scatter). If you do this before selecting “Plot detail records,” Access will re-set the type to a column chart.
8. Drag and drop the chart fields as you wish.
This method has the added bonus of allowing multiple charts to be seen on one screen, based on your filter criteria.
Hi Adam
Thanks for your comment.
That is for one series and two columns. I have 2 series and 4 columns. Do you know how to plot this? It’s so easy in Excel but no way in Access.
@Adam