PowerPoint 2003 and Excel 2003 graph linking questions

[Stephen]

First of all I want to thank anyone who replies to this post. I am stuck on
this and I don't know how to do it.

We are playing a game utilizing some Audience Response Keypads with 2 teams
(red and blue). I have already contacted the audience response software
creator and their software cannot do what my client wants so in the past we
have been doing it manually on a back up laptop so i'm looking to try and do
this in an easier fashion than before.

In excel i would like to create a worksheet with 2 teams red and blue. there
are 12 questions in all and we will be giving each team an alotted amount of
points depending on their answer.

what i would like to do is insert a graph into powerpoint. Lets imagine
after question #1 i want to show 2 pie graphs. One being the red team and one
being the blue team. Each graph will slowly fill up stating which team is
winning. but i do not know hot to properly link the data and then insert
these two graphs.

I tried doing an insert object from file, then pointing to the document and
linking the data. that works when i change the data i just right click on it
in powerpoint and it updates. But i don't know how to take this and make it
into 2 seperate graphs.

can someone help me on this?

 

[Stephen]

So If i have a total of 12 questions... and since i have two teams and the
way you stated it i would need to create a new sheet with that graph on a
single sheet.

Does that mean i'll need to end up creating a total of 24 work sheets? Each
with a single graph on it. 12 questions for blue team is 12 graphs/worksheets
and 12 questions for red team is 12 graphs/worksheets add them together is 24
work sheets. That might make things more difficult than the way i have them
now. Or am i confused?