charts

  • Thread starter Thread starter 123xxxxx
  • Start date Start date
1

123xxxxx

i am trying to display a pie charts, but only one field of data is being
displayed at the end of it all i am trying to display five fields of data in
one pie charts
 
I am not sure how a single pie chart can display five fields of data. Pie
charts expect data like:

Joe 234
Jason 12
Mary 45
Bill 121
etc
Each record becomes a slice of the pie.
 
what i am trying to say is that is displaying 1 slice of data instead of 5
slices of data sorry its my first time that i knew it to be slices of data
rather than fields
 
What does the datasheet view of your chart controls Row Source look like? Do
you have multiple records like my sample or do you have multiple fields:
Joe 234 12 45 121 ...
 
a table contains

last name:
first name
team
Prem Goals
FA Goals
Euro Goals
Cup Goals

what i have done is colate all the SQLs of the goals scored, ie. added all
seperate goals...then into one query, then all i want to do is make a pie
chart of the total of goals scored
so it looks like

Prem goal Fa Goals .......................etc
12 12 ...............etc
now all i want to do is make a pie chart. somehow only give me one slice of
the pie chart showing e.g Prem Goals
 
sorry what i mean its multple fields containing one for data
if you know what i mean
 
Your record is not normalized. I would create a union query
SELECT LastName, "Prem Goals" as GoalType, [Prem Goals] as Goals
FROM tableA
UNION
SELECT LastName, "FA Goals", [FA Goals]
FROM tableA
UNION
.....
You can then use the wizard to create a graph based on a record set that
looks like
Joe Prem Goals 12
Joe FA Goals 12
Joe Euro Goals 14
....
 
Back
Top