Datasheet
Copying a Chart’s Formatting
If you create a nicely formatted chart, and realize that you need to create several more
charts that have the same formatting, you have these three choices:
•
Make a copy of the original chart, and then change the data used in the copied chart.
One way to change the data used in a chart is to choose the Chart Tools➪Design➪
Data➪Select Data command and make the changes in the Select Data Source
dialog box.
•
Create the other charts, but don’t apply any formatting. Then, activate the original chart
and press Ctrl+C. Select one of the other charts, and choose Home➪Clipboard➪Paste➪
Paste Special. In the Paste Special dialog box, click the Formats option, and then click
the OK button. Repeat for each additional chart.
•
Create a chart template, and then use the template as the basis for the new charts. Or,
you can apply the new template to existing charts. See Chapter 2 for more information
about chart templates.
Renaming a Chart
When you activate an embedded chart, its name appears in the Name box (located to the
left of the formula bar). It seems logical that you can use the Name box to change the name
of a chart — but you can’t.
To change the name of an embedded chart, use the Chart Tools➪Layout➪Properties➪Chart
Name box. Just type the new name and press Enter.
Why rename a chart? If a worksheet has many charts, you may prefer to activate a particu-
lar chart by name. Just type the chart’s name in the Name box and press Enter. It’s much
easier to remember a chart named Monthly Sales as opposed to a chart named Chart 9.
Printing Charts
Printing embedded charts is nothing special; you print them the same way that you print a
worksheet. As long as you include the embedded chart in the range that you want to print,
Excel prints the chart as it appears on-screen. When printing a sheet that contains embed-
ded charts, it’s a good idea to preview first (or use Page Layout View) to ensure that your
charts do not span multiple pages. If you created the chart on a chart sheet, Excel always
prints the chart on a page by itself.
Part I: Chart Basics
30
05_044001 ch01.qxp 8/24/07 8:48 PM Page 30