Microsoft Office Tutorials and References
In Depth Information
To see how these controls work, the workbook shown in Figure 1-8 is available at this
book's website. The file is named activex worksheet controls.xlsx.
Figure 1-8: Excel enables you to add many controls directly to the drawing layer of a worksheet.
Excel, of course, has excellent charting capabilities. Enhancements in Excel 2013 make creating and customiz-
ing charts easier than ever.
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 task
pane 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 ⇒ Charts group.