copy chart from excel to word

Originally Posted by Kaper

As I wrote - in attached file there was no chart with trendline.To create trendline you need scatterplot.

ooh...i finally got what you mean now...

sorry, my bad ..i guess i didn't explain it clearly in my first post. i shoudn't use the word "trendline" ...perhaps should be "line" instead?..let me rephrase my sentence again..

for example, in my attached spreadsheet, there are 2 charts (Age & Score), lets say if the "Age" chart is showing the line and the "Score" chart doesn't show the line (as shown in the image below). If i click on the macro button, only the "Age" chart should be copied to microsoft word.

noScore.jpg


(i tried adding trendline to my chart and your 2nd script works . Exactly the concept i wanted, but how do i modify the script to capture "line" or "bar" etc instead of "trendline" ?)