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

Practice

1. What happens when you click and drag the border of a chart in Excel?

easy

A. The chart deletes automatically.

B. The chart resizes proportionally.

C. The chart moves to a new location on the sheet.

D. The chart changes its data source.

Solution

1. Step 1: Understand chart border dragging

   Clicking and dragging the border of a chart moves it around the sheet without changing its size.

2. Step 2: Differentiate from resizing

   Resizing happens when dragging corner or edge handles, not the border itself.

3. Final Answer:

   The chart moves to a new location on the sheet. -> Option C

4. Quick Check:

   Dragging border = move chart [OK]

Hint: Drag chart border to move it anywhere on the sheet [OK]

Common Mistakes:

• Confusing dragging border with resizing handles
• Thinking dragging border deletes the chart
• Assuming dragging border changes data

2. Which action correctly resizes a chart in Excel while keeping its proportions?

easy

A. Drag a corner handle while holding Shift key.

B. Click the chart and press arrow keys.

C. Drag an edge handle without any key.

D. Drag the chart border while holding Shift key.

Solution

1. Step 1: Identify resizing with proportion

   Holding the Shift key while dragging a corner handle keeps the chart's proportions.

2. Step 2: Differentiate from other actions

   Dragging border moves chart; edge handles resize but may distort; arrow keys move chart slightly.

3. Final Answer:

   Drag a corner handle while holding Shift key. -> Option A

4. Quick Check:

   Shift + corner drag = proportional resize [OK]

Hint: Hold Shift and drag corner handle to resize proportionally [OK]

Common Mistakes:

• Dragging border instead of handles to resize
• Not holding Shift and distorting chart
• Using edge handles for proportional resize

3. You have a chart selected in Excel. You press the right arrow key three times. What happens to the chart?

medium

A. The chart resizes wider by three units.

B. The chart moves three small steps to the right.

C. The chart rotates clockwise three times.

D. The chart's data updates to the right column.

Solution

1. Step 1: Understand arrow key effect on chart

   Pressing arrow keys moves the selected chart slightly in the arrow's direction.

2. Step 2: Confirm no resizing or rotation

   Arrow keys do not resize or rotate charts; they only move them.

3. Final Answer:

   The chart moves three small steps to the right. -> Option B

4. Quick Check:

   Arrow keys = move chart [OK]

Hint: Use arrow keys to nudge chart position in small steps [OK]

Common Mistakes:

• Thinking arrow keys resize or rotate chart
• Assuming arrow keys change chart data
• Confusing movement with resizing

4. You try to resize a chart by dragging its edge handle while holding the Shift key, but the chart distorts instead of keeping proportions. What is the likely mistake?

medium

A. You dragged an edge handle instead of a corner handle.

B. You did not select the chart before resizing.

C. You pressed arrow keys instead of dragging.

D. You dragged the chart border instead of handles.

Solution

1. Step 1: Identify correct handle for proportional resize

   Only dragging a corner handle with Shift keeps proportions; edge handles distort.

2. Step 2: Exclude other mistakes

   Chart must be selected; arrow keys move, not resize; dragging border moves chart.

3. Final Answer:

   You dragged an edge handle instead of a corner handle. -> Option A

4. Quick Check:

   Shift + corner handle = proportional resize [OK]

Hint: Always drag corner handle with Shift for proportional resize [OK]

Common Mistakes:

• Dragging edge handle with Shift expecting proportional resize
• Not selecting chart before resizing
• Confusing dragging border with resizing

5. You want to move a chart exactly 5 cells to the right and 3 cells down using the keyboard. Which sequence of keys should you press?

hard

A. Drag the chart border 5 cells right and 3 cells down with mouse.

B. Hold Shift and drag the chart 5 cells right and 3 cells down.

C. Press the left arrow key 5 times, then the up arrow key 3 times.

D. Press the right arrow key 5 times, then the down arrow key 3 times.

Solution

1. Step 1: Understand keyboard movement of charts

   Pressing arrow keys moves the chart one small step per press in that direction.

2. Step 2: Apply correct sequence for desired move

   Press right arrow 5 times to move right 5 steps, then down arrow 3 times to move down 3 steps.

3. Final Answer:

   Press the right arrow key 5 times, then the down arrow key 3 times. -> Option D

4. Quick Check:

   Arrow keys move chart stepwise [OK]

Hint: Use arrow keys repeatedly to move chart precisely [OK]

Common Mistakes:

• Using mouse drag instead of keyboard for exact moves
• Holding Shift while dragging to move (Shift resizes proportionally)
• Pressing wrong arrow keys for direction