Advanced Microsoft® Office Documents 2007 Edition Inside Out

The New Essentials for Creating Charts

Before diving into more advanced topics, following is a quick summary of some charting essentials that have changed as well as confirmation of a few things that remain the same.

1. To create a chart on its own sheet, you can still use the shortcut F11—which creates the default chart type. This is now the only method for creating a chart directly on its own sheet. You can, however, move any chart to its own sheet after creating it, as discussed later in this list.

2. Initially, the default chart type is a clustered column chart. However, to set a different chart type as your default, on the Insert tab, in the Charts group, click the dialog launcher to open the Insert Chart dialog box. Then, just select the chart type ...