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

Excel Chart Marker Options The Marker Options within an Excel chart enables you to add different marker types or shapes on your chart to distinguish a data series or its individual data points.To bring up the Marker Options you need to click on your Excel chart and make sure that all the points are sel...
Area Chart: Highlight Chart Sections When you are showing 12 month sales results using a Line Chart and want to highlight certain values within the chart to make them stand out (like Q2 & Q3 results), then an Area Chart will be needed.To do this there are a few steps to follow:1. Enter the Line Chart for...
Process Map Using Excel If you want to show a process in your workplace then this can be designed using Excel´s Smart Art.There are heaps of Process Maps in Excel that shows progress from left to right, top to bottom, one way and circular.  Here is how you can insert a left to right Process Map usin...
In-Cell Bar Charts with the REPT Function When you are creating an Excel Dashboard and are limited by space and do not want to insert a chart, you can easily create an in-cell bar chart using the RPT (repeat) function.The RPT function uses the vertical bar character | as the first argument: text and references the va...