Chart Templates in Microsoft Excel 2007

Posted by Dan St. Hilaire  /  June 9, 2010  /  Excel   —   No Comments ↓

Save a Chart as a Chart Template

1. Click the chart that you want to save as a template.

Tip: This displays the Chart Tools, adding the Design, Layout, and Format tabs.
2. On the Design tab, in the Type group, click Save As Template.

3. In the Save in box, make sure that the Charts folder is selected.

Note: The Charts folder is typically selected by default. Chart templates that you save in this folder will automatically be added to the Templates folder in the Insert Chart and Change Chart Type dialog box so that you can select it when you create or update a chart.

4. In the File name box, type an appropriate name for the chart template.

Topics: Excel