Microsoft Excel: Change A Chart From A Chart Sheet To An Embedded Chart

Problem: You created a chart with the F11 key. You need this chart to be an embedded chart. How can you change the location of the chart?

See all Microsoft Excel tips

Strategy:1) Right-click the chart. Choose Location, as shown in Fig. 1067.

2) As shown in Fig. 1068, in the Chart Location dialog, choose a new location.

Gotcha: When you move a chart from a chart sheet to an embedded object, the size and scale of the chart changes, as shown in Fig. 1069. It is best to move the chart to its final location before customizing it.

Summary: You can move an embedded chart to its own chart sheet or back to an embedded chart by right-clicking and choosing the Location option.

Commands Discussed: Chart – Chart Location

See all Microsoft Excel tips

Images