Saving a Chart template in Excel is an efficient way to reuse your favourite or your company´s standard chart template.

So whenever you have new data and want to create a chart with your (company´s) standard formatting, all you need is a couple of clicks and you will have it seconds.

First you need to customize a chart to your liking and then Save it by going to Design > Save As Template > Name your template.

The next time you create a chart all you have to do is click on Design > Change Chart Types > Templates > and choose your custom template from the selection.

See how easily this is done below.

(In Excel 2013 & 2016 you need to Right Click on the chart and select Save as a Template)

DOWNLOAD WORKBOOK

Save Chart Template

HELPFUL RESOURCE:

MOTH 468x90.update.your.skills.animated.chart.learn.online.2

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Pivot Table Conditional Formatting Inserting a Pivot Table is very easy to do in Microsoft Excel: Inserting a Pivot TableAdding some Conditional Formats to the Pivot Table allows a user to highlight key data in a split second.See how easy it is to add some color to your analysis.DOWNLOAD WORKBOOK...
Overlap Graphs in Excel Overlapping graphs in Excel is used to compare two sets of data in one graph, like Actual v Plan results.This overlay of graphs may seem like a difficult exercise but it is a very easy process.First you need to edit your "Plan" graph by clicking on its series and pres...
Conditional Format a Cell´s Value A great way to highlight values within your data set, Excel Table or Pivot Table is to use Conditional Formatting rules.Formatting cells that contain a specific criteria, for example, greater than X or less than X, is a good way to visualize your results.When your criteri...
Organizational Charts in Excel Organizational Charts are important in any business and documenting them is very easy to do within Excel and in particular, SmartArt.To create an Organizational Chart in Excel you have to go to the ribbon menu and select Insert > SmartArt > Hierarchy > Organizational...