PC Review


Reply
Thread Tools Rate Thread

Can I autopopulate powerpoint slides with charts and graphs?

 
 
=?Utf-8?B?bGluZGFw?=
Guest
Posts: n/a
 
      30th May 2006
Can I autopopulate powerpoint slides with charts and graphs? I have a
database that is regularily updated with market research data. I want to have
a standard powerpoint presentation with charts and graphs that can be updated
from the data rather than recreated each time
 
Reply With Quote
 
 
 
 
Steve
Guest
Posts: n/a
 
      30th May 2006
Not sure if this is the cleanest way of doing but I do something
similar.

I use excel to query the data I want to display.
You can either use Data -> Import External Data or Data ->PivotTable
and PivotChart Wizard. It will depend on your data which is best.

Import External Data: In this method you can query the tables to import
the data required. You will need the ODBC drivers to link to your data.
Once you have setup the ODBC to the data you can query the import of
this data. Once the data is imported you can generate the charts.

PivotChart Wizard: Again you will need to setup the ODBC drivers to
link to the data but you can generate the charts without importing the
data.

In either case, once you have the data in a chart form you can select
the chart and paste the link to Powerpoint. This can way you need only
change the data in excel and refresh your slides.

Does this help?


into a chart form and than I link the chart to a slide.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
writing a macro to retrieve a set of graphs into powerpoint slides =?Utf-8?B?QnJpYW4=?= Microsoft Powerpoint 0 16th Dec 2005 04:51 PM
Blank Graphs and Charts in PowerPoint =?Utf-8?B?Q2hhcmxlcw==?= Microsoft Powerpoint 7 23rd Sep 2005 06:06 PM
Powerpoint Charts and Graphs Cindy Microsoft Powerpoint 1 14th Oct 2003 03:45 AM
Help with charts in Powerpoint - widening bars in graphs? Aaron Heck Microsoft Powerpoint 1 16th Sep 2003 11:23 PM
Export Excel Charts/Graphs into PowerPoint using VBA Rach Microsoft VB .NET 0 27th Aug 2003 02:52 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:58 PM.