Copying Excel 2007 Charts to Word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cannot copy a pivotchart to Word. When creating the chart it can copy to
Word OK but after changing the colours and data labels it does not show on
the clipboard at all.

Any suggestions?
 
This has something to do with the datalabels.
IF I simply add the standard data labels it copies OK. The issue is creating
non-standard labels using a macro. If I create labels using thism, the chart
no longer copies to the clipboard.
 
Calvin -

You didn't mention which method you are using for copying the chart.

Consider this method:

Select the chart by clicking just inside its outer border.

In Excel 2007 choose Home | Paste | As Picture | Copy As Picture | OK.

In Word 2007, choose Home | Paste.

- Mike
http://www.mikemiddleton.com
 
Back
Top