link access data to powerpoint graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Naveen - 02 Sep 2006 14:04 GMT

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

Reply to this Message

Steve Rindsberg - 02 Sep 2006 16:30 GMT

> Can anybody help
>
[quoted text clipped - 4 lines]
>
> 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

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

Reply to this Message

Naveen - 03 Sep 2006 11:13 GMT

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.

> > Can anybody help
> >
[quoted text clipped - 20 lines]
> PPTools: www.pptools.com
> ================================================

Reply to this Message

Steve Rindsberg - 03 Sep 2006 16:35 GMT

> 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.

> Anyhow thank you very much for your help,
>
[quoted text clipped - 26 lines]
> > PPTools: www.pptools.com
> > ================================================

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

Reply to this Message

Naveen - 04 Sep 2006 07:53 GMT

Thanks a lot.

Have a nice day.

> > Actually, I am developing a small software package
> > in which I have to present a powerpoint presentation,
[quoted text clipped - 58 lines]
> PPTools: www.pptools.com
> ================================================

Reply to this Message

Rate this thread: