How to creating charts for a power point file in Access

[Melissa]

Hello,

I am trying to create dynamic charts for a power point file in access. Is
there anyone know the code?

Any help will be appreciated!

Melissa

 

[Jonathan Parminter]

-----Original Message-----
Hello,

I am trying to create dynamic charts for a power point file in access. Is
there anyone know the code?

Any help will be appreciated!

Melissa

Hi melissa, a possible solution that does not involve any
coding...
1. create query in Access.
2. in database window, select and copy query to clipboard.
3. in excel, use edit|paste special to paste link the
data. This will ensure that this workbook has current data
regardless whether access is open at the same time.
4. in excel create the chart with the formatting that you
require in your powerpoint presentation.
5.select chart and copy to clipboard.
6. in powerpoint, select the slide and then use edit|paste
special to paste link to excel workbook.

Luck
Jonathan

 

[Kurt]

There is a powerpoint add-on that enables you to link powerpoint
presentations directly to your ms access database (or any other database)
for live graphs without coding; www.take-off.as/datapoint
Good luck
Kurt