Shapes and text boxes in Excel cannot be exported as links to PowerPoint or Word. Therefore, a chart annotated with shapes or text boxes cannot be exported. This article explains how to work around this behaviour.
Problem Description
In the example below, a source text box and an image have been added to the bottom of the chart. If you wish to export them to PowerPoint along with your chart, you may find that it does not always work. That's because there are two kinds of shapes:
- Shapes in the chart
- Shapes on the chart
If the shape is in the chart, it will be included in the export. If not, it will be ignored. To check if the shape is in or on, simply try to move it outside the chart. If it moves outside, the shape is on and cannot be exported directly.
How to put shapes in the chart
For an existing shape, you can put it back in.
- Cut the shape
- Select the chart
- Paste
To create new shapes:
- Ensure that the chart is selected
- Click insert shape
- Draw the shape directly over the chart
Tip
If you need to export shapes which overlap the chart or simply several charts simultaneously, you can also export the cells behind (see this post).