Copying Excel 2007 Charts to Word
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? |
Copying Excel 2007 Charts to Word
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. |
Copying Excel 2007 Charts to Word
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 "Calvin" wrote in message ... 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. |
All times are GMT +1. The time now is 08:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com