1 / 11

CSCI-235 Micro-Computers in Science

Learn how to create compelling charts in Excel 2002 to deliver messages clearly and concisely. Explore different chart types like pie, column, and bar charts, and understand the Chart Wizard process step by step. Enhance your charts using the Drawing toolbar and master object linking and embedding techniques for multitasking.

cmassey
Download Presentation

CSCI-235 Micro-Computers in Science

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CSCI-235Micro-Computers in Science Microsoft Excel 2002 Chapter 4 Graphs and Charts: Delivering a Message

  2. 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

  3. 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

  4. Pie Charts Exploring Microsoft Excel 2002 Chapter 4

  5. Column Charts Exploring Microsoft Excel 2002 Chapter 4

  6. 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

  7. Chart Wizard Exploring Microsoft Excel 2002 Chapter 4

  8. Finishing the Chart • Embedding in a worksheet or separate chart sheet • Enhance with Drawing toolbar Exploring Microsoft Excel 2002 Chapter 4

  9. Using the Drawing toolbar Exploring Microsoft Excel 2002 Chapter 4

  10. Using Multiple Data Series Exploring Microsoft Excel 2002 Chapter 4

  11. 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

More Related