|
vb123.com |
|
|
Home Contact Us Order our Software RSS &
Newsletter
Get Good Help
The
Workbench
Find out who has your database open, start the
correct version of Access, easy compacting and backups, change startup
options, mde compile, shutdown database
Read and
Download Garry's Blog
About The Editor
Garry Robinson
writes for a number of popular computer magazines, is now a book author
and has worked on 100+ Access databases. He is based in Sydney,
Australia or try our new site built with
SharePoint Designer |
Is Your Database Corrupt ?
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 (YOU WILL NEED TO OWN THE TOOLSHED eBOOK FIRST). 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.
Click here for the
download file if you own "The Toolshed" Else Click
To Purchase
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.
What this means in English is you have to organize your query so the First Axis holds the information all points and the other columns are organized so that the scatter plot comes out in different columns. ie Time Column 1, Blue Column 2 and Green Column three
Related Documents at VB123
Using Microsoft
Access To Display Spatial Information
Taking Control Of Microsoft Graph from Microsoft Access
Making The Most Of The OLE Chart Object
Consolidation Queries
Data Mining Using MS Access
Using Access Filters to Graph and Explore Your Databases