Datasheet

Embedded Charts
An embedded chart basically floats on top of a worksheet, on the worksheet’s drawing layer.
The charts shown previously in this chapter are both embedded charts.
As with other drawing objects (such as a text box or a shape), you can move an embedded
chart, resize it, change its proportions, adjust its borders, and perform other operations.
Using embedded charts enables you to view the chart next to the data that it uses. Or, you
can place several embedded charts together so that they print on a single page.
When you create an Excel 2007 chart, it’s always an embedded chart. The exception to this
rule is when you select a range of data and press F11 to create a default chart. Such a
chart is created on a chart sheet.
To make any changes to the actual chart in an embedded chart object, you must click it to acti-
vate the chart. When a chart is activated, Excel displays the three Chart Tools context tabs
shown in Figure 1-3: Chart Tools➪Design, Chart Tools➪Layout, and Chart Tools➪Format.
Figure 1-3: Activating a chart displays additional tabs on the Excel Ribbon.
Part I: Chart Basics
12
05_044001 ch01.qxp 8/24/07 8:48 PM Page 12