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.