Microsoft Office Tutorials and References
In Depth Information
Objects on the Drawing Layer
You can insert a number of different controls on a worksheet. These controls come in two flavors —
Form controls and ActiveX controls. Using controls on a worksheet can greatly enhance the
worksheet’s usability — often, without using macros. To insert a control, choose Developer
Insert. Figure 1-10 shows a worksheet with various controls added to the drawing layer: a check
box, two sets of option buttons, and a scroll bar.
The Ribbon’s Developer tab is not visible by default. To show the Developer tab,
rightclick the Ribbon and select Customize The Ribbon to display the Excel Options dialog
box. In the list box on the right, place a check mark next to Developer.
If you’d like to see how these controls work, the workbook shown in Figure 1-10 is
available on the companion CD-ROM. The file is named worksheet controls.xlsx .
Figure 1-10: Excel enables you to add many controls directly to the drawing layer of a worksheet.
Excel, of course, has excellent charting capabilities. As I mention earlier in this chapter, you can
store charts on a chart sheet or you can float them on a worksheet.
Excel offers extensive chart customization options. Selecting a chart displays the Chart Tools
contextual tab, which contains basic tools to customize your chart. For more control, press Ctrl+1
to display the Format dialog box for the selected elements. In addition, right-clicking a chart
element displays a shortcut menu.
You can easily create a free-floating chart by selecting the data to be charted and selecting one
of the chart types from the Insert
Chapter 17 contains additional information about charts.