Investigating Microsoft Exceed expectations.


71 views
Uploaded on:
Description
Investigating Microsoft Exceed expectations Part 4 Diagrams and Graphs: Conveying a Message By Robert T. Grauer Maryann Hairdresser Destinations (1 of 2) Know points of interest and burdens of various outline sorts Recognize an implanted diagram and one in a different graph sheet Utilize the ChartWizard
Transcripts
Slide 1

Investigating Microsoft Excel Chapter 4 Graphs and Charts: Delivering a Message By Robert T. Grauer Maryann Barber Exploring Microsoft Excel 2002 Chapter 4

Slide 2

Objectives (1 of 2) Know favorable circumstances and disservices of diverse diagram sorts Distinguish between an inserted outline and one in a different diagram sheet Use the ChartWizard Use Drawing toolbar to upgrade diagram with lines, 3D shapes and articles Exploring Microsoft Excel 2002 Chapter 4

Slide 3

Objectives (2 of 2) Differentiate between information arrangement indicated in lines versus ones in sections Create a compound archive comprising of word preparing, worksheet and a graph Exploring Microsoft Excel 2002 Chapter 4

Slide 4

Overview Business representation one of most energizing Windows applications Determine message of graph Create outlines utilizing Chart Wizard Plot various information sets on a solitary diagram Dynamically interface a graph to an update Exploring Microsoft Excel 2002 Chapter 4

Slide 5

What is a Chart? A realistic representation of information in a worksheet Based on engaging (content) sections called class names and numeric qualities called information focuses Data arrangement: a gathering of information focuses Exploring Microsoft Excel 2002 Chapter 4

Slide 6

Chart Types never forget to keep it straightforward and clear Pie and Exploded pie diagrams are compelling for showing corresponding connections Column outlines are utilized for showing numbers Bar graphs show numbers on a level plane Exploring Microsoft Excel 2002 Chapter 4

Slide 7

Pie Charts Exploring Microsoft Excel 2002 Chapter 4

Slide 8

Column Charts Exploring Microsoft Excel 2002 Chapter 4

Slide 9

Creating A Chart Select the phones containing your names and information focuses Use the Chart Wizard a four stage procedure Step one pick a diagram sort Step two survey information arrangement Step three last touches Step four where to store Exploring Microsoft Excel 2002 Chapter 4

Slide 10

Chart Wizard Exploring Microsoft Excel 2002 Chapter 4

Slide 11

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

Slide 12

Hands-On Exercise 1 Objective: To make and adjust an outline; to insert a graph inside of a worksheet; to improve a graph The AutoSum order Start the Chart Wizard Move and Size the diagram Change the worksheet Change the diagram sort Create the second outline Add a content box Create a 3-D Shape Exploring Microsoft Excel 2002 Chapter 4

Slide 13

Using the Drawing toolbar Exploring Microsoft Excel 2002 Chapter 4

Slide 14

Multiple Data Series Decide what message to pass on with the diagram What would you like to stress? Lines versus segments If information arrangement are in lines the Chart Wizard will utilize first line for X pivot and utilize first section for legend content If information arrangement are in segments the Chart Wizard will utilize first segment for X hub and utilize first line for legend content Exploring Microsoft Excel 2002 Chapter 4

Slide 15

Stacked Column Charts A segment diagram that delineates sums by classification rather than every individual information point Useful when you need to look at aggregates by classification Exploring Microsoft Excel 2002 Chapter 4

Slide 16

Hands-On Exercise 2 Objective: To plot various information arrangement in the same graph; to separate between information arrangement in lines and segments; to make numerous outlines connected with the same worksheet Rename the worksheets The Office Assistant View the information arrangement Copy the outline sheet Change the source information Change the graph sort Exploring Microsoft Excel 2002 Chapter 4

Slide 17

Using Multiple Data Series Exploring Microsoft Excel 2002 Chapter 4

Slide 18

Object Linking and Embedding Create a record in one application that contains objects from another application For instance, contain a Word archive that contains objects from an Excel worksheet Embedded article is put away in the report an Excel outline turns out to be a Word\'s piece archive Linked item is put away in its own particular document any adjustment in this document is naturally reflected in the fundamental report Multitasking – the capacity to have more than one application open in the meantime Exploring Microsoft Excel 2002 Chapter 4

Slide 19

Hands-On Exercise 3 Objective: To make a compound report comprising of a reminder, worksheet, and graph Open the product deals archive Copy the worksheet Create the connection Copy the graph Add the graph Modify the worksheet Update the connections The completing touches Exploring Microsoft Excel 2002 Chapter 4

Slide 20

Summary (1 of 2) Charts are a straightforward approach to show information Easiest approach to make outlines is with the Chart Wizard Charts can be implanted or put away in a different document Multiple information arrangement may be put away in lines & segments Exploring Microsoft Excel 2002 Chapter 4

Slide 21

Summary (2 of 2) OLE empowers formation of compound archives Embedding means putting away an item inside of the compound archive Linking means putting away the article in its own particular record, and the compound archive utilizes this document Exploring Microsoft Excel 2002 Chapter 4

Slide 22

.:tslidese

Recommended
View more...