Moving and resizing charts in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

🎯 Scenario

intermediate

Move a chart to a new worksheet

You have a chart embedded in Sheet1. You want to move it to a new chart sheet named "SalesChart". Which Excel action or method will do this correctly?

A Right-click the chart, select 'Move Chart...', then choose 'New sheet' and enter 'SalesChart'.

B Cut the chart, create a new worksheet named 'SalesChart', then paste the chart there.

C Drag the chart tab to a new position and rename it to 'SalesChart'.

D Copy the chart, insert a new worksheet named 'SalesChart', then paste the chart as a picture.

💡 Hint

Look for the built-in option to move charts to a new sheet.

The 'Move Chart...' option allows moving a chart to a new chart sheet with a specified name. Cutting and pasting to a worksheet does not create a chart sheet. Dragging tabs moves worksheets, not charts. Pasting as a picture loses chart functionality.

📊 Formula Result

intermediate

Resize a chart using VBA code

You run this VBA code to resize a chart named 'Chart 1' on Sheet1: Sub ResizeChart() Worksheets("Sheet1").ChartObjects("Chart 1").Width = 400 Worksheets("Sheet1").ChartObjects("Chart 1").Height = 300 End Sub What will be the width and height of the chart after running this code?

Excel

Sub ResizeChart()
  Worksheets("Sheet1").ChartObjects("Chart 1").Width = 400
  Worksheets("Sheet1").ChartObjects("Chart 1").Height = 300
End Sub

A Width and Height remain unchanged

B Width = 300 points, Height = 400 points

C Width = 400 points, Height = 300 points

D Code causes a runtime error because of wrong chart name

💡 Hint

Width and Height properties set the size in points.

The code sets the Width property to 400 points and Height to 300 points for the chart named 'Chart 1'. This changes the chart size accordingly.

❓ Function Choice

advanced

Which VBA property moves a chart?

You want to move a chart object named 'SalesChart' on Sheet2 to the left by 50 points and down by 30 points using VBA. Which property should you modify?

A Modify the .Left and .Top properties of the ChartObject

B Modify the .Width and .Height properties of the ChartObject

C Modify the .Location property of the ChartObject

D Modify the .Position property of the ChartObject

💡 Hint

Think about properties that control position on the sheet.

The .Left and .Top properties control the horizontal and vertical position of the chart on the worksheet. Width and Height control size. There is no .Position or .Location property for ChartObjects.

📊 Formula Result

advanced

Effect of resizing chart with negative values

What happens if you run this VBA code? Sub ResizeNegative() Worksheets("Sheet1").ChartObjects("Chart 1").Width = -100 Worksheets("Sheet1").ChartObjects("Chart 1").Height = -50 End Sub

Excel

Sub ResizeNegative()
  Worksheets("Sheet1").ChartObjects("Chart 1").Width = -100
  Worksheets("Sheet1").ChartObjects("Chart 1").Height = -50
End Sub

A Chart size becomes zero width and height

B Chart resizes to 100 width and 50 height (absolute values)

C Chart size remains unchanged

D Runtime error: Invalid property value

💡 Hint

Width and Height cannot be negative numbers.

Setting Width or Height to negative values causes a runtime error because these properties must be positive numbers.

❓ data_analysis

expert

Analyze chart position after multiple moves

A chart on Sheet3 has initial .Left = 100 and .Top = 150. You run this VBA code: With Worksheets("Sheet3").ChartObjects("Chart 1") .Left = .Left + 50 .Top = .Top - 20 .Left = .Left - 30 .Top = .Top + 10 End With What are the final .Left and .Top values of the chart?

Excel

With Worksheets("Sheet3").ChartObjects("Chart 1")
  .Left = .Left + 50
  .Top = .Top - 20
  .Left = .Left - 30
  .Top = .Top + 10
End With

A .Left = 150, .Top = 140

B .Left = 120, .Top = 140

C .Left = 120, .Top = 160

D .Left = 150, .Top = 160

💡 Hint

Add and subtract the changes step by step.

Initial Left=100, add 50 → 150, subtract 30 → 120. Initial Top=150, subtract 20 → 130, add 10 → 140.