Microsoft Excel logo on a green background

Creating a chart in Microsoft Excel is a reasonably unproblematic process, but it's the customizations yous apply that take the most time. So, if y'all create a chart and desire to reuse the colors and formatting, save information technology as a template!

By turning your hard work into a reusable template, you can salve time after. Plus, you can hang onto those company colors or specific formatting you spent and then much time applying. Best of all, you lot can apply a chart template in whatsoever Excel workbook and canvass once you salve it.

RELATED: How to Save Time with Excel Themes

Save a Chart as a Template

Whether you lot already take a chart or graph you want to save or are planning to salve the next nautical chart you lot create, information technology'due south like shooting fish in a barrel plenty.

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

Right-click the nautical chart and select "Save as Template."

Select Save as Template

Requite your template a proper name and click "Save." Now your template is saved and ready for you lot to reuse.

Name the template and click Save

Use a Saved Chart Template

When you want to use a template you've saved, this is besides super simple. Select the information for the nautical chart as y'all normally would to create any new chart.

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

Go 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 acme of the popular-upward window and pick "Templates" on the left. You'll and so see your saved templates on the right.

Choose Templates and pick the template

Choose the template and click "OK." Yous'll see the chart pop onto your sheet with your information selection.

Chart template inserted in Excel

If you already have a nautical chart in your sheet and then decide to employ the template, this is achievable likewise. Select the chart, go to the Chart Pattern tab that displays, and click "Change Chart Type."

Go to Chart Design, Change Chart Type

You'll so encounter the Insert Chart window described above where yous can choose "Templates" and select your template.

Even though you employ a template, you tin nevertheless make adjustments to your chart. So, you can modify the colors and alter the formatting without it affecting the saved template. Any changes you lot make only apply to the electric current chart.

Match the Document Theme

If y'all determine after using the template to create your new nautical chart that y'all prefer to keep the current theme for your document, no problem!

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

Correct-click the chart and select "Reset to Friction match Fashion."

Select Reset to Match Style

You'll run across your chart update immediately to match the theme you chose for your document and condone the colors and formatting yous saved with the template.

Chart updated to match the document theme

If you get for consistency when making charts in Excel for your business organisation or organization, consider saving a template to cut down on chart cosmos fourth dimension later.

If you oftentimes create the same kind of sheets in Excel, y'all can too save time past creating and saving your own spreadsheet template.

RELATED: How to Make a Bar Chart in Microsoft Excel

The above commodity may contain affiliate links, which help support How-To Geek.