David Emerson
newsgrps at dalyn.co.nz
Mon Mar 21 12:28:50 CST 2005
Thanks for the input. I purchased the Toolshed, and while it didn't directly have the answer, Garry was able to answer it for me. :-) The solution is to create a union query which combines the x values into one column and has the y values in separate rows. Eg X Yellow Green Blue 2.3 1.5 2.8 4.4 3.2 3.3 3.1 3.4 David At 17/03/2005, you wrote: >Gerry Robinson has some MS graph samples >http://www.vb123.com/toolshed/99_graphs/msgraph1.htm >unfortunately you need to buy his Toolshed to find the secrets of >scatterplots ;) >http://www.vb123.com/toolshed/99_graphs/scatterplot.htm > > >David Emerson wrote: > >>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 > > >-- >Marty Connelly >Victoria, B.C. >Canada > > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com