Download
1 / 16
160 likes | 162 Vues
This chapter explores the advantages and disadvantages of different chart types, distinguishing between embedded and separate charts, and using arrows and text to enhance charts. It also covers how to differentiate data series in rows versus columns, the accuracy of charts statistically versus conceptually, and creating compound documents with word processing, worksheets, and charts.
E N D
ExploringMicrosoftExcel 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 Chapter 3
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 Chapter 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 Chapter 3
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 Chapter 3
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 Chapter 3
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 The Chart WizardHands-On Exercise 1 Chapter 3
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 Chapter 3
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 Multiple Data SeriesHands-On Exercise 2 Chapter 3
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” Chapter 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 Object Linking and EmbeddingHands-On Exercise 3 Chapter 3
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 Chapter 3
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 Chapter 3
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 Chapter 3
Practice with Excel 1.Michael Moldof Men’s Boutique 2.Unique Boutiques 3.Hotel Capacities and Room Rates 4.Steven Stocks Memo Chapter 3
Case Studies • University Enrollments • The Federal Budget • The Annual Report • Computer Mapping Chapter 3
