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

help in craeting a chart in access 2000

P: n/a
Let say, I have a table called USERS with the following fields:
UserID, Date, Name, ComType.

ComType gets it's info from another table called TYPE with fields:
TypeID, TypeOfCom, with options: Email, Phone, Message

Table Samples:

UserID Date Name ComType
-------------------------------------------
1 1/10 Paul Email
2 1/10 Liza Phone
3 1/10 Monet Email
4 1/15 Louie Message
5 1/15 Vin Phone
6 1/16 Dave Email
7 1/16 Chip Email
8 1/16 Danny Email

I have a form that asks user to enter a date range (i.e. BeginDate,
EndDate).
This form brings up a report like the one below:

Date No. Users Email Phone Message
-------------------------------------------------
1/10 3 2 1 0
1/15 2 0 1 1
1/16 3 3 0 0

How can I create a chart based on this report. Basically,
a form that asks for the date-range. A user enters a starting date
and ending date, and brings up the chart after hitting enter.

The chart will have the following chgaracteristics:

Date on the X-axis, No. of users on the Y-axis. There will
be 3 bars or legends: Email, Phone, Message. In other words,
each of the dates: 1/10, 1/15, 1/16 will have three bars.
One bar for "Email", one bar for "Phone" and one bar for "Message".

Any help or tips will be greatly appreciated. I was playing around
by creating the chart on a form. I was able to change x-axis but,
couldn't seem to add the 3 bars. Also, I don't know how I can
link the chart to a form for the date-range (like a filter). I
was able to change the legends but, everytime I ran it, it goes
back to "ComType".

You mail email me directly at "pc*******@yahoo.com". Thank you
very much in advance.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Paul,
If all you want to make is a histogram, its quite easy. I do it
all the time by using labels as the bars, right on the form. Set the
length of the bars based on the values in your table. You will need
to be familiar with scalers to convert table values to the physical
size of the label on the form. If you need more help, write me
direct.
Hank Reed
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.