PowerPoint 2007 Charts - dummies

By Doug Lowe

Charting in PowerPoint 2007 is closely integrated with Excel 2007. When you insert a chart in PowerPoint, Excel starts automatically, and the data that you chart is placed in an Excel workbook. The chart and the datasheet workbook are stored within the PowerPoint document.

You can create all kinds of charts for your PowerPoint slides, from simple bar charts and pie charts to exotic doughnut charts and radar charts. The following list details some of the jargon you have to contend with when you’re working with charts:

  • Graph or chart: A graph or chart is nothing more than a bunch of numbers turned into a picture.

  • Chart type: PowerPoint supports bar, column, pie, line, scatter, area, radar, cone charts, and more. Different types of charts are better suited to displaying different types of data.

  • Chart Layout: A predefined combination of chart elements such as headings and legends that lets you create a common type of chart.

  • Chart Style: A predefined combination of formatting elements that controls the visual appearance of a chart.

  • Datasheet: Supplies the underlying data for a chart. For PowerPoint 2007, the datasheet is an Excel spreadsheet.

  • Series: A collection of related numbers. For example, a chart of quarterly sales by region might have a series for each region. Each series has four sales totals, one for each quarter. Most chart types can plot more than one series.

  • Axes: The lines on the edges of a chart. Actual data values are plotted along the Y-axis. Microsoft Graph automatically provides labels for the X- and Y-axes, but you can change them.

  • Legend: A box used to identify the various series plotted on the chart. PowerPoint can create a legend automatically if you want one.