Copying Excel 2007 Charts to Word

C

Calvin

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

Calvin

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
Embed the same Excel multiple times 0
Move Chart with Text 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Paste options button disappears 0
Save a custom chart as a template 0
No indication that copied chart is on the clipboard 2
I have lost 6 months work, how can i get my file back 1

Top