Next Tip  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 Toolbox 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.

 

  Your Sample Database Is Called   "scatterplot.zip"

Sample database is suited to all versions of Access

If you do NOT own "The Toolbox", Click here to find out how to purchase The Toolbox.

 

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
Making The Most Of The OLE Chart Object
Consolidation Queries
Data Mining Using MS Access
Using Access Filters to Graph and Explore Your Databases

Creating Charts/Graphs in an Access 2007 Database

 

Our Tools and Resources

  • RSS & Newsletter Here
    Join our newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
  • Get Good Help
    If you need help with a database, our Australian Professionals could be the answer

  • Smart Access is online 
    The best magazine written about Microsoft Access is now being transferred to the web. There are 400 articles written by a 100 authors in the collection. 

    Purchase Smart Access

  • The Workbench
    Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, creation versions,  shutdown database

  • Read about the Toolbox
    Sample downloads, library resource kit and searchable help file comprising most of the information at vb123.com.au plus hidden downloads etc. Includes one of Smart Access downloads.

  • Convert Access to SQL Server  
    Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query  translation and web form conversion.
  • Purchase the Popular FMS Products  
    If you purchase the Popular FMS products from us, you will receive a complimentary of Smart Access Gold, Silver or Bronze Collections [Your choice]

 

 

vb123 Professionals


Get Good Help Here

If you need help with a database or Office programming, our Professionals could be the answer because we have worked on many similar solutions


Frontpage Conversions
We have converted vb123.com to Expression Web, contact us if we can help you move to the latest Microsoft web tool.


About The Editor ~ Contact Us
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

Access 2003 Security

MS Access Security

Read More here