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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Copying & Moving Excel Charts I am going to show your three quick ways to copy and move your Excel charts: #1 - COPYING A CHART Click on the chart with your left mouse key and at the same time hold down the CTRL key to copy it and move the chart to wherever you want. When you are done, let go of the ...
100% Stacked Column Chart: Percentage Contribution... The 100% Stacked Column chart is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total. For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then thi...
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...
Combine Column & Line Charts in Excel Some times you may come across a situation where you want to show 2 variables in one Excel chart. For example, you may have some sales data and a transactional count that you want to show in one chart to see if there is any relationship between the two variables. Well you c...