Microsoft Office Tutorials and References
In Depth Information
Saving a Chart as a Template So That You Can Use It Again
4. Format the chart element you selected.
In the Format task pane, you can find all the tools you need to change
the color, outline, and size of a chart element. These tools are explained
in detail in Chapter 4 of this mini-book.
If your experiments with retouching a chart go awry and you want to start
over, click the Reset to Match Style button on the (Chart Tools) Format tab.
Saving a Chart as a Template So
That You Can Use It Again
If you go to the significant trouble of redecorating a chart and you expect to
do it again the same way in the future, save your chart as a template. This
way, you can call on the template in the future to create the same chart and
not have to decorate it again. Perhaps you’ve created charts with your
company’s colors or you’ve created a chart that you’re especially proud of. Save
it as a template to spare yourself the work of reconstructing it.
A chart template holds data series colors, gridline settings, plot area colors,
font settings, and the like. It doesn’t hold data. These pages explain how to
save a chart as a template and how to create a chart with a template you
Saving a chart as a template
Follow these steps to make a template out of a chart:
1. Save your file to make sure the chart settings are saved on your
2. Select your chart.
3. Right-click your chart and choose Save As Template on the shortcut
You see the Save Chart Template dialog box.
4. Enter a descriptive name for the template and click the Save button.
Include the type of chart you’re dealing with in the name. This will help
you understand which template you’re selecting when the time comes to
choose a chart template.
By default, chart templates are saved in this folder in Windows 8, Windows 7,
and Windows Vista: C:\Users\ Username \AppData\Roaming\Microsoft\
Templates\Charts. The templates have the .ctrx extension. If you want
to delete or rename a template, open the Charts folder in File Explorer or
Windows Explorer and do your deleting and renaming there. You can open