Bird
Raised Fist0
Excelspreadsheet~15 mins

Moving and resizing charts in Excel - Real Business Scenario

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Scenario Mode
👤 Your Role: You are a sales analyst at a retail company.
📋 Request: Your manager wants a clear sales performance chart on the monthly report sheet. The chart must be moved to a specific location and resized to fit neatly without overlapping other data.
📊 Data: You have monthly sales data for four products from January to June in a table format.
🎯 Deliverable: A column chart showing monthly sales for all products, moved to the top right corner of the report sheet and resized to 600 pixels wide and 400 pixels tall.
Progress0 / 4 steps
Sample Data
MonthProduct AProduct BProduct CProduct D
Jan120150100130
Feb135160110140
Mar150170120150
Apr160180130160
May170190140170
Jun180200150180
1
Step 1: Select the data range including headers and months (A1:E7).
Select cells A1 to E7.
Expected Result
Data range selected for chart creation.
2
Step 2: Insert a column chart based on the selected data.
Go to Insert tab > Charts group > Insert Column or Bar Chart > Clustered Column.
Expected Result
A column chart appears on the sheet showing monthly sales for all products.
3
Step 3: Move the chart to the top right corner of the sheet.
Click and drag the chart to position it starting near cell G1.
Expected Result
Chart is positioned at the top right corner without overlapping the data table.
4
Step 4: Resize the chart to be 600 pixels wide and 400 pixels tall.
Click the chart, then drag the edges or use Format Chart Area > Size options to set Width=600 px and Height=400 px.
Expected Result
Chart size is adjusted to 600x400 pixels, fitting neatly in the designated area.
Final Result
Monthly Sales Report

+---------------------------------------------+
|                                             |
|           [Column Chart: Sales]              |
|                                             |
|                                             |
|                                             |
|                                             |
|                                             |
+---------------------------------------------+

Data Table:
Month | Product A | Product B | Product C | Product D
-----------------------------------------------------
Jan   | 120       | 150       | 100       | 130
Feb   | 135       | 160       | 110       | 140
Mar   | 150       | 170       | 120       | 150
Apr   | 160       | 180       | 130       | 160
May   | 170       | 190       | 140       | 170
Jun   | 180       | 200       | 150       | 180
Bonus Challenge

Add data labels to each column in the chart to show exact sales numbers.

Show Hint
Select the chart, go to Chart Elements (plus icon), check Data Labels, and choose the position 'Outside End'.

Practice

(1/5)
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