Nicola has attended:
Access Advanced course
Pivot charts
Following attending the advanced course and looking at pivot charts, there doesn't appear to be a way to place the chart into another document i.e. Word - is there? We worked out we could use OneNote and then insert as a picture, but this seems a longer way of doing it than what should be required.
Any ideas would be welcome - thank you!
RE: Pivot charts
Hello Nicola,
Hope you enjoyed your Microsoft Access Advanced course with Best STL.
Thank you for your question regarding exporting PivotCharts to another Microsoft Office application.
This issue has always plagued users of Access. The route you have taken does work and of course you can always perform a 'Print Screen' action and then crop the area you don't need.
The lack of a simple way to do this in Access suggests to me that it may be possible to perform this action by creating some VBA code which can then be attached to a button on your quick access toolbar.
For now you will have to accept the ways outlined above and if I come across a solution at a later stage I will add to this post. Until then...
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
