Gharting lines from two or more Queries

  • Thread starter Thread starter JoeC
  • Start date Start date
J

JoeC

Does any one know how to Plot multi Lines in a X/Y Chart or Graph where
each line is based on a seperate query. These lines are based on
Running Sum Counts of events grouped by dates.

First Query Shows:
0
2
7
10
12
15
20
25
30
50
Ect

Second Query Shows:
0
2
5
7
9
13
18
ect.
 
You'll have to combine your queries to return a single dataset, which you
use as the recordsource for the graph. And you'll also have to include the
dates, if that's what you want your x-axis to show.

Your query will need to return something like:

Date Q1Value Q2Value
1/4/2005 0 0
2/4/2005 2 2
3/4/2005 7 5
etc

HTH,

Rob
 
Back
Top