Exploring Microsoft Excel Chapter 3 Graphs and Charts

Exploring Microsoft Excel Chapter 3 Graphs and Charts: Delivering a Message Exploring Excel Chapter 3

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 Chart. Wizard • 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 Chart. Wizard • Move and Size the Chart • Change the Worksheet • Change the Chart Type Exploring Excel • Create the Second Chart • Enhance the Chart • Format the Data Series • Print the Workbook 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 • Copy the Chart Worksheets Sheet • The Office Assistant • Change the Source Data • View the Data Series • The Stacked Column Chart • Complete the 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 Exploring Excel • Add the Chart • Modify the Worksheet • Update the Links • The Finishing Touches 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

Case Studies • University Enrollments • The Federal Budget • The Annual Report • Computer Mapping Exploring Excel Chapter 3 16