Usually, you will have to adjust a chart after it is inserted to ensure it doesn’t cover up data on the worksheet. You can resize a chart, move it within the worksheet, or move it to another worksheet.
Move a Chart
- Click the chart to select it.
- Click the chart’s border and drag it to the new location.
Make sure the four-headed arrow is activated before clicking and dragging.
The chart is moved to where you dragged it.
Move Charts to a Chart Sheet
If you don’t want your chart on the same sheet as the data, you can move it to its own worksheet.
- Select the chart you want to move.
- Click the Move Chart button on the Design tab.
- Select New sheet.
- Type a name for the sheet.
- Click OK.
The chart is moved to its own worksheet.
Resize a Chart
Eight sizing handles appear along the chart edges once it is selected. Sizing handles are used to change the size of charts and other objects.
- Click the chart to select it.
- Click and drag the chart’s sizing handle.
Make sure the two-headed arrow is activated before clicking and dragging.
FREE Quick Reference
Click to DownloadFree to distribute with our compliments; we hope you will consider our paid training.
