To save an Excel chart as a reusable template in Microsoft 365 for Windows, select or right-click the chart, choose Save as Template, name the file, and save it. Excel stores the design in a .crtx file so you can apply the chart type and formatting to other data without rebuilding the look from scratch. You will need a chart to use as the starting point; review it before saving because the template reflects the chart’s current design.
What You’ll Need
- Excel for Microsoft 365 desktop on Windows. Excel for the web does not provide the full desktop workflow for saving and applying chart templates.
- A workbook containing a chart with the chart type, colors, labels, axes, and other formatting you want to reuse. The chart can use sample data if you are designing a general style.
- A place to save the .crtx template file. Keep it somewhere you can find again, such as your Documents folder or a shared team folder.
Step-by-Step
- Prepare the chart you want to reuse. Open the workbook in the Excel desktop app and select the chart. Make sure it uses the chart type you need, such as a clustered column, line, or doughnut chart. Set its appearance first: adjust the title, legend, data labels, axes, gridlines, colors, fonts, and any other formatting that should carry over. A template is most useful when the starting chart is tidy and representative of the charts you plan to create.
- Check the chart’s data arrangement. Confirm that the series and categories are arranged as intended. For example, if months should appear along the horizontal axis and product names should define the series, make sure the chart reflects that setup. A template saves design choices, not a reusable connection to your original data range. When you use it with another table, Excel will build a chart from the new data and may interpret its rows and columns differently.
- Open the Save as Template command. Right-click the chart’s border or a blank area inside the chart. In the context menu, choose Save as Template. If the chart is selected and the command is not visible, try right-clicking its outer edge rather than a data point, axis, or legend item; those objects have their own context menus. You can also look for the command after opening the chart-specific ribbon, depending on the Excel build and context.
- Name and save the template. In the Save Chart Template dialog, choose a clear file name and click Save. Excel saves the chart template as a .crtx file. Use a name that describes its purpose, such as Monthly Sales Line or Executive Summary Columns, rather than a vague name such as Chart 1. If the dialog opens in a default folder, note its location, or navigate to a folder you will remember.
- Choose where to keep the file. For a template you will use on one computer, a personal folder is convenient. For a team template, save a copy in a shared location that colleagues can access, subject to your organization’s permissions. Avoid moving or renaming the file after you have set up a process that depends on its location. If you do move it, you can still browse to the new location when applying it.
- Apply the template to a new chart. Select the new data, then choose Insert > Recommended Charts. In the chart dialog, open the All Charts tab and select Templates. Choose the saved design and click OK. Depending on the Excel build, the template may appear in the list automatically or you may need to browse to the .crtx file. Check that Excel has placed the intended categories and series on the chart.
- Apply it to an existing chart instead. Select the existing chart, then choose Chart Design > Change Chart Type. In the dialog, select Templates, choose the template, and confirm with OK. This changes the selected chart’s type and design; it does not replace the worksheet’s source data. Inspect the result, especially if the old and new charts use different numbers of series or different data structures.
- Save and verify your work. Save the workbook after applying the template. If the chart will be reused by someone else, test the template on a small example or a copy of the workbook and confirm that titles, labels, axes, and colors behave as expected. Keep the .crtx file as a separate item: saving the workbook does not necessarily put a portable copy of the template beside it.
On Mac: Excel for Mac has chart-template support in some current desktop versions, but the exact dialogs and available commands can differ. Control-click or right-click the chart and look for Save as Template; when available, save the .crtx file and use the chart insertion or chart-type dialog’s templates category to apply it. If the command is absent, update Excel or use Excel for Microsoft 365 on Windows to create the template. Excel for the web is not a substitute for the desktop template workflow; open the workbook in the desktop app.
Common Mistakes
- Saving before finishing the design. Excel captures the chart as it looks when you save it. If you later change fonts, colors, or labels on the original chart, those edits do not automatically update an already saved .crtx file. Save a fresh template after meaningful design changes.
- Expecting the template to contain the data. A chart template is a reusable chart design, not a workbook, data table, or live link to the source range. The original data remains in its worksheet, while a new chart uses the data you select when applying the template.
- Selecting a chart element instead of the chart. Right-clicking a legend, axis, or single data point may show formatting commands for that item rather than the chart-level Save as Template command. Click the chart’s outer border or an empty part of its plot area and try again.
- Assuming every chart will look identical afterward. A template can carry chart type and formatting, but Excel still has to adapt the design to the new data. A chart with more series, longer category labels, or a different scale may need manual adjustments.
- Using an unclear name or losing the file. A generic file name makes it difficult to identify the right style later. Keep meaningful names and note the save location, particularly if you manage several templates or share them with a team.
- Confusing a workbook theme with a chart template. A workbook theme affects broader formatting choices, while a chart template is intended to reuse a particular chart’s type and appearance. Changing the workbook theme can also affect chart colors, so check the final look in the workbook where the chart will be used.
Tips
- Start with the most common chart structure. If most charts will show monthly values by department, build and save a chart with that arrangement. A template based on an unusual series layout may take more correction when applied elsewhere.
- Use a naming pattern. Names such as Line – Monthly Trend or Column – Budget vs Actual make the chart type and purpose easy to scan. If your organization has a design standard, include a version or team label where it helps identify the approved file.
- Keep a master example. Save a workbook containing a well-formatted example chart as well as the .crtx file. The workbook can show colleagues what the design is meant to look like and help you recreate it if the template is misplaced.
- Test with realistic labels and values. A template that looks neat with short labels may become crowded with long department names. Test a copy with a typical data set before relying on it for reports.
- Store shared templates in a stable location. A network or cloud folder can make a template easier for a team to find, but availability depends on access and syncing. Share the .crtx file itself and provide its location; do not assume that a template saved on one person’s computer will automatically appear on another person’s computer.
- Use a copy when redesigning. If you are unsure whether a change will improve a template, save a second version with a distinct name. That preserves the original design while you compare the alternatives.
Troubleshooting
Save as Template is missing. First, make sure you are using the desktop version of Excel and have selected the chart itself. Right-click the chart border or a blank area within the chart, not a selected axis or data series. If you are working in a browser, choose the option to open the workbook in the desktop app. On a Mac, command availability can vary by version; update Office or create the template in Excel for Windows if the command is not offered.
The template does not appear in the Templates list. Confirm that the file was saved as a .crtx chart template, not as an Excel workbook or image. In the chart dialog, look for a browse option and navigate to the folder where you saved the file. If you renamed or moved it, browse to its current location. Close and reopen the chart dialog if it was already open when you saved the template.
The chart looks different when applied. Check that the new data is selected correctly and that Excel is using the intended rows or columns as series. Use Chart Design > Switch Row/Column if the categories and series are reversed. Then adjust the axis bounds, number formats, title, legend, or data labels as needed. A template sets a starting design; it cannot guarantee that every data set has the same best scale or label placement.
The colors changed after applying the template. Workbook themes and chart color choices can affect the displayed palette. Review the chart in the destination workbook and, if necessary, use Chart Design > Change Colors or format individual chart elements. If consistent colors are essential, verify them in the workbook that will be used for the final report.
A colleague cannot find the template. Send or share the .crtx file, and tell the colleague where it is stored. A template saved locally is not automatically installed or available on every computer. Ask them to open Excel desktop and browse to the file from the chart template dialog if it does not appear in their list.
Frequently Asked Questions
What file type does Excel use for chart templates?
Excel saves chart templates with the .crtx extension. Keep that file if you want to apply the design in another workbook or share it with someone else.
Does saving a chart as a template save its data?
No. The template saves chart design and type, not a copy of the worksheet data or a live link to the original range. Select the new data when you create a chart from the template.
Can I use a chart template in another workbook?
Yes. Use the template category in the chart insertion or Change Chart Type dialog, or browse to the .crtx file. You may need to navigate to its saved location if Excel does not list it automatically.
Can I edit a chart template after saving it?
Change the original chart and save a new template file to capture the updated design. An existing .crtx file does not update automatically when you edit the chart from which it was made.
Can I save a chart template in Excel for the web?
The full Save as Template workflow is a desktop Excel feature. Open the workbook in Excel for Microsoft 365 on Windows, or use a supported desktop Mac version if its chart-template commands are available.
Will the template work with a different chart type?
A chart template is intended to apply a chart type and its formatting. Excel may adapt elements for the new data, and some chart-specific settings may not translate exactly, so inspect and adjust the result.
Related
- Protect an Excel File From Opening With a Password
- How to Protect an Excel Sheet in Google Drive
- How to Print in Microsoft Excel: A Step-by-Step Guide
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Histogram Template: Build One and Set BinsAn Excel histogram template is a worksheet or chart setup that groups numeric data into ranges (bins) and…
- Excel Pivot Table Refresh Error? Causes and FixesTo fix an Excel PivotTable refresh error, select the PivotTable and choose PivotTable Analyze > Refresh; to update…
- Add a Pareto Line to an Excel Bar ChartYes. In Excel for Microsoft 365 on Windows, add a cumulative-percentage column beside your category counts, then use…
- Excel Area Chart: How to Create and Format OneTo create an area chart in Excel for Microsoft 365 on Windows, select your data, then choose Insert…
- Pareto Chart in Excel: How to Create and Interpret ItTo make a Pareto chart in Excel for Microsoft 365 on Windows, put one category per row in…
- Excel Pivot Table: Multiple Rows at the Same LevelYes. In Excel for Microsoft 365 on Windows, add each field to the PivotTable Rows area, then choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.