To reuse a chart you customized, you can save it as a chart template (*.crtx).
-
Right-click the chart, and select Save as Template.
-
In the File name box, type an appropriate name for the chart template.
-
Click Save.
The chart template automatically appears in the Templates folder for charts. You’ll find the Templates folder on the All Charts tab in the Insert Chart or Change Chart Type dialog box, where you can apply a chart template like any other chart type.
Note:A chart template contains chart formatting and stores the colors that are in use when you save the chart as a template. When you use a chart template to create a chart in another workbook, the new chart uses the colors of the chart template— not the colors of the document theme that is currently applied to the workbook. To use the document theme colors instead of the chart template colors, right-click the chart area, and then click Reset to Match Style on the shortcut menu.
To reuse a chart you customized, you can save it as a chart template (*.crtx).
-
Right-click the chart, and select Save as Template.
-
In the Save Chart Template dialog box, in the Save as box, type an appropriate name for the template.
-
Click Save.
Apply a custom chart template to a new or an existing chart
-
To apply the custom template to a new chart, select the range in the spreadsheet, and then click the Insert menu > Chart > Templates > your custom template.
-
To apply the custom template to an existing chart, click on the chart, and then click Chart Design tab on the ribbon > click Change Chart Type > click Templates, and then select the custom template.
