Microsoft Office Tutorials and References
In Depth Information
How Excel Handles Charts
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 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
sheet.
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➜
Format, respectively.
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
Chart Elements
Chart Style
Chart Filter
Figure 5-3: Activating a chart displays additional tabs on the Excel Ribbon and helper buttons next to the chart.
Search JabSto ::




Custom Search