Export Access Chart report to Excel

[Wayne]

In reports I created a simple bar graph. I would like to export that to
Excel. When I do that, the new Excel file created is empty. When I send a
normal (non-graph) out to Excel all data is contained, it is just the graphs
that do not work. Any guidence would be appreciated. Thank you in advance

 

[Klatuu]

The graph objects in Excel and Access are not the same. It will not export
correctly if at all. You alternative is doable, but extreme and required
good VBA skills and an understanding of the Excel object model. That is to
use automation to create a graph in an Excel Application object.

 

[Wayne]

Are there plans from Microsoft to better integrate Access charting with
PowerPoint and Excel other than going through the process of creating VBA
code? I have intermediate VBA knowledge and this is not something I care to
tackle. Using the Export tool from Access would really save a lot of time in
presentation preparation. Is there any reason why this has not been
devoloped by MS?

 

[Klatuu]

You would have to ask someone from MicroSoft about that.
What I can say is the Access reports are designed to be printed, not
exported to an Excel spreadsheet. You will probably notice that even text
reports exported to Excel don't look very good.
The Access and Excel object models are very different. It would take some
very sophisticated code to convert an Access graph to an Excel graph, but
even then, since it is coming from a report, what it has is only a visual
representation of the underlying data, not the data necessary to create a
graph.

 

[Wayne]

Thank you for the insight. It appears as though the Access graph uses MS
Graph as the engine for chart production. It would appear as though
sonverting to PPT or XL shouldn;t be that bad, but then again, I'm not a
software designer so I really don;t know. Thank you again.

 

[Urban Planning Major]

Wow. I have the same problem with transferring reports to PowerPoint. So if I
cant do report transferring to PowerPoint how about my forms. Can i export or
publish a form to PowerPoint? I wonder?? Do I have to switch to SPSS for more
problems that access can’t tackle!!?