Combo charts in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select the chart type for a combo chart in Excel VBA.

Excel

chart.ChartType = xl[1]

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

AColumnClustered

BPie

CCombo

DLine

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-existent chart type 'xlCombo'.

Choosing Pie chart type which is unrelated to combo charts.

In Excel VBA, to create a combo chart, you set the ChartType property to xlColumnClustered for the main chart type, then set individual series types. There is no xlCombo chart type.

2fill in blank

medium

Complete the code to add a secondary axis to the second series in a combo chart.

Excel

chart.SeriesCollection(2).[1] = True

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

APlotOnSecondaryAxis

BAxisGroup

CHasLegend

DHasDataLabels

Attempts:

3 left

💡 Hint

Common Mistakes

Using AxisGroup which is an enum, not a boolean property.

Confusing HasDataLabels with axis settings.

To plot a series on the secondary axis in Excel VBA, set PlotOnSecondaryAxis to True.

3fill in blank

hard

Fix the error in the code to set the chart type of the first series in a combo chart.

Excel

chart.SeriesCollection(1).ChartType = xl[1]

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

ALine

BScatter

CColumnClustered

DPie

Attempts:

3 left

💡 Hint

Common Mistakes

Using Pie chart type which is not suitable for combo charts.

Using Scatter which is less common for first series.

The first series in a combo chart is often a clustered column. Setting ChartType to xlColumnClustered is correct.

4fill in blank

hard

Fill both blanks to set the second series to a line chart and plot it on the secondary axis.

Excel

chart.SeriesCollection(2).ChartType = xl[1]
chart.SeriesCollection(2).[2] = True

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

ALine

BHasDataLabels

CPlotOnSecondaryAxis

DColumnClustered

Attempts:

3 left

💡 Hint

Common Mistakes

Setting the wrong chart type for the second series.

Not setting the series to plot on the secondary axis.

The second series is set to a line chart with xlLine and plotted on the secondary axis by setting PlotOnSecondaryAxis to True.

5fill in blank

hard

Fill all three blanks to create a combo chart with the first series as clustered column, and plot the second on the secondary axis.

Excel

chart.ChartType = xl[1]
chart.SeriesCollection(1).ChartType = xl[2]
chart.SeriesCollection(2).[3] = True

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

ACombo

BColumnClustered

CPlotOnSecondaryAxis

DLine

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up chart types for series.

Forgetting to set the secondary axis property.

Set the chart type to xlCombo, first series to xlColumnClustered, and plot the second series on the secondary axis by setting PlotOnSecondaryAxis to True.