Programs: Microsoft ExcelChapter 4: Lesson #1

Lesson #1: The following section will give you a definition of the term chart, explain about the use of charts and show you what charts consist of.
The main topics of Lesson #1 are:
  • Defining charts and graphs
  • The usefulness of charts and graphs
  • Components of a graph
  • Where the data comes from
  • More places charts are found
Lesson #1: Lets define what a chart is.
Topic # 1 Defining charts and graphs

A chart or graph is a graphic representation of data used to deliver a message.
Topic # 2 The usefulness of charts and graphs
Charts and graphs are useful visual aids.  They can help clarify the message you are trying to convey. 
Topic # 3 Components of a graph
There are 4 components of a graph:  Title, Data Points, Category Labels, and Data Series.
Title: should be short but informative
Data Points: separate numerical values on the chart
Category Labels: descriptive entries on the chart
Data Series: group of data points which comprise the chart
Topic # 4 Where does the data come from?
To create your chart or graph you must use the data you have entered into Excel. An example of a spreadsheet appears on the left.
Topic # 5 Where charts are found
You find charts and graphs everywhere you look.  Specifically they can be found in newspapers, magazines, research, learning aids, scientific journals, statistical surveys, television, presentations, reports, and many other locations.

Lesson Review

In this lesson you have learned:
  • How to define charts and graph 
  • How to use charts and graphs to help present your ideas
  • The components of a graph: Title, Data Points, Category Labels, Data Series
  • Where the data comes from: Excel spreadsheets
  • Where charts are found

continue to lesson #2

Back to Lessons 

Programs: Microsoft Excel Chapter 4: Lesson #1