copy chart from excel to word

Hi guys...i'm quite new to macro programming and need some help here. I have created a macro button on my spreadsheet to copy all the charts in my spreadsheet to a new microsoft word file.

the problem i have is when the charts are copied to the microsoft word file, all the charts are "joined" together as a single image. how do i paste those charts as individual image on microsoft word?

and also, let say if i have 1 of the charts on my spreadsheet which have no trendline/data, i don't want it to be pasted on the microsoft word. how do i do it?(meaning if i click on the macro button, only charts with trendline will be copied to the microsoft word)

below are my code..and also the sample excel file

Please Login or Register  to view this content.

haaa.xlsm

Originally Posted by Kaper

As for first part of question:

Please Login or Register  to view this content.

The second is less obvious - in attached file there is no such chart. Assuming you really ment trendline you may use:

Please Login or Register  to view this content.

Thanks so much for the help Kaper. The first script works like charm!

However for the 2nd script, when i tried to run it, it only opens the microsoft word file & nothing happened. i tried to remove the data on the 2nd chart (the "score" chart) and click on the button, but nothing happen as well.

Thanks again Kaper...really appreciate your help..problem solved

Hi Kaper, i realised that if the data & the charts are on the sheet, the script works fine..however, when the charts & data are on different sheet, the script wont work..is there any solution for that?

i'm using the below script...

Please Login or Register  to view this content.

ok...tested...working fine