VBA, Updating PowerPoint Presentation graphs using data from Access

Updating PowerPoint Presentation graphs using data from Access

Author	Message
Francisco A Duqu #1 / 7	Updating PowerPoint Presentation graphs using data from Access Hi there, I'm using a PowerPoint Presentation with different graphs and charts, the data that the graph rely on is in an Access database, and I was wondering whether there is an automatic way to do this on the fly (at the moment I have to go to the database to the end of the query and copying data and pasting it into the Powerpoint graph). I would appreciate any help you could provide me with. Thanks in advance F
Sat, 02 Oct 2004 18:04:37 GMT

JH #2 / 7	Updating PowerPoint Presentation graphs using data from Access I am not familiar with how PP makes charts and where it stores the data for its charts. Can you tell me more about this? I'm sure that Access can be automated with PP; I just need to know where the data for the charts is stored in PP. Joe Quote: >-----Original Message----- >Hi there, >I'm using a PowerPoint Presentation with different graphs >and charts, the data that the graph rely on is in an >Access database, and I was wondering whether there is an >automatic way to do this on the fly (at the moment I have >to go to the database to the end of the query and copying >data and pasting it into the Powerpoint graph). >I would appreciate any help you could provide me with. >Thanks in advance >F >.
Sat, 02 Oct 2004 21:21:48 GMT

Francisco A Duqu #3 / 7	Updating PowerPoint Presentation graphs using data from Access The data is stored in the Datasheet of the MS Graph. in the following format: Date NY LDN 4/11/02 1261.2 515 4/12/02 1261.2 525 etc... I don't know if you see what I mean, let me know if you need further info. Thanks in advance, I really appreciate your help F Quote: >I am not familiar with how PP makes charts and where it >stores the data for its charts. Can you tell me more >about this? I'm sure that Access can be automated with >PP; I just need to know where the data for the charts is >stored in PP. >Joe >>-----Original Message----- >>Hi there, >>I'm using a PowerPoint Presentation with different graphs >>and charts, the data that the graph rely on is in an >>Access database, and I was wondering whether there is an >>automatic way to do this on the fly (at the moment I have >>to go to the database to the end of the query and copying >>data and pasting it into the Powerpoint graph). >>I would appreciate any help you could provide me with. >>Thanks in advance >>F >>.
Sat, 02 Oct 2004 21:35:18 GMT

JH #4 / 7	Updating PowerPoint Presentation graphs using data from Access F, I will need more information. Is the datasheet of MS Graph stored in PP? There must be a way to access an object that references the Datasheet. By when do you need this? J Quote: >-----Original Message----- >The data is stored in the Datasheet of the MS Graph. >in the following format: >Date NY LDN >4/11/02 1261.2 515 >4/12/02 1261.2 525 >etc... >I don't know if you see what I mean, let me know if you need further info. >Thanks in advance, I really appreciate your help >F - Hide quoted text - - Show quoted text - Quote: >>I am not familiar with how PP makes charts and where it >>stores the data for its charts. Can you tell me more >>about this? I'm sure that Access can be automated with >>PP; I just need to know where the data for the charts is >>stored in PP. >>Joe >>>-----Original Message----- >>>Hi there, >>>I'm using a PowerPoint Presentation with different graphs >>>and charts, the data that the graph rely on is in an >>>Access database, and I was wondering whether there is an >>>automatic way to do this on the fly (at the moment I have >>>to go to the database to the end of the query and copying >>>data and pasting it into the Powerpoint graph). >>>I would appreciate any help you could provide me with. >>>Thanks in advance >>>F >>>. >.
Sat, 02 Oct 2004 22:14:19 GMT

Francisco A Duqu #5 / 7	Updating PowerPoint Presentation graphs using data from Access yes the Datasheet is stored inside MSGraph, which is an object inside PowerPoint,... and the data would have to be pasted into this Datasheet, at the moment this data is copied manually accessing the Access File copying the data and pasting it into the PowerPoint presentation, but that takes long as there are more than 1 single slide,... thanks again. P Quote: >F, >I will need more information. Is the datasheet of MS >Graph stored in PP? There must be a way to access an >object that references the Datasheet. >By when do you need this? >J >>-----Original Message----- >>The data is stored in the Datasheet of the MS Graph. >>in the following format: >>Date NY LDN >>4/11/02 1261.2 515 >>4/12/02 1261.2 525 >>etc... >>I don't know if you see what I mean, let me know if you >need further info. >>Thanks in advance, I really appreciate your help >>F >>>I am not familiar with how PP makes charts and where it >>>stores the data for its charts. Can you tell me more >>>about this? I'm sure that Access can be automated with >>>PP; I just need to know where the data for the charts is >>>stored in PP. >>>Joe
Sat, 02 Oct 2004 22:33:21 GMT

<solex> #6 / 7	Updating PowerPoint Presentation graphs using data from Access Francisco, You can link to an excel spread sheet via the Powerpoint 2000 UI (via paste link menu option). Alternatively you could use automation to populate your datasheet. Esentially Powerpoint is an object repository and by using the shapes collection you could add an embedded Microsoft Graph object (which would give you a handle to the graph object) and then use automation to populate the data sheet using your access data. Try looking at the following help files: a) c:\program files\microsoft office\office\1033\vbappt9.chm <=== Microsoft PowerPoint b) c:\program files\microsoft office\office\1033\vbagrp9.chm <=== Microsoft Graph Let us know how it goes. Dan Quote: > Hi there, > I'm using a PowerPoint Presentation with different graphs > and charts, the data that the graph rely on is in an > Access database, and I was wondering whether there is an > automatic way to do this on the fly (at the moment I have > to go to the database to the end of the query and copying > data and pasting it into the Powerpoint graph). > I would appreciate any help you could provide me with. > Thanks in advance > F
Sat, 02 Oct 2004 23:11:44 GMT

<SteveT> #7 / 7	Updating PowerPoint Presentation graphs using data from Access Francisco, I have yet to be successful at automating a MsGraph object in a PowerPoint presentation. You might consider having Access forms with matching graphs. Run a procedure to open the forms and save the graphs as gifs or jpgs and then automating your PowerPoint presentation going through the Slides and Shapes to replace the pictures. Steve Quote: > yes the Datasheet is stored inside MSGraph, which is an object inside > PowerPoint,... > and the data would have to be pasted into this Datasheet, at the moment this > data is copied manually accessing the Access File copying the data and > pasting it into the PowerPoint presentation, but that takes long as there > are more than 1 single slide,... > thanks again. > P > >F, > >I will need more information. Is the datasheet of MS > >Graph stored in PP? There must be a way to access an > >object that references the Datasheet. > >By when do you need this? > >J > >>-----Original Message----- > >>The data is stored in the Datasheet of the MS Graph. > >>in the following format: > >>Date NY LDN > >>4/11/02 1261.2 515 > >>4/12/02 1261.2 525 > >>etc... > >>I don't know if you see what I mean, let me know if you > >need further info. > >>Thanks in advance, I really appreciate your help > >>F > >>>I am not familiar with how PP makes charts and where it > >>>stores the data for its charts. Can you tell me more > >>>about this? I'm sure that Access can be automated with > >>>PP; I just need to know where the data for the charts is > >>>stored in PP. > >>>Joe
Sun, 03 Oct 2004 00:30:30 GMT

Page 1 of 1

[ 7 post ]