Skip to Content
Home
Maps
Calendar
Site Index / Search
Directory
  St. Edward's University

Computer Competency Requirement Navigation Bar
Competency Index
Competency Tutorial Index
Competency Glossary
Competency Site Index
Module 5 - Spreadsheets
Lesson 6 - Index Creating Charts
Exercise 2

This exercise is designed to test your knowledge of ways to create a chart.

A chart is a graphical representation of data in a worksheet.

 
A data label is the key to the data represented by a chart.
 
A column chart shows changes in data over a period of time or illustrates comparisons among items.  
 
Data Series is a group of related data points plotted in a chart that originate from rows or columns on a single worksheet.
 
It is possible to create a chart from cells that are not adjacent to one another by holdoing down the Alt key on the PC, or the Alt key on the Mac while selecting the cells.
 
You can change the type of chart after it has been created by selecting the Chart Menu and clicking on Chart Type.
 
A pie chart shows the relationship of items that make up a data series to the sum of the items.
 
A bar chart shows trends in data at equal intervals.

 

 

Module 5 Lesson 6 Exercise 1
Module 5 Lesson 7 Index

 

 
St. Edward's University Logo St. Edward's University
3001 South Congress Avenue
Austin, Texas 78704
512-448-8400
Contact: itccmail@stedwards.edu
Updated: 09/2007
© 2003, St. Edward's University