link access data to powerpoint graph

[Guest]

Can anybody help

how to link access database to graph data

I want to create a graph in powerpoint with data available in access
database with link.

So that whenever data in access is modified, the graph is updated.

Thanks in advance

 

[Steve Rindsberg]

Can anybody help

how to link access database to graph data

I want to create a graph in powerpoint with data available in access
database with link.

So that whenever data in access is modified, the graph is updated.

Have a look here ... I think you'll need something like this:

http://www.presentationpoint.com/software/datapoint/index.htm

You can link Excel data (not sure about Access) into MSGraph charts within
PowerPoint but they don't automatically update. You have to activate each
chart to force an update. Or use this:

http://skp.mvps.org/updtlinks.htm

 

[Guest]

Thank you.

But I need somemore help.

The add-in is OK, but it is not a freeware.

Actually, I am developing a small software package
in which I have to present a powerpoint presentation,
it has to be updated daily. It contains many graphs.

Whenever a user updates data from my program,
Graphs in powerpoint presentation should be updated automatically.


Anyhow thank you very much for your help,

http://www.presentationpoint.com/software/datapoint/index.htm

was helpful to me.

 

[Steve Rindsberg]

Actually, I am developing a small software package

in which I have to present a powerpoint presentation,
it has to be updated daily. It contains many graphs.

Whenever a user updates data from my program,
Graphs in powerpoint presentation should be updated automatically.

OK. Then in broad outline, here's my guess:

Your program will have to automate PowerPoint.
You'll find some pointers here:

Automate Excel from PowerPoint. Automate PowerPoint from Excel. And so on.
http://www.pptfaq.com/FAQ00368.htm

How to automate PowerPoint using VB
http://www.pptfaq.com/FAQ00115.htm

You'll need a way for your program to track the relationship between its data and
the specific graph in PowerPoint that represents the data. I can't suggest much
in that area w/o knowing how the graphs are created in the first place.

When the data are updated, you'd need to locate the graph in PPT, get an object
reference to it and call the object's Update method, then have PowerPoint do a
GoToSlide to force the view to update.

 

[Guest]

Thanks a lot.

Have a nice day.

OK. Then in broad outline, here's my guess:

Your program will have to automate PowerPoint.
You'll find some pointers here:

Automate Excel from PowerPoint. Automate PowerPoint from Excel. And so on.
http://www.pptfaq.com/FAQ00368.htm

How to automate PowerPoint using VB
http://www.pptfaq.com/FAQ00115.htm

You'll need a way for your program to track the relationship between its data and
the specific graph in PowerPoint that represents the data. I can't suggest much
in that area w/o knowing how the graphs are created in the first place.

When the data are updated, you'd need to locate the graph in PPT, get an object
reference to it and call the object's Update method, then have PowerPoint do a
GoToSlide to force the view to update.



-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================