Spreadsheet+L+7




 * Lesson Seven - Introducing Charts**

A **spreadsheet** is a quick and precise way to calculate and manipulate data. However, in this day and age columns of numbers generally do not attract peoples attention. You need visual representation of data, which are called graphs or **charts**. Studies have shown that people remember more information when it is presented graphically. For this reason spreadsheet data can be presented in a chart to show the relationship between data. The three most commonly used chart types are pie, bar and line. __** PIE CHARTS **__ A pie chart can chart only one series of data, with each slice representing a value from the series. The size of the slice varies with its percentage of the total:

Enter the following data into a spreadsheet, and through trial and error, try to reproduce the chart at the right of the image. //__**In order to create a graph, you must first tell the computer what you want to graph by selecting the data that you want to appear in your graph. Don't forget to select both the values and the names. (A2-B7)**__// Then identify the following parts of the graph and sheet:


 * series
 * title
 * labels
 * slice
 * legend

__**BAR Graphs **__ __**Before you begin your second graph, look at the bottom of the sheet you are working on. You should see little tabs that say Sheet 1, Sheet 2, Sheet 3. Do your second graph on the second sheet, and your third graph on your third sheet.**__ A bar graph can chart several series of data, with each bar representing a value. The size of the bar varies depending on the value it represents, with larger bars corresponding to longer bars. Bar charts are therefore useful in comparing the differences between values. Enter the following data into a spreadsheet, and through trial and error, try to reproduce the chart at the right of the image. Don't forget to select both the values and the names. (A3-B9) *Hint - To set the teacher expectation,when you begin creating your chart, click the series tab, and add a new series called "Teacher Expectation." Then identify the following parts of the graph and sheet:
 * Category x Axis title
 * labels

__**LINE CHARTS **__ A Line chart can represent several series of data with each line representing a series. The values in a series are represented by a number on the line. Line charts are therefore useful for displaying the differences of data over a period of time. For example the following chart shows average temperatures in three different cities over the course of a year. Enter the following data into a spreadsheet, and through trial and error, try to reproduce the chart at the right of the image. Note how I moved the data around inside the graph once I finished it.