Using data in Access for Chart Data in Powerpoint.

C

Cory

I am using Office XP on a network that will not allow the installation of
add-ins or the use of more high powered tools such as Visual Studio. All I
have to work with is Office XP in it's normal installed flavor. That said:

I am trying to write a macro that will pull data from Access (A query Table
will be the source later on) and use that data in a chart that is currently
on the slides. (Actually I have to do this a number of times based on
several values, but that is beside the point). The problem is, I do not see
how one can change the data behind the chart object from Powerpoint.

Would it be easier to delete the chart that is there and create a new one?

I tried loading the Excel object model in Powerpoint, and I figure I can
manipulate the chart a little through that but I am still having a helluva
time understanding how it treats these objects, and the Microsoft "help" is
not very helpful in that regard.

Anything you all can help me with would be greatly appreciated.

Cory
 
S

Steve Rindsberg

Visit http://www.pptfaq.com and look through the programming section.

Look for articles by Naresh Nichani; his stuff will explain how to pull data
from Access.

There are also a bits on controlling MSGraph, the app that normally creates
charts in PPT, but if they're Excel charts, the general process will be
similar.

Use the Macro Recorder in Excel to get a leg up on the sort of code you need to
control MSGraph charts.
 
C

Cory

Will do!

Thank you for the speey reply!

Cory

Steve Rindsberg said:
Visit http://www.pptfaq.com and look through the programming section.

Look for articles by Naresh Nichani; his stuff will explain how to pull data
from Access.

There are also a bits on controlling MSGraph, the app that normally creates
charts in PPT, but if they're Excel charts, the general process will be
similar.

Use the Macro Recorder in Excel to get a leg up on the sort of code you need to
control MSGraph charts.



--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Click to expand...
 
Top