Moving and resizing charts in Excel - Step-by-Step Guide

Introduction

Charts help you show data visually. Sometimes you need to move a chart to a better spot or make it bigger or smaller to fit your worksheet nicely.

When your chart covers important data and you want to move it aside

When you want to place a chart next to related data for easy comparison

When your chart is too small to read and needs to be bigger

When your chart is too large and hides other information

When you want to organize multiple charts neatly on one sheet

Steps

Step 1: Click

- the chart border

The chart is selected and shows a border with small circles (handles) around it

Step 2: Drag

- the chart border

The chart moves as you drag it to a new position on the worksheet

💡 Hold the Shift key while dragging to keep the chart aligned horizontally or vertically

Step 3: Click and drag

- any of the small circles (handles) on the chart border

The chart resizes bigger or smaller depending on the direction you drag

💡 Drag corner handles to resize proportionally; drag side handles to resize width or height only

Step 4: Release

- mouse button after dragging

The chart stays in the new position or size you set

Before vs After

Before

Chart is placed overlapping data in the middle of the worksheet and is small, making it hard to read

After

Chart is moved to the top right corner and resized larger to clearly show all details without covering data

Settings Reference

Chart border handles

📍 Visible when chart is selected

Used to resize the chart by dragging

Default: Visible when chart is selected

Chart selection border

📍 Around the chart when selected

Shows the chart is selected and ready to move or resize

Default: Visible when chart is selected

Common Mistakes

Trying to move the chart by clicking inside the chart area (like on bars or lines)

Clicking inside the chart selects chart elements, not the whole chart, so it won't move

Click on the chart border to select the whole chart before moving

Dragging side handles when you want to keep the chart's shape

Dragging side handles changes only width or height, which can distort the chart

Drag corner handles to resize the chart proportionally

Summary

You can move a chart by clicking and dragging its border to a new spot on the worksheet

Resize a chart by dragging the small circles (handles) on its border; corner handles keep shape proportional

Always select the chart border to move or resize, not the chart elements inside