Exploring microsoft excel l.jpg
Advertisement
This presentation is the property of its rightful owner.
1 / 21

Exploring Microsoft Excel PowerPoint PPT Presentation

Exploring Microsoft Excel Chapter 4 Graphs and Charts: Delivering a Message By Robert T. Grauer Maryann Barber 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

Download Presentation

Exploring Microsoft Excel

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Exploring microsoft excel l.jpg

Exploring Microsoft Excel

Chapter 4

Graphs and Charts: Delivering a Message

By

Robert T. Grauer

Maryann Barber

Exploring Microsoft Excel 2002 Chapter 4


Slide2 l.jpg

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 Drawing toolbar to enhance chart with lines, 3D shapes and objects

Exploring Microsoft Excel 2002 Chapter 4


Slide3 l.jpg

Objectives (2 of 2)

  • Differentiate between data series specified in rows versus ones in columns

  • Create a compound document consisting of word processing, worksheet and a chart

Exploring Microsoft Excel 2002 Chapter 4


Overview l.jpg

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

Exploring Microsoft Excel 2002 Chapter 4


What is a chart l.jpg

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 l.jpg

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 l.jpg

Pie Charts

Exploring Microsoft Excel 2002 Chapter 4


Column charts l.jpg

Column Charts

Exploring Microsoft Excel 2002 Chapter 4


Creating a chart l.jpg

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 l.jpg

Chart Wizard

Exploring Microsoft Excel 2002 Chapter 4


Finishing the chart l.jpg

Finishing the Chart

  • Embedding in a worksheet or separate chart sheet

  • Enhance with Drawing toolbar

Exploring Microsoft Excel 2002 Chapter 4


Hands on exercise 1 l.jpg

Hands-On Exercise 1

  • Objective: To create and modify a chart; to embed a chart within a worksheet; to enhance a chart

    • The AutoSum command

    • Start the Chart Wizard

    • Move and Size the chart

    • Change the worksheet

    • Change the chart type

    • Create the second chart

    • Add a text box

    • Create a 3-D Shape

Exploring Microsoft Excel 2002 Chapter 4


Using the drawing toolbar l.jpg

Using the Drawing toolbar

Exploring Microsoft Excel 2002 Chapter 4


Multiple data series l.jpg

Multiple Data Series

  • Decide what message to convey with the chart

    • What do you want to emphasize?

  • 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

Exploring Microsoft Excel 2002 Chapter 4


Stacked column charts l.jpg

Stacked Column Charts

  • A column chart that depicts totals by category instead of each individual data point

    • Useful when you want to compare totals by category

Exploring Microsoft Excel 2002 Chapter 4


Hands on exercise 2 l.jpg

Hands-On Exercise 2

  • Objective: To plot multiple data series in the same chart; to differentiate between data series in rows and columns; to create multiple charts associated with the same worksheet

    • Rename the worksheets

    • The Office Assistant

    • View the data series

    • Copy the chart sheet

    • Change the source data

    • Change the chart type

Exploring Microsoft Excel 2002 Chapter 4


Using multiple data series l.jpg

Using Multiple Data Series

Exploring Microsoft Excel 2002 Chapter 4


Object linking and embedding l.jpg

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


Hands on exercise 3 l.jpg

Hands-On Exercise 3

  • Objective: To create a compound document consisting of a memo, worksheet, and chart

    • Open the software sales document

    • Copy the worksheet

    • Create the link

    • Copy the chart

    • Add the chart

    • Modify the worksheet

    • Update the links

    • The finishing touches

Exploring Microsoft Excel 2002 Chapter 4


Slide20 l.jpg

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

Exploring Microsoft Excel 2002 Chapter 4


Slide21 l.jpg

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

Exploring Microsoft Excel 2002 Chapter 4


  • Login