How to Put a Graph in Excel Into a Different Sheet
- 1). Click anywhere on the chart to display the chart tools.
- 2). Choose the "Design" tab.
- 3). Click "Move Chart" in the location group. The "Move Chart" dialog box will appear.
- 4). Select "New Sheet" and enter a name for the new worksheet, if that sheet does not exist yet. Otherwise, select "Object In" and choose the name of the worksheet for the move from the dropdown.
- 5). Click the "OK" button to close the "Move Chart" dialog box and move the chart.
- 6). Click the tab of the worksheet to which the chart moved. You can move the chart to a new area within that worksheet by clicking it and dragging it to a new location.
Source...