How To Save And Use Chart Template Excel

Excel has a huge range of charts bachelor and countless ways to customize them, but after working to get it just right, yous don't desire to take to go through the whole process over again next time you desire to make a like nautical chart. Fortunately, you don't have to because Excel allows y'all to save your chart as a template to use again whenever you need it.

To save your template, simply correct-click on the completed chart and select Save as Template.

Then just give the template a name that will enable you to identify it later, and relieve in the suggested location.

For Excel to rapidly find the template save information technology to the default location and leave it in that location. When you later come to utilise your template to create another chart, simply templates saved in the default folder volition announced as available for option.

However, in that location's cypher stopping you saving a Chart Template .ctrx file to whatever folder.

Not all charts can be templates

Sometimes the 'Salvage every bit Template…' option is greyed out with no explanation.

Newer chart types, added with Excel 365 cannot exist saved as templates. This limitation is true for all the new nautical chart types released in Part 2016/365 like Waterfall, Histogram, Treemap, etc.

Amazingly, these charts were added to Excel without including template support. Microsoft considers templates an 'extra' that they'll consider adding if in that location's enough customer involvement. Despite the passing of several years, this hasn't happened.

Using the Saved Template

To brand a new chart using your saved template, simply highlight the information that you want to chart, become to the Insert tab, so click either Recommended Charts or the arrow at the bottom correct of the Charts grouping.

In the dialog that opens, click on the All Charts tab then select Templates on the left.

Then just select the template you want to employ, and click OK to create your new chart.

Templates shows all the .ctrx files in the default location.

To select a template saved in another folder, click on Manage Templates then a folder on your computer or network.

Changing an Existing Nautical chart to a Saved Template

You tin can apply a template to a chart you've already created.

Say I have merely fabricated a column chart for a similar set of data, using Excel's default cavalcade chart format, equally I forgot that I had fix upward a template for this type of chart with slightly unlike features. So to apply the template to this chart, either:

Right-click on the chart and select Alter Chart Type.

Select the chart and click Alter Chart Type on the Design tab.

Then only go to All Charts | Templates and select the appropriate template, just as nosotros did above.

What Elements Are in the Template?

You may be surprised when you create a nautical chart from a template that not everything in the original nautical chart appears in your new chart. Notably, the text in your title and axis labels and legends will not be what y'all saved in your template. Typically, a chart template contains:

The chart type (bar nautical chart, column chart, pie nautical chart, etc.)
Which elements are included, and where they are located (such as titles, labels and fable).
Aesthetic elements such equally colors and fonts.

Anything else, such as the content of labels, titles, and legends, must come up from the data yous are making the chart from. Otherwise, these elements will be at that place in the aforementioned location every bit in the template, but containing only placeholder text, so you will have to edit the text to say what yous want.

For example, let's say I have a similar prepare of information, only the column headings are slightly different.

I now brand a chart out of this data using my template, and it looks like this:

Note that the column colors are the aforementioned every bit those in our original chart, but the legend has unlike labels because our new data has slightly different names for the column headings and they've come up from the data, non the template.

At that place are also placeholders for the chart title and axis labels, merely we will have to click on these to edit this data, equally this was not in the data we accept used to make the chart.

Adding and Deleting Nautical chart Templates

If you want to delete a template, or add together a template that you have somewhere other than the default binder, simple become back into the Change Chart Type dialog by going dorsum to Insert | Recommended Charts | All Charts | Templates. Then click the Manage Templates button at the bottom of the dialog box.