Microsoft Excel logo on a green background

Creating a nautical chart in Microsoft Excel is a reasonably simple procedure, but it's the customizations yous employ that accept the most fourth dimension. And then, if you create a chart and desire to reuse the colors and formatting, save it as a template!

Past turning your hard work into a reusable template, you can save time later. Plus, you tin hang onto those visitor colors or specific formatting y'all spent so much time applying. Best of all, you can use a chart template in whatever Excel workbook and sheet once you save it.

RELATED: How to Save Time with Excel Themes

Salvage a Nautical chart every bit a Template

Whether you lot already have a chart or graph you want to save or are planning to save the side by side nautical chart you lot create, it'due south easy enough.

RELATED: How to Create and Customize a Waterfall Chart in Microsoft Excel

Right-click the chart and select "Relieve equally Template."

Select Save as Template

Requite your template a proper noun and click "Save." Now your template is saved and ready for yous to reuse.

Name the template and click Save

Utilize a Saved Chart Template

When you want to use a template you've saved, this is as well super simple. Select the information for the chart as yous ordinarily would to create any new chart.

RELATED: How to Create and Customize a Pareto Chart in Microsoft Excel

Get to the Insert tab and click "Recommended Charts" in the Charts section of the ribbon.

Go to Insert, Recommended Charts

Select the All Charts tab at the height of the pop-upward window and selection "Templates" on the left. You'll and then see your saved templates on the right.

Choose Templates and pick the template

Choose the template and click "OK." You'll see the chart pop onto your canvas with your data choice.

Chart template inserted in Excel

If y'all already have a chart in your canvass and and so decide to apply the template, this is doable besides. Select the nautical chart, go to the Nautical chart Pattern tab that displays, and click "Modify Chart Blazon."

Go to Chart Design, Change Chart Type

Yous'll then run across the Insert Chart window described higher up where you tin can choose "Templates" and select your template.

Even though yous apply a template, you lot tin can still make adjustments to your chart. So, you can change the colors and alter the formatting without it affecting the saved template. Whatsoever changes yous brand only apply to the current chart.

Lucifer the Document Theme

If you make up one's mind after using the template to create your new nautical chart that you prefer to proceed the current theme for your document, no problem!

RELATED: How to Create and Customize a Treemap Chart in Microsoft Excel

Right-click the chart and select "Reset to Lucifer Style."

Select Reset to Match Style

You'll meet your nautical chart update immediately to lucifer the theme y'all chose for your document and disregard the colors and formatting you saved with the template.

Chart updated to match the document theme

If you go for consistency when making charts in Excel for your business or system, consider saving a template to cut down on chart cosmos time later.

If yous often create the same kind of sheets in Excel, you can likewise save time by creating and saving your own spreadsheet template.

RELATED: How to Make a Bar Chart in Microsoft Excel


The above commodity may contain chapter links, which help back up How-To Geek.