Exploring Microsoft Excel

Chapter 3

Graphs and Charts: Delivering a Message

Objectives

(1 of 2) • Know advantages and disadvantages of different chart types • Distinguish between an embedded chart and one in a separate chart sheet • Use the ChartWizard • Use arrows and text to enhance a chart Exploring Excel Chapter 3 2

Objectives

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

Overview

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

Chart Types

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

Creating a Chart

• Embedding in a worksheet or separate chart sheet • 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 • Enhance with Drawing toolbar or Chart toolbar Exploring Excel Chapter 3 6

The Chart Wizard

Hands-On Exercise 1 • Start the ChartWizard • Move and Size the Chart • Change the Worksheet • Change the Chart Type • Create the Second Chart • Enhance the Chart • Format the Data Series • Print the Workbook Exploring Excel Chapter 3 7

Multiple Data Series

• What message do you want chart to display • 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 Chapter 3 8

Multiple Data Series

Hands-On Exercise 2 • Rename the Worksheets • The Office Assistant • View the Data Series • Complete the Chart • Copy the Chart Sheet • Change the Source Data • The Stacked Column Chart Exploring Excel Chapter 3 9

Object Linking and Embedding

• Primary advantage of Windows is to create a compound document • Embedded object is stored in the compound document • Linked object is stored in its own file and used with a compound document • OLE pronounced “Oh-lay” Exploring Excel Chapter 3 10

Object Linking and Embedding

Hands-On Exercise 3 • Open the Software Memo • Copy the Worksheet • Create the Link • Copy the Chart • Add the Chart • Modify the Worksheet • Update the Links • The Finishing Touches Exploring Excel Chapter 3 11

Additional Chart Information

• Excel has 14 standard chart types on the Chart Wizard • Line used to display time-related information • Combination uses two or more charts • Use Accurate Labels • Don’t add Dissimilar Quantities Exploring Excel Chapter 3 12

Chapter 3 Summary

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

Chapter 3 Summary

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

Practice with Excel

1.

Michael Moldof Men’s Boutique 2.Unique Boutiques 3.Hotel Capacities and Room Rates 4.Steven Stocks Memo Exploring Excel Chapter 3 15

Exploring Excel

Case Studies

• University Enrollments • The Federal Budget • The Annual Report • Computer Mapping Chapter 3 16