Adjust the Chart Location

1. Click anywhere on the chart that you want to move.
2. On the Design tab, choose Location => Move Chart. The Move Chart dialog box appears.
   
   
   
   
   
   
3. Select a location:
   
   New sheet:
   Creates a new worksheet and places the chart on the sheet.
   
   Object in:
   Moves the chart to an existing sheet in the workbook. Click the drop-down arrow to select the worksheet to which you want to move the chart.
   
   
4. Click OK. Your chart is moved to the location you have specified.

To move the chart to a different location on the current worksheet, position the mouse over the edge of the chart and drag it to a new location.