I would like to rework Excel Charts as simple shapes as can be created by hand in Word.
The only options to paste a chart to Word seems to be by embedding and linking, and they remain Excel objects.
Instead, I would like them to be editable graphics made of individual shapes. I don't want to retain the original relation to Excel data.
Any hint ?
Update:
I found the menu entry Paste special…, which supplies different As picture options and As a Microsoft Office Object (with the comment Inserts the contents of the Clipboard as shapes). Much to my disappointment, the latter still inserts as an non-editable Excel chart.
The option Picture (enhanced metafile) does what I want, though the graphical quality seems degraded, and most of the grouping is lost.
Could there be yet another way ?
21 Answer
The best way to insert an editable chart is using Insert > Chart feature directly. You can pick up a chart type and modify chart data in Word instead of using external data sources / links. You can also format the chart using build-in options in Word.
If you have created a Excel Chart, I think you can copy the data source of chart and paste it into Word's Excel chart editor, then format the chart as you want.
For more information, read Add a chart to your document in Word and Insert a chart from an Excel spreadsheet into Word.
1