chart in access

  • Thread starter Micheal Jackson Moua
  • Start date
M

Micheal Jackson Moua

Hi,
I'm trying to insert a chart in a report in MS Access.
I have a simple table like this:
studentnumber:1(long integer)-studentname:a(text)
studentnumber:2-studentname:b
studentnumber:3-studentname:c
studentnumber:4-studentname:d
When i create a report, i click on the Chart icon on the toolbar, and then
when Chart Wizard asks me which fields contain the data i want in the chart,i
chose "Studentnumber and studentname" from the "Available fields" , then
chose the bar chart type ..However, when i finish, the chart appears so
weird, it has files which i never declared before like: North, West, East
(Y-Axis) and 0-50-100 (X-Axis) and the legends are 4th Qtr, 3 Qtr ,2nd Qtr,
1st Qtr.. They look like the default chart to me when Access cannot draw the
chart from the provided data...Did i do anything wrong here? I have tried
many ways, but still got the same result. I just want to have a chart like:
X-Axis:Student number (1,2,3)
Y-Axis: STudentname (a,b,c)

Please help, i stucked here for days and i need to do this chart to complete
the report ASAP.
Thanks a lot
 
M

Meng

Have you got a load of different students with the same number then as if
there is only one student with the number 1 and 1 student with the number 2
etc then no chart can be drawn and wizards just doing it's best to create one
from nothing for a chart you need to have values that are seperate/different
eg the number of students studying maths, the number of students with the
number 1. If you have student paul with a value of 1 and student jane with a
value of 2 etc the chart will just look like steps, do not use the wizard
just pick a standard chart. If you are between the ages of 3 and 7 you may
get away with displaying this type of data on a chart if you are not try and
pick some values with a little more substance to them.
M
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top