By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

Graphs in Reports

P: n/a
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?

Aug 26 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Aug 29 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.