Objective 2. Import Excel Data into a PowerPoint Chart

Activity 5.2. Importing Excel Data into a Chart in PowerPoint

In this activity, you continue to work with the PowerPoint slides. You will add a chart as another slide and import data from an Excel file.


On the Format menu, click Slide Design. The Slide Design task pane displays.

The slides created when you send the Word document have default formatting.


In the Slide Design task pane, scroll down to find the Profile template (it is the first template in the list that does not have a solid color in the background), and then click it. If the Profile template does not appear in the list, choose another design. This adds background, graphics, and bullets to your slides appearance.


On the Slides tab, click slide 1. On the Insert menu, click New Slide.

The Slide Layout task pane displays, and a new slide is inserted.


In the Slide Layout task pane, under Other Layouts, click Title and Chart, and then on the slide, double-click the chart icon.

PowerPoint adds a default chart and datasheet to the new slide. While the chart is selected, the chart tools will display in the Standard toolbar. If you click outside the chart, it will be deselected, and PowerPoints Standard toolbar tools will display. To select the chart, double-click on the chart.


With the chart selected, on the Standard toolbar, click Import File. The Import file window displays.


In the Import File dialog box, from the Look in list, select the folder that contains your project files, and then double-click on the file Salary_Levels. The Import Data Options dialog box displays.


In the Import Data Options dialog box, click on the sheet name Salary, and then click OK.

The chart and datasheet change to show the data from the selected file.


Click outside the chart area on the slide. The datasheet and the chart toolbar close, and the finished chart displays on the slide.

[Page 1387]


On the slide, click in the Title text box. Type Salary Levels and then click outside the text box. Compare your screen with Figure 5.4.

Figure 5.4.


Save your file, and leave it open for the next activity.

[Page 1387 (continued)]

Windows XP

Outlook 2003

Internet Explorer

Computer Concepts

Word 2003

Chapter One. Creating Documents with Microsoft Word 2003

Chapter Two. Formatting and Organizing Text

Chapter Three. Using Graphics and Tables

Chapter Four. Using Special Document Formats, Columns, and Mail Merge

Excel 2003

Chapter One. Creating a Worksheet and Charting Data

Chapter Two. Designing Effective Worksheets

Chapter Three. Using Functions and Data Tables

Access 2003

Chapter One. Getting Started with Access Databases and Tables

Chapter Two. Sort, Filter, and Query a Database

Chapter Three. Forms and Reports

Powerpoint 2003

Chapter One. Getting Started with PowerPoint 2003

Chapter Two. Creating a Presentation

Chapter Three. Formatting a Presentation

Integrated Projects

Chapter One. Using Access Data with Other Office Applications

Chapter Two. Using Tables in Word and Excel

Chapter Three. Using Excel as a Data Source in a Mail Merge

Chapter Four. Linking Data in Office Documents

Chapter Five. Creating Presentation Content from Office Documents

Go! With Microsoft Office 2003 Brief
GO! with Microsoft Office 2003 Brief (2nd Edition)
ISBN: 0131878646
EAN: 2147483647
Year: 2004
Pages: 448

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net