A Tutorial for Excel 2002 for Windows

Short Description
Using Charts with Microsoft Excel 2002. A Tutorial for Excel. 2002 for Windows. AUTHOR: Information Systems Services. DATE: August 2004. EDITION: 2.0 …

Website: www.leeds.ac.uk | Filesize: 568kb

Content
INFORMATION SYSTEMS SERVICES
Using Charts with Microsoft Excel 2002
A Tutorial for Excel 2002 for Windows
AUTHOR: Information Systems Services
DATE: August 2004
EDITION: 2.0
TUT 49
UNIVERSITY OF LEEDSContents
1.0 Introduction………………………………………………………………………………………1
1.1 About Spreadsheet Software…………………………………………………………….1
1.2 Aim of this Document……………………………………………………………………..1
1.3 Prerequisites…………………………………………………………………………………..1
2.0 Charts……………………………………………………………………………………………….2
2.1 Data Types…………………………………………………………………………………….2
2.2 Chart Types……………………………………………………………………………………2
2.3 Chart Selection……………………………………………………………………………….3
2.4 Chart Features………………………………………………………………………………..3
Task 1 Creating a Column Chart………………………………………………………4
3.0 Editing………………………………………………………………………………………………7
3.1 The Chart Toolbar…………………………………………………………………………..7
3.2 The Chart Menu Item………………………………………………………………………8
3.3 Direct Editing…………………………………………………………………………………8
Task 2 Editing the Column Chart……………………………………………………..9
Task 3 Creating a Line Chart………………………………………………………….14
Task 4 Creating a Scatter Plot………………………………………………………..16
Task 5 Finishing Excel………………………………………………………………….19
Format Conventions
In this document the following format conventions are used:
Commands that you must type in are shown in bold Times New Roman font.
WIN31
Menu items are given in a bold, Times New Roman font.
Windows Applications
Keys that you press are enclosed in angle brackets.

Feedback
If you notice any mistakes in this document please contact the Information Officer. Email should be sent to the address info-officer@leeds.ac.uk
Copyright
This document is copyright University of Leeds. Permission to use material in this document should be obtained from the Information Officer (email should be sent to the address info-officer@leeds.ac.uk)
ii…