Page 433 - Excel 2007 Bible

26_044039 ch20.qxp 11/21/06 11:11 AM Page 390
Part III
Creating Charts and Graphics
FIGURE 20.7
Using Shapes in lieu of a legend.
CROSS-REF For more information about using chart templates, see “Creating Chart Templates,” later in this
CROSS-REF
chapter.
Copying Chart Formatting

ou created a killer chart and spent hours customizing it. Now you need to create another one just like it,
Ybut with a different set of data. What are your options? You have several choices:
n Copy the formatting. Create your new chart with the default formatting. Then select your original
chart and choose Home ➪ Clipboard ➪ Copy (or press Ctrl+C). Click your new chart and choose
Home ➪ Clipboard ➪ Paste ➪ Paste Special. In the Paste Special dialog box, select the Formats
option.
n Copy the chart; change the data sources. Press Ctrl while you click the original chart and drag.
This creates an exact copy of your chart. Then choose Chart Tools ➪ Design ➪ Data ➪ Select
Data. In the Select Data Source dialog box, specify the data for the new chart.
n Create a chart template. Select your chart and then choose Chart Tools ➪ Design ➪ Type ➪ Save
As Template. Excel prompts you for a name. When you create your next chart, use this template as
the chart type.

390