Investigating Microsoft Exceed expectations.


69 views
Uploaded on:
Category: Music / Dance
Description
Utilization Drawing toolbar to upgrade diagram with lines, 3D shapes and articles ... Pie and Exploded pie outlines are viable for showing corresponding connections ...
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 points of interest and disservices of various outline sorts Distinguish between an implanted diagram and one in a different outline sheet Use the ChartWizard Use Drawing toolbar to upgrade outline with lines, 3D shapes and protests 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 report comprising of word preparing, worksheet and a graph Exploring Microsoft Excel 2002 Chapter 4

Slide 4

Overview Business design one of most energizing Windows applications Determine message of diagram Create outlines utilizing Chart Wizard Plot numerous information sets on a solitary outline Dynamically interface a diagram to a reminder 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 marks 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 outlines are viable for showing corresponding connections Column diagrams 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 process Step one pick a graph sort Step two audit 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 outline sheet Enhance with Drawing toolbar Exploring Microsoft Excel 2002 Chapter 4

Slide 12

Hands-On Exercise 1 Objective: To make and alter an outline; to install an outline inside a worksheet; to upgrade an outline The AutoSum order Start the Chart Wizard Move and Size the graph Change the worksheet Change the outline sort Create the second diagram 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 outline What would you like to accentuate? 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 portrays aggregates by class rather than every individual information point Useful when you need to analyze sums by classification Exploring Microsoft Excel 2002 Chapter 4

Slide 16

Hands-On Exercise 2 Objective: To plot various information arrangement in the same outline; to separate between information arrangement in lines and segments; to make numerous graphs connected with the same worksheet Rename the worksheets The Office Assistant View the information arrangement Copy the diagram sheet Change the source information Change the diagram 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 an archive in one application that contains objects from another application For instance, contain a Word report that contains objects from an Excel worksheet Embedded item is put away in the record an Excel diagram turns out to be a piece of the Word report Linked article is put away in its own particular document any adjustment in this document is naturally reflected in the principle archive 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 archive comprising of a notice, worksheet, and outline Open the product deals record Copy the worksheet Create the connection Copy the diagram Add the outline 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 diagrams is with the Chart Wizard Charts can be implanted or put away in a different document Multiple information arrangement might be put away in lines & segments Exploring Microsoft Excel 2002 Chapter 4

Slide 21

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

Recommended
View more...