Exploring Microsoft Excel 97 Chapter 4 Graphs and

Exploring Microsoft Excel 97 Chapter 4 Graphs and Charts: Delivering a Message Exploring Excel 97 Chapter 4 Office graphic copyright by Microsoft Corp.

Objectives (1 of 2) 4 Know advantages and disadvantages of different chart types 4 Distinguish between an embedded chart and one in a separate chart sheet 4 Use the Chart. Wizard 4 Use arrows and text to enhance a chart Exploring Excel 97 Chapter 4 2

Objectives (2 of 2) 4 Differentiate between data series specified in rows versus ones in columns 4 Understand how charts can be accurate statistically yet misleading conceptually 4 Create a compound document consisting of word processing, worksheet and a chart Exploring Excel 97 Chapter 4 3

Overview 4 Business graphics one of most exciting Windows applications 4 Determine message of chart 4 Create charts using Chart Wizard 4 Plot multiple data sets on a single chart 4 Dynamically link a chart to a memo Exploring Excel 97 Chapter 4 4

Chart Types 4 Always remember to keep it simple 4 Pie and Exploded pie charts, effective for displaying proportional relationships 4 Column chart used for number display 4 Bar charts show numbers horizontally Exploring Excel 97 Chapter 4 5

Excel 97 Screen Exploring Excel 97 Chapter 4 6

Excel 97 Screen Exploring Excel 97 Chapter 4 7

Creating a Chart 4 Embedding in a worksheet or separate chart sheet 4 Use the Chart Wizard a four step process – Step one choosing a chart – Step two review data series – Step three final touches – Step four where to store 4 Enhance with Drawing toolbar or Chart toolbar Exploring Excel 97 Chapter 4 8

Excel 97 Screen Exploring Excel 97 Chapter 4 9

The Chart Wizard Hands-On Exercise 1 4 Start the Chart. Wizard 4 Move and Size the Chart 4 Change the Worksheet 4 Change the Chart Type 4 Create the Second Chart 4 Enhance the Chart 4 Format the Data Series 4 Print the Workbook Exploring Excel 97 Chapter 4 10

Excel 97 Screen Exploring Excel 97 Chapter 4 11

Multiple Data Series 4 What message do you want chart to display 4 Rows versus columns – If data series are in rows the Chart Wizard will use first row for X axis and use first column for legend text – If data series are in columns the Chart Wizard will use first column for X axis and use first row for legend text Exploring Excel 97 Chapter 4 12

Multiple Data Series Hands-On Exercise 2 4 Rename the Worksheets 4 The Office Assistant 4 View the Data Series 4 Complete the Chart 4 Copy the Chart Sheet 4 Change the Source Data 4 The Stacked Column Chart Exploring Excel 97 Chapter 4 13

Object Linking and Embedding 4 Primary advantage of Windows is to create a compound document 4 Embedded object is stored in the compound document 4 Linked object is stored in its own file and used with a compound document 4 OLE pronounced “Oh-lay” Exploring Excel 97 Chapter 4 14

Object Linking and Embedding Hands-On Exercise 3 4 Open the Software Memo 4 Copy the Worksheet 4 Create the Link 4 Copy the Chart 4 Add the Chart 4 Modify the Worksheet 4 Update the Links 4 The Finishing Touches Exploring Excel 97 Chapter 4 15

Additional Chart Information 4 Excel has 14 standard chart types on the Chart Wizard 4 Line used to display timerelated information 4 Combination uses two or more charts 4 Use Accurate Labels 4 Don’t add Dissimilar Quantities Exploring Excel 97 Chapter 4 16

Chapter 4 Summary (1 of 2) 4 Charts are an easy to understand way to show data 4 Easiest way to create charts is with the Chart Wizard 4 Charts can be embedded or stored in a separate file 4 Multiple data series may be stored in rows & columns Exploring Excel 97 Chapter 4 17

Chapter 4 Summary (2 of 2) 4 OLE enables creation of compound documents 4 Embedding means storing an object within the compound document 4 Linking means storing the object in its own file, and the compound document uses this file Exploring Excel 97 Chapter 4 18

Practice with Excel 1. Michael Moldof Men’s Boutique 2. Unique Boutiques 3. Hotel Capacities and Room Rates 4. Steven Stocks Memo Exploring Excel 97 Chapter 4 19

Case Studies 4 University Enrollments 4 The Federal Budget 4 The Annual Report 4 Computer Mapping Exploring Excel 97 Chapter 4 20