en uk

Moving a chart to a new sheet Microsoft Excel 2007

    Rather than move a chart on the same sheet where it appears, you can also move the chart to another worksheet. That way your data can appear on one worksheet, and your chart can appear on another.

    To move a chart to an entirely different sheet, follow these steps:

    1. Click the chart you want to move to another worksheet.

    The Chart Tools tab appears.

    2. Click the Design contextual tools tab.

    3. Click the Move Chart icon in the Location group.

    The Move Chart dialog box appears, as shown in Figure 9-5.

    Moving a chart to
a new sheet Microsoft Excel 2007

    Figure 9-5:

    Specify a worksheet where you want to move your chart.

    As an alternative to Steps 1-3, you can right-click a chart; then, when the pop-up menu appears, choose Move Chart.

    4. Select one of the following radio buttons:

    New Sheet: Creates a new worksheet and lets you name it

    Object In: Lets you choose the name of an existing worksheet

    5. Click OK.

    Excel moves your chart.


Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.