Link Access Data to PPT Graph?

[JLJones13]

Hi,

I am trying to create a graph in PPT that is based on data in an Access
query. When I try to use Paste Link..., it is grayed out.

Can I Link a PPT graph to data in an Access query? The only info I found on
the web thus far is how to programmatically create a graph from Access.

TIA.

 

[Brian Reilly, MS MVP]

JLJ,
No way to create an OLE link from a PPT chart to an Access database.
Either use ADO/DAO to get the data directly or populate XL from a
query and make the chart from there and link that chart to PPT. Then
just refresh the query and update the link in PPT. Neither one is for
the faint of heart.
Brian Reilly, PowerPoint MVP

 

[JLJones13]

Brian:

Thanks for the info. My solution was the Access Query --> XL --> PPT Graph
and it seemed a little "taped together". I thought there *must* be a way
to skip over the middle step and maybe I was missing something simple )

Thanks again for your time and for giving me some alternative solutions!