110 likes | 126 Views
CSCI-235 Micro-Computers in Science. Microsoft Excel 2002 Chapter 4 Graphs and Charts: Delivering a Message. What is a Chart?. A graphic representation of data in a worksheet Based on descriptive (text) entries called category labels and numeric values called data points
E N D
CSCI-235Micro-Computers in Science Microsoft Excel 2002 Chapter 4 Graphs and Charts: Delivering a Message
What is a Chart? • A graphic representation of data in a worksheet • Based on descriptive (text) entries called category labels and numeric values called data points • Data series: a grouping of data points Exploring Microsoft Excel 2002 Chapter 4
Chart Types • Always remember to keep it simple and clear • Pie and Exploded pie charts are effective for displaying proportional relationships • Column charts are used for displaying numbers • Bar charts show numbers horizontally Exploring Microsoft Excel 2002 Chapter 4
Pie Charts Exploring Microsoft Excel 2002 Chapter 4
Column Charts Exploring Microsoft Excel 2002 Chapter 4
Creating A Chart • Select the cells containing your labels and data points • Use the Chart Wizard a four step process • Step one choose a chart type • Step two review data series • Step three final touches • Step four where to store Exploring Microsoft Excel 2002 Chapter 4
Chart Wizard Exploring Microsoft Excel 2002 Chapter 4
Finishing the Chart • Embedding in a worksheet or separate chart sheet • Enhance with Drawing toolbar Exploring Microsoft Excel 2002 Chapter 4
Using the Drawing toolbar Exploring Microsoft Excel 2002 Chapter 4
Using Multiple Data Series Exploring Microsoft Excel 2002 Chapter 4
Object Linking and Embedding • Create a document in one application that contains objects from another application • For example, contain a Word document that contains objects from an Excel worksheet • Embedded object is stored in the document • an Excel chart becomes part of the Word document • Linked object is stored in its own file • any change in this file is automatically reflected in the main document • Multitasking – the ability to have more than one application open at the same time Exploring Microsoft Excel 2002 Chapter 4