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.
 | Note To save a chart template, you must have Excel
installed. You can order a copy of Excel
on the
Microsoft Web site . |
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.
-
Click Save.
 | Apply a chart template to a new chart |
After you create a chart template, you can create a new chart by selecting your custom chart in Word, PowerPoint, or Excel.
-
On the Charts tab, under Insert Chart, click Other, and then under Templates, click the chart template that you created.

When you insert a chart into Word
or PowerPoint, an Excel
sheet opens that contains a table of sample data.
-
In Excel, replace the sample data with the data that you want to plot in the chart. If you already have your data in another table, you can copy the data from that table and then paste it over the sample data.
-
To see the results of your changes, switch to Word.
 | Note When you close the Word
document that contains the chart, the chart's Excel
data table closes automatically. |
 | Apply a chart template to an existing chart |
-
Click the chart.
-
On the Charts tab, under Change Chart Type, click Other, and then under Templates, click the chart template that you created.
