Datasheet

The Format command displays a stay-on-top tabbed dialog box, with options for the

selected element.

Figure 1-17 shows the Format Axis dialog box, which I displayed by right-clicking the ver-

tical axis and selecting Format Axis from the shortcut menu.

Figure 1-17: Each chart element has a formatting dialog box.

This one is used to format a chart axis.

TIP

If you’ve applied formatting to a chart element and decide that it wasn’t such a good

idea, you can revert to the original formatting for the particular chart style. Right-click

the chart element and choose Reset to Match Style from the shortcut menu. To reset the

entire chart, select the chart area when you issue the command.

NOTE

In previous versions of Excel, double-clicking a chart element displayed its Format dialog

box. That mouse action does not work in Excel 2007.

Chapter 1: Introducing Excel Charts

Part I

05_044001 ch01.qxp 8/24/07 8:48 PM Page 29