Moving and resizing charts in Excel - Cell-by-Cell Formula Trace

Sample Data

Monthly sales data for three months used to create a chart.

Cell	Value
A1	Month
B1	Sales
A2	Jan
B2	100
A3	Feb
B3	150
A4	Mar
B4	120

Formula Trace

N/A (Moving and resizing charts is done by mouse or VBA, not formulas)

Step 1: Select the chart by clicking on it

Step 2: Drag the chart border to move it

Step 3: Drag the handles on chart corners or edges to resize

Cell Reference Map

   A      B
1 Month  Sales
2 Jan    100
3 Feb    150
4 Mar    120

[Chart linked to A1:B4 data]

The chart is linked to the data in cells A1:B4.

Result

   A      B
1 Month  Sales
2 Jan    100
3 Feb    150
4 Mar    120

[Chart shown here, moved and resized by user]

The chart displays sales data and can be moved or resized by dragging.

Sheet Trace Quiz - 3 Questions

How do you select a chart to move or resize it?

A Right-click on a cell

B Double-click on a cell

C Click on the chart once

D Press Enter on a cell

Key Result

N/A - Moving and resizing charts is done by mouse actions or VBA, not formulas.