Formatting chart appearance in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to set the chart title to "Sales Data".

Excel

ActiveChart.ChartTitle.Text = [1]

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

A'Sales Data'

BSales Data

C"Sales Data"

DSalesData

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to use quotes around the title text.

Using single quotes instead of double quotes.

The chart title text must be a string enclosed in double quotes in VBA.

2fill in blank

medium

Complete the code to change the chart's background color to light blue using RGB values.

Excel

ActiveChart.ChartArea.Format.Fill.ForeColor.RGB = [1]

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

ARGB(173, 216, 230)

BRGB(0, 0, 255)

CRGB(255, 255, 255)

DRGB(0, 255, 0)

Attempts:

3 left

💡 Hint

Common Mistakes

Using pure blue instead of light blue.

Using incorrect RGB values.

RGB(173, 216, 230) is the light blue color.

3fill in blank

hard

Fix the error in the code to set the chart legend position to the bottom.

Excel

ActiveChart.Legend.Position = [1]

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

ABottom

BLegendBottom

CxlBottom

DxlLegendPositionBottom

Attempts:

3 left

💡 Hint

Common Mistakes

Using a string instead of the VBA constant.

Using an incorrect constant name.

The correct constant for legend position at bottom is xlLegendPositionBottom.

4fill in blank

hard

Fill both blanks to set the chart's X-axis title to "Month" and make it bold.

Excel

With ActiveChart.Axes(xlCategory).AxisTitle
    .Text = [1]
    .Font.[2] = True
End With

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

A"Month"

BBold

CItalic

D"Year"

Attempts:

3 left

💡 Hint

Common Mistakes

Using Italic instead of Bold.

Setting the text without quotes.

The axis title text must be "Month" and the font property to make text bold is Bold.

5fill in blank

hard

Fill all three blanks to format the first data series as a dashed red line with weight 2.

Excel

With ActiveChart.SeriesCollection(1).Format.Line
    .DashStyle = [1]
    .Weight = [2]
    .ForeColor.RGB = [3]
End With

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

AmsoLineDash

B2

CRGB(255, 0, 0)

DmsoLineSolid

Attempts:

3 left

💡 Hint

Common Mistakes

Using msoLineSolid instead of msoLineDash.

Incorrect RGB values for red.

Wrong units or values for line weight.

DashStyle uses msoLineDash for dashed line, Weight is set to 2 points, and ForeColor.RGB uses RGB(255, 0, 0) for red.