CODEWITHSUNDEEP
ms-accesschartsexport
cLFlaVA
cLFlaVA

Reputation: 1498

Exporting MS Access Charts to Word/Excel

I am amazed and dumbfounded to find out that a report generated in Microsoft Access will not include the charts I generated when exporting to Excel, Word or any other technology.

Has anyone found a work-around for this? My user base needs to be able to copy/paste the generated reports (including graphics) into different status reports. Copying/pasting does not seem to be possible directly from the Access report.

Upvotes: 3

Views: 5865

Answers (5)

Oscar
Oscar

Reputation: 23

As a workaround I use a free screen capture utility for graphs generated in Access: get the graph on the screen, capture it, Paste or Paste Special into Word. Works well and fast, the only downside is losing resolution if you want the graph to be big (e.g. full page) in the Word document.

Upvotes: 0

Ian Armit
Ian Armit

Reputation: 673

I'm not sure about Access 2003 but in Access 2007 you go to the chart properties and set Enabled to Yes. Afterwards you can copy and paste the chart in Excel and/or Word.

Upvotes: 0

Sim
Sim

Reputation:

install CutePDF Writer (it's free), and it lets them print to a PDF

Upvotes: 0

Philippe Grondier
Philippe Grondier

Reputation: 11138

There is also something called snapshot, that can be further viewed by users and/or inserted in documents.

Upvotes: 0

bruceatk
bruceatk

Reputation: 5138

I would really need more info to help you (which version of Access, How are you generating the graph, etc.).

Have you tried the "Publish It to Microsoft Word" or "Analyze it with Microsoft Excel" options from Print Preview?

One option your users have is to Alt-PrintScreen and paste it.

What I typically do is have users install CutePDF Writer (it's free), and it lets them print to a PDF, which they then can send to whomever they want.

Upvotes: 1

Related Questions