Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

If you want to create another chart like the one that you just created, you can save the chart as a template that you can use as the basis for other similar charts.

Note: The screenshots in this topic were taken in Excel, but the procedures in this topic apply to Outlook, PowerPoint, or Word as well.

To reuse a chart you customized, you can save it as a chart template (*.crtx).

  1. Right-click the chart, and select Save as Template.

    Save as Template command on the shortcut menu

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

    Save Chart Template dialog box

  3. 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.

    The Templates folder on the All Charts tab in the Insert Chart dialog box

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).

  1. Right-click the chart, and select Save as Template.

  2. In the Save Chart Template dialog box, in the Save as box, type an appropriate name for the template.

  3. 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.

See Also

Create a chart from start to finish

Change the color or style of a chart

Get Microsoft chart templates

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×