Excel worksheet to Powerpoint graphs

T

terryc

I'm new to Powerpoint and can't quite understand the other posts.

I want to enter my financial totals into an excel spreadsheet, have it link
to graphs in Powerpoint. Each month I would change the Excel data and have
the graphs automatically update. I need 4 pie graphs to display totals of 8
categories and 2 bar graphs that will compare actual to budget figures in 6
categories. I'll also need 1 slide that looks like Excel to summarize an
Excel spreadsheet.

It seems some users are somehow keeping the excel data inside powerpoint so
there isn't a need for 2 files.

I'm open to using the easiest method for updating. Just need the basic
steps. Thanks to all who can help.
 
T

terryc

oops! 2007

Echo S said:
Which version of Office are you using? 2007? 2003? Something else?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


terryc said:
I'm new to Powerpoint and can't quite understand the other posts.

I want to enter my financial totals into an excel spreadsheet, have it
link
to graphs in Powerpoint. Each month I would change the Excel data and have
the graphs automatically update. I need 4 pie graphs to display totals of
8
categories and 2 bar graphs that will compare actual to budget figures in
6
categories. I'll also need 1 slide that looks like Excel to summarize an
Excel spreadsheet.

It seems some users are somehow keeping the excel data inside powerpoint
so
there isn't a need for 2 files.

I'm open to using the easiest method for updating. Just need the basic
steps. Thanks to all who can help.
 
T

terryc

Would someone be able to help me? My meeting is 1/23. Thank you.

terryc said:
oops! 2007

Echo S said:
Which version of Office are you using? 2007? 2003? Something else?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


terryc said:
I'm new to Powerpoint and can't quite understand the other posts.

I want to enter my financial totals into an excel spreadsheet, have it
link
to graphs in Powerpoint. Each month I would change the Excel data and have
the graphs automatically update. I need 4 pie graphs to display totals of
8
categories and 2 bar graphs that will compare actual to budget figures in
6
categories. I'll also need 1 slide that looks like Excel to summarize an
Excel spreadsheet.

It seems some users are somehow keeping the excel data inside powerpoint
so
there isn't a need for 2 files.

I'm open to using the easiest method for updating. Just need the basic
steps. Thanks to all who can help.
 
T

terryc

Steve, the pptfaq site was very helpful. I want to link the excel file but I
can't figure out how to do it in 2007. Thanks.
 
T

terryc

Steve, should I only have to link my excel file once to ppt and not with each
slide?
 

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