1 / 26

Objectives

Exploring Office 2003 - Grauer and Barber. 2. Objectives. Explain several types of chartsDescribe an Embedded Chart (vs. a chart in its own sheet)Create and Modify a Chart

oshin
Download Presentation

Objectives

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. Exploring Office 2003 - Grauer and Barber 1 Exploring Microsoft Excel 2003

    2. Exploring Office 2003 - Grauer and Barber 2

    3. Exploring Office 2003 - Grauer and Barber 3 What is a Chart? 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

    4. Exploring Office 2003 - Grauer and Barber 4 Chart Types Keep it simple Use the appropriate chart type Pie and Exploded pie charts display proportional relationships Column charts display numbers rather than percentages Bar charts display numbers horizontally

    5. Exploring Office 2003 - Grauer and Barber 5 Pie Charts

    6. Exploring Office 2003 - Grauer and Barber 6 Column Charts ..

    7. Exploring Office 2003 - Grauer and Barber 7 Creating A Chart Two ways to create Embed chart in worksheet Sizing handles allow you to size, move, copy, or delete an embedded chart Create in separate chart sheet Charts are linked to underlying data A change in the data instantly updates the chart(s) created on that data

    8. Exploring Office 2003 - Grauer and Barber 8 Using the Chart Wizard Select the cells that contain the data Click the Chart Wizard button on the standard toolbar Select the chart type Check the data series Complete the chart options Choose the location

    9. Exploring Office 2003 - Grauer and Barber 9 Choose the Chart Type

    10. Exploring Office 2003 - Grauer and Barber 10 Check the Data Series

    11. Exploring Office 2003 - Grauer and Barber 11 Complete the Chart Options ..

    12. Exploring Office 2003 - Grauer and Barber 12 Choose the Location

    13. Exploring Office 2003 - Grauer and Barber 13 Modifying a Chart Add labels, change the data type, or format the chart with the Chart toolbar Add text boxes, arrows and other objects for emphasis with the Drawing toolbar

    14. Exploring Office 2003 - Grauer and Barber 14 Enhancing a Chart

    15. Exploring Office 2003 - Grauer and Barber 15 Moving and Sizing the Chart

    16. Exploring Office 2003 - Grauer and Barber 16 Multiple Data Series Select multiple data series when you want to see individual data points rather than totals Determine whether data series are in rows or columns Data points plotted are the same either way, but grouping will be different.

    17. Exploring Office 2003 - Grauer and Barber 17 Rows Versus Columns If data series are in rows First row is used for category labels Remaining rows are used for data series First column is used for the legend text If data series are in columns First column is used for category labels Remaining columns are used for data series First row is used for legend text

    18. Exploring Office 2003 - Grauer and Barber 18 Data Series in Rows

    19. Exploring Office 2003 - Grauer and Barber 19 Data Series in Columns

    20. Exploring Office 2003 - Grauer and Barber 20 Stacked Column Charts Depicts totals by category instead of each individual data point Each data point is plotted as part of a whole Useful when you want to compare totals by category

    21. Exploring Office 2003 - Grauer and Barber 21 Example of Stacked Column Chart

    22. Exploring Office 2003 - Grauer and Barber 22 Object Linking and Embedding Create a document in one application that contains 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 any change in this file is automatically reflected in the main document

    23. Exploring Office 2003 - Grauer and Barber 23 Linking A Worksheet

    24. Exploring Office 2003 - Grauer and Barber 24 Updating Links

    25. Exploring Office 2003 - Grauer and Barber 25 Summary Charts graphically represent data in a worksheet Select chart type based on the message you are trying to convey Create with the Chart Wizard Can be embedded onto a worksheet or created on a separate chart sheet

    26. Exploring Office 2003 - Grauer and Barber 26 Summary (continued) Multiple data series may be specified in either rows or columns Same data points, but different grouping gives different comparison Object Linking and Embedding (OLE) creates a compound document Contains objects from multiple applications Embedding � the object is stored within the compound document Linking � the object is stored as a separate file

More Related