Copying Excel 2007 Charts to Word

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?
 
G

Guest

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.
 
M

Mike Middleton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying embedded charts 1
Copying Excel 2007 Charts as picture (as seen on screen) 1
I'm loosing colour when copying charts from excel to word. 1
copying charts into MS Word 1
Text spacing uneven when copying charts from EXCEL 2007 to WORD 20 4
Excel 2007 - copying charts to Word problem 8
Overlay charts in 2007 2
Charts change colour in 2003 2

Top