Moving an embedded chart onto its own chart sheet in Excel 2007

Although Excel automatically embeds all new charts on the same worksheet as the data they graph (unless you create using the F11 trick), you may find it easier to customize and work with it if you move the chart to its own chart sheet in the workbook. To move an embedded chart to its own chart sheet in the workbook, follow these steps:

1. Click the Move Chart button on the Design tab under the Chart Tools Contextual tab to open the Move Chart dialog box.

If the Chart Tools Contextual tab doesn’t appear at the end of your Ribbon, click anywhere on the new chart to select the chart and make this tab appear.

2. Click the New Sheet option button in the Move Chart dialog box.

3. (Optional) Rename the generic Chart1 sheet name in the accompanying text box by entering a more descriptive name.

4. Click OK to close the Move Chart dialog box and open the new chart sheet with your pivot chart.

If, after customizing the chart on its own sheet, you decide you want the finished chart to appear on the same worksheet as the data it represents, click the Move Chart button on the Design tab again and this time click the Object In option button and then select the name of the worksheet in its associated drop-down list box before you click OK.

Tags: chart,worksheet,workbook

Related Articles