Working with Charts

Working with Charts


PowerPoint 2007 Charts A chart is a tool you can use to communicate your data graphically. Charts often help an audience to see the meaning behind numbers and make showing comparisons and trends easy. In this lesson, you will learn how to insert and modify charts and see how they can be an effective tool for communicating information.

Inserting charts

To insert a chart:

Insert Chart
Chart Types
Insert Chart Dialog Box

If a slide layout has a content placeholder, click the Insert Chart command to insert a new chart.

Enter chart data

The data that appears in the Excel spreadsheet is placeholder source data you'll replace with your own information. The Excel source data is used to create the PowerPoint chart.

Excel Data

To enter chart data:

Example Spreadsheet Data
Change Data Range
Delete Data
PowerPoint Chart

Formatting charts

When you insert a chart, three new tabs will appear on the Ribbon. The three tabs—Design, Layout, and Format—contain various chart tools and commands that allow you to modify and format the chart.

Chart Tools

To change the chart type:

Change Chart
Insert Chart Dialog Box

To edit source data:

Edit Chart Data

To change the chart style:

Change Chart Style
New Chart Style

Identifying the parts of a chart

Have you ever read something you didn't fully understand, but when you saw a chart or graph the concept became clear and understandable? Charts are a visual representation of data. They make it easy to see comparisons, patterns, and trends in the data.

Chart Example

Source data

This is the range of cells that make up a chart. The chart is updated automatically whenever the information in these cells changes.


This is the title of the chart.


This is the chart key, which identifies what each color on the chart represents.


This is the vertical and horizontal parts of a chart. The vertical axis is often referred to as the Y axis, while the horizontal axis is referred to as the X axis.

Modifying the chart layout

To change the chart layout:

Chart Layout

The chart layout determines how specific chart information will appear. For example, some layouts include chart titles, legends, and axis labels.

To modify specific areas of the chart layout:

Chart Labels
Chart Titles
Axis Titles
Chart Legend Options
Chart Data Labels

Other important commands on the Layout tab

In the Axes group, there are several commands that control both axes and whether the gridlines are visible. In the Background group, there are several commands that control visual aspects of the chart. Some commands in the Analysis group will appear active only if the selected chart is a line, area, or bubble chart.

Layout Groups

Additional chart formatting

Use the commands on the Format tab to modify the chart in additional ways. For example, from this tab you can change the chart outline, format chart text as WordArt, and perform other functions.

Format Tab


Use the Company Overview presentation or any other presentation you choose to complete this challenge.