To reuse a favorite chart type that you customized to meet your needs, you can save that chart as a chart template (*.crtx) in the charts template folder.

Instead of re-creating the chart, you can simply apply the chart template. You can also apply other types of chart templates, such as templates, that are provided by your corporation or templates that you download from Office Online.

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

  1. Click the chart that you want to save as a template.

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

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

    excel ribbon image

  3. In the Save in box, make sure that the Charts folder is selected.
  4. In the File name box, type an appropriate name for the chart template.

Apply a chart template

  1. Do one of the following:
    • To create a new chart based on the template, on the Insert tab, in the Charts group, click any chart type, and then click All Chart Types.

      excel ribbon image

      Tip You can also click the Dialog Box Launcher button image next to Charts in the Charts group on the Insert tab.

    • To make a selected chart match a template, on the Design tab, in the Type group, click Change Chart Type.

      excel ribbon image

  2. Click Templates in the first box, and then click the template that you want to use in the second box under My Templates.

    Note If a chart template is located in a folder other than the Charts folder, click Manage Templates, locate the chart template, and then copy or move it to the Charts folder under Templates.

Remove or delete a chart template

  1. On the Insert tab, in the Charts group, click any chart type, and then click All Chart Types.

    excel ribbon image

    Tip You can also click the Dialog Box Launcher button image next to Charts in the Charts group on the Insert tab.

  2. Click Manage Templates.
  3. Do one of the following:
    • To remove the chart template from the Charts folder, drag it to the folder where you want to store it.
    • To delete the chart template from your computer, right-click it, and then click Delete.



See also: