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.
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.