[AccessD] Scatter Graph

I was wondering if that's what your were doing.

I did a quick try in Excel.  You put your X values in a column (or row).
Then all your Y values go into additional columns (or rows).  So for two
series you'll have 3 columns.  

MS Graph can probably do this - it seems to some of the same capabilities as
Excel.

Hope that helps!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
Sent: Tuesday, March 15, 2005 8:19 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Scatter Graph

Thanks for the reply Dan.

My client has two series of data he wants to show on the same graph.  He 
has printed report examples of it being done.  I am trying to find out how.

David

At 16/03/2005, you wrote:
>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