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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.