Moving and resizing charts in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select a chart named "SalesChart" in Excel VBA.

Excel

ActiveSheet.ChartObjects("[1]").Select

Drag options to blanks, or click blank then click option'

AProfitChart

BRevenueChart

CSalesChart

DExpenseChart

Attempts:

3 left

💡 Hint

Common Mistakes

Using a wrong chart name.

Forgetting to put the chart name in quotes.

Using Sheets instead of Charts.

The chart named "SalesChart" is selected by using ActiveSheet.ChartObjects("SalesChart").Select.

2fill in blank

medium

Complete the code to move the selected chart to the left by 50 points.

Excel

ActiveChart.Parent.[1] = ActiveChart.Parent.Left - 50

Drag options to blanks, or click blank then click option'

ATop

BLeft

CHeight

DWidth

Attempts:

3 left

💡 Hint

Common Mistakes

Using Top instead of Left for horizontal movement.

Adding instead of subtracting to move left.

Trying to set position without selecting the chart.

To move a chart left, adjust its Left property by subtracting points.

3fill in blank

hard

Fix the error in the code to resize the chart's height to 300 points.

Excel

ActiveChart.Parent.[1] = 300

Drag options to blanks, or click blank then click option'

AHeight

BWidth

CLeft

DTop

Attempts:

3 left

💡 Hint

Common Mistakes

Using Width instead of Height.

Trying to set position properties instead of size.

Not selecting the chart before resizing.

The Height property sets the vertical size of the chart.

4fill in blank

hard

Fill both blanks to move the chart 20 points down and increase its width by 100 points.

Excel

ActiveChart.Parent.[1] = ActiveChart.Parent.Top + 20
ActiveChart.Parent.[2] = ActiveChart.Parent.Width + 100

Drag options to blanks, or click blank then click option'

ATop

BLeft

CWidth

DHeight

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up Top and Left properties.

Using Height instead of Width for resizing width.

Subtracting instead of adding values.

Top controls vertical position, Width controls horizontal size.

5fill in blank

hard

Fill all three blanks to select a chart named "ProfitChart", move it 30 points right, and set its height to 250 points.

Excel

ActiveSheet.ChartObjects("[1]").Select
ActiveChart.Parent.[2] = ActiveChart.Parent.Left + 30
ActiveChart.Parent.[3] = 250

Drag options to blanks, or click blank then click option'

AProfitChart

BLeft

CHeight

DSalesChart

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong chart name.

Mixing up Left and Top properties.

Setting Width instead of Height.

Select the chart by name, then adjust Left to move right and Height to resize vertically.