The advance report currently made manually, make chart in excel, then copy it in word by hand, add adequate data, put it in nice layout, and print it. My project is to generate an advance report automatically, just push a few button, and the report is ready to be printed.
My progress so far, I had a code to generate chart(s) and put it in new workbook .why not in the same workbook Because I want to separate the program and the result, so that the user can save all charts in one file that contains only charts and data.
Next, I want to copy all charts that were created and paste it in such a way that the user can print it (later) in a desirable layout (i.e. 2 charts each page with sufficient comment).
- Is it better to paste all charts in word I’ve found a few code examples, but it’s quite complicated to make.
- Or I might copy and paste all charts just in another sheet in the same workbook as the charts => So there will be one sheet with all charts. And I try already to copy all exist chart and pasted it as a picture in new sheet in the same workbook.
copy chart from excel to word
Vi
Make the charts in Excel. You can write a macro that will copy each chart, as a picture, and paste it into the appropriate place in the Word report. This is easier if the Word report contains bookmarks as placeholders for the charts.
There is some information about doing this on this web page:
http://peltiertech.com/Excel/XL_PPT.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______