Place a chart on a worksheet or on its own chart sheet
- Click the chart that you want to move or change.
- On the Chart menu, click Location.
- To place the chart on a new chart sheet, click As new sheet, and then type a name for the new chart sheet in the As new sheet box.
To place the chart as an embedded object on a worksheet, click As object in, click a sheet name in the As object in box, and then click OK. Drag the embedded chart where you want it on the worksheet.