Adjust the Chart Location
- Click anywhere on the chart that you want to move.
- On the Design tab, choose Location> Move Chart. The Move Chart dialog box appears.
- 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. - 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.
In this tutorial:
- Creating Charts in Excel 2007
- What is a Chart?
- Creating Basic Charts
- Formatting a Chart Element
- Insert Chart
- Chart Styles
- Adjust the Chart Location
- Display a Chart Title
- Displaying a Data Table in a Chart
- Change Axis Options
- Enhance a 3-D Chart
- Adjust Chart Data
- Creating and Using a Chart Template
- Working with Excel Charts
- Excel Charts Tips