Chart templates in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to save the current chart as a template.

Excel

ActiveChart.SaveChartTemplate "[1]"

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

ATemplate.docx

BMyChart.crtx

CChartTemplate.xlsx

DChart1

Attempts:

3 left

💡 Hint

Common Mistakes

Using a file extension other than .crtx

Not including any file extension

Using a document or workbook extension

You must provide a filename with the .crtx extension to save a chart template in Excel.

2fill in blank

medium

Complete the code to apply a saved chart template to the active chart.

Excel

ActiveChart.ApplyChartTemplate "[1]"

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

ATemplate.docx

BChart1

CMyChart.crtx

DTemplate.xlsx

Attempts:

3 left

💡 Hint

Common Mistakes

Using a wrong file extension

Using a document or workbook file instead of a chart template

Not specifying the file name

To apply a chart template, you must specify the template file with the .crtx extension.

3fill in blank

hard

Fix the error in the code to save the chart template correctly.

Excel

ActiveChart.SaveChartTemplate "[1]"

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

AMyChart.crtx

BMyChart.docx

CMyChart.xlsx

DMyChart

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting the file extension

Using Excel workbook or document extensions

Using an invalid filename

The filename must include the .crtx extension to save as a chart template.

4fill in blank

hard

Fill both blanks to create a new chart and apply a saved template.

Excel

Set ch = Charts.Add()
ch.ChartType = [1]
ch.ApplyChartTemplate "[2]"

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

AxlColumnClustered

BxlLine

CMyTemplate.crtx

DTemplate.docx

Attempts:

3 left

💡 Hint

Common Mistakes

Using invalid chart type constants

Using wrong file extensions for the template

Mixing document files with chart templates

Use a valid chart type constant like xlColumnClustered and apply a saved template with the .crtx file.

5fill in blank

hard

Fill all three blanks to save a chart template, create a new chart, and apply the template.

Excel

ActiveChart.SaveChartTemplate "[1]"
Set newChart = Charts.Add()
newChart.ChartType = [2]
newChart.ApplyChartTemplate "[3]"

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

ASalesTemplate.crtx

BxlPie

DReport.docx

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong file extensions for templates

Using invalid chart type constants

Applying templates with incorrect filenames

Save the template with a .crtx file, use a valid chart type like xlPie, and apply the saved template file.