Ordinarily, when you pick a chart type from the ribbon, Excel creates an embedded chart. However, you can easily switch your chart over to a new worksheet if you're running out of roomjust follow these steps:
- Right-click the chart, and then choose Move Chart (or, select the chart, and then choose Chart Tools : Design > Location > Move Chart). The Move Chart dialog box appears.
- Choose "New sheet", and then enter the name for the new worksheet.
- Click OK.
Excel creates the new worksheet and places the chart on it. The new worksheet goes in front of the worksheet that contains the chart data. (You can always move the worksheet to a new position in your workbook by dragging the worksheet tab.)
Tip: You can move or resize only embedded chartsthe ones that appear in floating boxes inside other worksheets. If you've created a standalone chart, you can't move or resize it. Instead, it automatically shrinks or enlarges itself to match the Excel window's display area.