Formatting chart appearance in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

Change Chart Title Text Color

You have a chart with the title in cell A1. Which formula or method will change the chart title text color to red using Excel VBA?

Excel

Sub ChangeTitleColor()
    ActiveChart.ChartTitle.Font.Color = RGB(255, 0, 0)
End Sub

A ActiveChart.ChartTitle.Font.Color = "Red"

B ActiveChart.ChartTitle.Font.Color = #FF0000

C ActiveChart.ChartTitle.Font.Color = Color.Red

D ActiveChart.ChartTitle.Font.Color = RGB(255, 0, 0)

💡 Hint

Use the RGB function to specify colors in VBA.

In Excel VBA, the RGB function is used to set colors by specifying red, green, and blue values. The correct way to set the chart title color to red is using RGB(255, 0, 0).

❓ Function Choice

intermediate

Select the Correct Method to Change Chart Background Color

Which VBA property correctly changes the background color of an Excel chart area to light blue?

A ActiveChart.ChartArea.BackgroundColor = RGB(173, 216, 230)

B ActiveChart.ChartArea.Format.Fill.ForeColor.RGB = RGB(173, 216, 230)

C ActiveChart.Fill.ForeColor = RGB(173, 216, 230)

D ActiveChart.PlotArea.Fill.Color = RGB(173, 216, 230)

💡 Hint

The ChartArea's Format.Fill.ForeColor property controls the background color.

The ChartArea.Format.Fill.ForeColor.RGB property sets the background color of the entire chart area. Other options either use incorrect properties or do not exist.

🎯 Scenario

advanced

Apply Gradient Fill to Chart Plot Area

You want to apply a vertical gradient fill from white to green on the plot area of a chart using VBA. Which code snippet will achieve this?

A

With ActiveChart.PlotArea.Format.Fill
    .Visible = msoTrue
    .ForeColor.RGB = RGB(255, 255, 255)
    .BackColor.RGB = RGB(0, 128, 0)
    .TwoColorGradient msoGradientVertical, 1
End With

B

ActiveChart.PlotArea.Fill.GradientStyle = msoGradientVertical
ActiveChart.PlotArea.Fill.ForeColor.RGB = RGB(255, 255, 255)
ActiveChart.PlotArea.Fill.BackColor.RGB = RGB(0, 128, 0)

C

ActiveChart.PlotArea.Format.Fill.GradientStyle = msoGradientHorizontal
ActiveChart.PlotArea.Format.Fill.ForeColor.RGB = RGB(255, 255, 255)
ActiveChart.PlotArea.Format.Fill.BackColor.RGB = RGB(0, 128, 0)

D

With ActiveChart.PlotArea.Fill
    .Visible = True
    .ForeColor.RGB = RGB(0, 128, 0)
    .BackColor.RGB = RGB(255, 255, 255)
    .TwoColorGradient msoGradientVertical, 1
End With

💡 Hint

Use the Format.Fill object and the TwoColorGradient method with vertical style.

The TwoColorGradient method applies a gradient fill. Setting ForeColor to white and BackColor to green with msoGradientVertical creates a vertical gradient from white to green.

❓ data_analysis

advanced

Identify the Effect of Chart Legend Position Code

What will be the position of the chart legend after running this VBA code? ActiveChart.Legend.Position = xlLegendPositionBottom

A The legend will appear below the chart.

B The legend will appear to the right of the chart.

C The legend will appear above the chart.

D The legend will be hidden.

💡 Hint

The constant xlLegendPositionBottom places the legend at the bottom.

The xlLegendPositionBottom constant moves the legend below the chart area, making option A correct.

🧠 Conceptual

expert

Understanding Chart Axis Formatting Impact

If you run the following VBA code on a chart, what will be the visible effect on the horizontal axis? With ActiveChart.Axes(xlCategory) .MajorTickMark = xlTickMarkNone .TickLabelPosition = xlTickLabelPositionNone End With

A The horizontal axis will show labels but no tick marks.

B The horizontal axis will show tick marks but no labels.

C The horizontal axis will show no tick marks and no labels.

D The horizontal axis will remain unchanged.

💡 Hint

Both MajorTickMark and TickLabelPosition control the visibility of ticks and labels.

Setting MajorTickMark to xlTickMarkNone removes tick marks, and setting TickLabelPosition to xlTickLabelPositionNone hides the labels. So, the axis will have neither ticks nor labels visible.