I have created some interesting pivot 'scatter' charts in Access. Unfortunately, my audience likes to see Powerpoint-formatted information, and do not want to use Access.
I have tried exporting the tables to Excel with a view to linking them to ppt: scatter charts cannot be created from pivot tables in Excel! I have resorted to copy/pasting screenshots of the Access charts into Powerpoint, but this reduces the space available for a chart, and the image is not as clear as I would like.
Does anyone have any VBA or other tips to be able to do this? I am willing to use Excel as an intermediate step, if need be. Thanks for your suggestions.
I have tried exporting the tables to Excel with a view to linking them to ppt: scatter charts cannot be created from pivot tables in Excel! I have resorted to copy/pasting screenshots of the Access charts into Powerpoint, but this reduces the space available for a chart, and the image is not as clear as I would like.
Does anyone have any VBA or other tips to be able to do this? I am willing to use Excel as an intermediate step, if need be. Thanks for your suggestions.
