[AccessD] Scatter Graph

David Emerson newsgrps at dalyn.co.nz
Tue Mar 15 20:49:01 CST 2005


Yes I discovered that.  My only problem is that the x values are not the 
same between the two series.

David

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




More information about the AccessD mailing list