Microsoft Excel

Creating a Standalone Chart

You have two options for placing charts in a workbook. You can create an embedded chart, which appears in an existing worksheet (usually next to the appropriate data), or you can create a standalone chart, which appears in a new worksheet of its own.

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:

  1. 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.
  2. Choose "New sheet", and then enter the name for the new worksheet.
  3. Click OK.

Move Chart in Excel 2007

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.