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