Chart Options

Chart options refer to the inclusion and basic formatting of chart elements such as titles, axes, gridlines, legends, data labels, and data tables. You set chart options with the Chart Options dialog.

To use the Chart Options dialog

1.
Activate the chart by switching to its chart sheet or, if it's an embedded chart, by clicking within it.
2.
Choose Chart > Chart Options (Figure 28) to display the Chart Options dialog (Figures 48 through 53).
Figure 48. The Titles tab of the Chart Options dialog for a 3-D column chart. The sample illustration shows all titles set.

Figure 49. The Axes tab of the Chart Options dialog for a 3-D column ...

Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.