Dan Waters
dwaters at usinternet.com
Tue Mar 15 19:29:42 CST 2005
Dave, A scattergraph only has one series. That series is made up of pairs of numbers: X and Y. So you need 2 columns, one for X and one for Y, where each data point is on one row. (Or transpose the rows and columns.) The rows do not need to be in any particular order. Good Luck! Dan Waters -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson Sent: Tuesday, March 15, 2005 6:00 PM To: accessd at databaseadvisors.com Subject: [AccessD] Scatter Graph AccessXP I am having trouble getting the data source correct for a scatter graph. I have data in a table with the following fields - Series1X, Series1Y, Series2X, Series2Y. Using the Chart Wizard I can select the fields, and XY (scatter) chart. Where I get unstuck is in the "How do you want to lay out your data in the chart" screen. Does anyone have any examples of a scatter chart using two series that I could look at? Regards David Emerson Dalyn Software Ltd 25 Cunliffe St, Churton Park Wellington, New Zealand Ph/Fax (04) 478-7456 Mobile 027-280-9348 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com