If you want to reuse a chart that you created, you can save the chart as a template in Excel, and then apply it to a new or existing chart in Word, PowerPoint, or Excel. A chart template that you create is actually a custom chart type that you can apply as you would any other chart type.
Do any of the following:
 | Create a chart template in Excel |
-
On a sheet, arrange the data that you want to plot in a chart.
-
Select the rows and columns that you want to appear in the chart.
-
On the Charts tab, under Insert Chart, click a chart type, and then click the one that you want to add.
 | Note To change the chart, use the Charts tab, the Chart Layout tab, and the Format tab. |
-
On the Chart menu, click Save as Template, and then type a name in the Save As box.
Important
By default, the chart template is saved in
/Users/username/Library/Application Support/Microsoft/Office/Chart Templates
so that the custom chart type will be available under Templates on the Charts tab.
If you are using Mac OS X 7 (Lion), the Library folder is hidden by default. To show the Library folder, in the Finder, click the
Go menu, and then hold down
OPTION.
-
Click Save.
| Apply a chart template to a new chart |
After you create a chart template, you can apply the custom chart type to a new chart in Word, PowerPoint, or Excel.
-
On a sheet, arrange the data that you want to plot in a chart.
-
Select the rows and columns that you want to appear in the chart.
-
On the Charts tab, under Insert Chart, click Other, and then under Templates, click the chart template that you created.
| I don't see my chart template in the list |
By default, a chart template is saved automatically in
/Users/username/Library/Application Support/Microsoft/Office/Chart Templates
so that the custom chart type will be available under Templates on the Charts tab. If you do not see your chart template listed under Templates, in the Finder, search for the .crtx file, and then move it to
/Users/username/Library/Application Support/Microsoft/Office/Chart Templates.
If you are using Mac OS X 7 (Lion), the Library folder is hidden by default. To show the Library folder, in the Finder, click the
Go menu, and then hold down
OPTION.
-
On a sheet, arrange the data that you want to plot in a chart.
| Apply a chart template to an existing chart |
After you create a chart template, you can apply the new custom chart type to an existing chart in Word, PowerPoint, or Excel.
-
Click the chart.
-
On the Charts tab, under Change Chart Type, click Other, and then under Templates, click the chart template that you created.
| I don't see my chart template in the list |
By default, a chart template is saved automatically in
/Users/username/Library/Application Support/Microsoft/Office/Chart Templates
so that the custom chart type will be available under Templates on the Charts tab. If you do not see your chart template listed under Templates, in the Finder, search for the .crtx file, and then move it to
/Users/username/Library/Application Support/Microsoft/Office/Chart Templates.
If you are using Mac OS X 7 (Lion), the Library folder is hidden by default. To show the Library folder, in the Finder, click the
Go menu, and then hold down
OPTION.
