Microsoft Office Tutorials and References
In Depth Information
How Excel Handles 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 add effects such as a shadow. 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.
As we discuss in Chapter 11, you ideally place your charts in the presentation layer, presenting the
relevant charts in a single viewable area that fit on one page or a single screen.
When you create a chart, it always starts off as 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
To make changes to the actual chart in an embedded chart object, you must click the chart to
activate it. When a chart is activated, Excel displays the two Chart Tools context tabs, Design and Format,
as shown in Figure 5-3. To access these commands, choose Chart Tools➜Design and Chart Tools➜
In addition, when clicking a chart, you’ll see several buttons next to the chart. These are helper
buttons that provide an easy way to customize the various properties of the chart. These include
Figure 5-3: Activating a chart displays additional tabs on the Excel Ribbon and helper buttons next to the chart.