Linking to simple data entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All, I do a lot of presentations that are basicly the same however the charts and the texts just either have different numbers of names etc. I final have this presentation looking the way I want it. Is there any way that I can have some sort of data page in PPoint or Excell that allows me to enter the data and I can auto upday the PPoint presentation?
Thanks Kevin Gal
 
Kevin:

Here's what I would suggest:
1) Create your boilerplate presentation with all the information being the way it is.
Include in that presentation a slide that is chart layout.
2) Go File->Save As. Give the file a name, like "Kevin's Presentation." Make sure you save the file type as a template. Include in that file a slide that is Chart Layout. Remember, PowerPoint's chart functionality includes a table where you can enter in the data that underlies the chart.
3) When you want to use your template, go File->New. If you use 2000 or older, you'll get a window asking which template you want to use. You can choose "Kevin's Presentation" from the "General" tab. If you use a newer version of Office, then you click File->New. The task pane will show up on the right. You click "General Templates," and then choose "Kevin's Presentation" from "General."
4) Start modifying any necessary content in your presentation.

HTH.

Cheers,
Geoff Lilley
(e-mail address removed)
MCDST, Microsoft Office Master Instructor (XP/2000),
Microsoft Office Specialist Master (XP/2000)
 
This basicly what I do only I was wondering if the is somekind of table I can just enter the info on and then it is linked to the correct slides
 
Kevin,
Create the original date in an Excel workbook.
With that saved create a PPT file in the same folder as the workbook.

Copy each XL chart and Paste Special Link as Excel workbook into PPT.

Next time change the data in the original XL workbook and when you
open PPT it will ask you if you want to update links. Say yes (or from
the menu Edit update links) and the charts will be refreshed with the
new data.

Critical that you have the two files in the same folder and critical
that you have saved the XL file before copying and paste linking.

Brian Reilly, PowerPoint MVP
 
Back
Top