charts

[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

 

[Duane Hookom]

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.

 

[123xxxxx]

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

 

[Duane Hookom]

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 ...

 

[123xxxxx]

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

 

[123xxxxx]

sorry what i mean its multple fields containing one for data
if you know what i mean

 

[Duane Hookom]

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
....