Scatterplots or XY Graphs  Using Access

<< Click to Display Table of Contents >>

Navigation:  Graphs, Pivots and Charts >

  Scatterplots or XY Graphs  Using Access

 

One of the hardest graphs to setup in an Access database is the scatterplot.  This is principally because the graph object requires data in a different format than a normal graph.   Rather than describing all the ins and outs of setting up a scatterplot, you can open this database and look at the example.  If this is the sort of example that you are looking for, import the form into your database and change the data source behind the form to suit your data.

 

 

Question From A Reader

 

My client wants to show two series of data on the same graph. He has printed report examples of it being done. I am trying to find out how. The MS Access Graph help is as follows

An xy (scatter) chart either shows the relationships among the numeric values in several data series or plots two groups of numbers as one series of xy coordinates. It shows uneven intervals — or clusters — of data and is commonly used for scientific data.

When you arrange your data, place x values in one row or column, and then enter corresponding y values in the adjacent rows or columns.

graphs_scatterplot

The query for this graph is SELECT MapDataSmall.East, MapDataSmall.North FROM MapDataSmall;

 

What happens if you want to show 2 elements verses say time

You have to organize your query so the First Axis selects the Time and the results for those times follow.  ie Time Column 1, Blue Column 2 and Green Column three

graphs_scatterplot2

 

Practice In Excel

 

If you ever want to do a chart in Access, its usually better to practice in Excel because if you cannot get the layout you want in Excel, you are going to waste a lot more time trying to get it to work in Access

 

The file name in the downloads from SWReg is called   spatial2007.accdb

Click here to find out how to purchase all the downloads

 

Other Articles You May Wish To Try