Friday, November 04, 2005
XY scatter plot in MS Access
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.
I've created animation of plotting a XY scatter in MS Access and placed here.
Also, I've described the procedure here.
Labels: Access
Comments:
Links to this post:
<< Home
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.
Post a Comment
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.
<< Home
