1 / 14

Chapter 3

Chapter 3. Graphs and Charts. Agenda. Chart Object linking and embedding. Chart. Definition Type Creation Chart Wizard, and F11 Modification Multiple data series Rows versus columns. Definition. A graphic representation of data in a worksheet Chart elements

hyun
Download Presentation

Chapter 3

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. Chapter 3 Graphs and Charts

  2. Agenda • Chart • Object linking and embedding

  3. Chart • Definition • Type • Creation • Chart Wizard, and F11 • Modification • Multiple data series • Rows versus columns

  4. Definition • A graphic representation of data in a worksheet • Chart elements • Category labels: descriptive text entries • Data points: numeric values • Data series: a grouping of data points

  5. Type • Pie, exploded pie, and three dimensional pie charts • Display proportional relationships • Column charts • Display numbers rather than percentages • Bar charts • Display numbers horizontally • Line charts • Display time-related information • Stacked column charts • Display totals by category instead of each individual data point • Plot each data point as part of a whole • Compare totals by category

  6. Creation • Two methods • Embed chart in worksheet • Sizing handles allow you to size, move, copy, or delete an embedded chart • Create in separate chart sheet • A change in the data instantly updates the chart(s) created on that data

  7. Chart Wizard • Select the cells that contain the data and category using ctrl key • Click the Chart Wizard button on the standard toolbar • Select the chart type • Check the data series • Complete the chart options • Choose the location

  8. Modification • Chart toolbar: to add labels, change the data type, or format the chart • Tool menu, customize, toolbars, chart • Drawing toolbar: to add text boxes, arrows and other objects for emphasis • Format the data series • Right click one of the data series

  9. Multiple Data Series • Purpose: to see individual data points rather than totals • Data series in rows or columns • The same data points plotted with different grouping

  10. Rows Versus Columns • Data series in rows • First row is used for category labels • Remaining rows are used for data series • First column is used for the legend text • Data series in columns • First column is used for category labels • Remaining columns are used for data series • First row is used for legend text

  11. Worksheet Operation • Hide or unhide • Format menu, sheet • Move • Select and drag • Right click the name tab of the worksheet • Copy • Press Ctrl key with select and drag • Right click the name tab of the worksheet • Rename • Double clicks • Right click the name tab of the worksheet

  12. Object Linking and Embedding • Create a document in one application containing objects from another application • Embedded object is stored in the document • An Excel chart becomes part of the Word document • Linked object is stored in its own file • Update any change by edit menu, link

  13. Points to Remember • Chart • Definition • Type • Creation: Chart Wizard, and F11 • Modification • Multiple data series • Object linking and embedding

  14. Assignment • Practice exercise 5 and 8 • Due date:

More Related