Reuse a favorite chart by using a chart template

To reuse a favorite chart that you customized to meet your needs, you can save that chart as a chart template (*.crtx) in the charts template folder. A chart template that you create is in reality a custom chart type that you can apply like any other chart type.

Instead of re-creating the chart, you can apply the chart template to the worksheet data when you create a new chart. You can also change the chart type of an existing chart by applying a chart template.

If you no longer need a specific chart template, you can remove it from the charts template folder or you can delete it from your computer.

What do you want to do?

Save a chart as a chart template

Tip: This displays the Chart Tools, adding the Design, Layout, and Format tabs.

On the Design tab, in the Type group, click Save As Template.

In the Save in box, make sure that the Charts folder is selected.

Note: The Charts folder is typically selected by default. Chart templates that you save in this folder will automatically be added to the Templates folder in the Insert Chart and Change Chart Type dialog box so that you can select it when you create or update a chart.

In the File name box, type an appropriate name for the chart template.