3.5. Excel 2007 Charts with Excel Tables

The need to understand Excel charts is almost universal among business users, and yet most people don't know how to take advantage of Excel's sophistication in this area. In this section we'll use our working example of school test scores to show how to create a compelling chart story that can be used in a presentation or meeting to truly convey information about the various school scores.

Figure 3-32 shows how we start this process, using the Office 2007 Ribbon menu options to choose a chart type.

  1. Click the Other Charts icon in the Charts menu group, on the Ribbon menu Insert tab.

  2. Click the Line chart type in the Insert Chart dialog box.

  3. Click the first Line icon in the gallery of chart types.

Figure ...

Get Microsoft ® Office 2007 Business Intelligence 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.