Overlay two queries into one chart

[ChrisH]

Is there a method for charting the results of two queries into one view?

I want to see "the number of widgets produced over time" in column format,
with "the number of widgets serviced over time" in line format. I can get
the independent queries to display, but am stumped on how to merge/overlay
them together.

 

[Arvin Meyer [MVP]]

If you use Excel as a chart engine, you may be able to do this. Output each
query separately to a range in Excel, then use the 2 ranges to build your
chart. See the following to learn out to read and right to Excel:

http://www.mvps.org/access/modules/mdl0035.htm

 

[Eighte]

Ok. If I remember!!!! It`s easy...ok.

If you use Excel as a chart engine, you may be able to do this. Output
each query separately to a range in Excel, then use the 2 ranges to build
your chart. See the following to learn out to read and right to Excel:

http://www.mvps.org/access/modules/mdl0035.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access

 

[Duane Hookom]

I expect these are both "over time" so you should be able to combine the
queries into a single Row Source. A chart control can display one series
different from another. They can even have different scales.