On 26 Aug 2006 09:05:11 -0700, "Justin" <ju***********@gmail.comwrote:
>I am trying to create a graph thats based off of the data shown on each
page.
Here is a page of the report, sans graph
http://img217.imageshack.us/img217/7...dreportsu5.jpg
I want the graph to show week (x-axis) vs. quantity (y-axis) for each
week shown on the page. I've tried the chart wizard, but that doesn't
seem to be working. Any ideas?
as you have found, graph questions get few responses. You can find some earlier ones by googling
previous entries in this group. I have some progs but they old ones in A97.
The wizard is hard to use and always makes totals queries, you can set up the query yourself with
the columns eg
weeknumber, series1value, series2value, etc
and assign different symbols to series 1 and series 2.
It is easier to generate an entry for every week in the range rather than have gaps. That way you
can use week numbers or dates, I wouldn't like to do a scatter chart with dates.
Hope this helps a bit