Spreadsheet Charts

2018-09-11

Find your own real data online (don't make up numbers I must be able to locate the data) and prepare the charts described below. Create each chart on its own worksheet. Create both charts in the same workbook. You can create new worksheets in a workbook by clicking on the right-most worksheet tab at the bottom of the Excel window (it has a plus sign on it).

Line Chart

[15 pts] Create a line chart. Line charts are used to show how something changes over a period of time, with the x-axis used to display the dates. An example of a line chart would be to display changes in population over a period of years. Your line chart must have at least 3 lines.

         Provide the complete URL of your data source on your data worksheet.

         The type of data must be appropriate for a line chart.

Column Chart

[15 pts] Create a column (vertical) chart. Column charts are used to compare values. Each vertical bar has a label at the bottom. An example of a column chart would be to display costs of different types of a similar product (e.g. different types of cars) at the same time.

         Provide the complete URL of your data source on your data worksheet.

         The type of data must be appropriate for a column chart.

A good source of data is the United States Census Bureau. NOTE: You may NOT have to re-type the data that you get from a web page. You can copy it to the clipboard and paste it into Excel. But there is a catch: all of the data on a row appears in a single cell. To extract the data into multiple cells, you can click on the Data tab and then, in the Data Tools group, click on Text to Columns command. You may have to insert/delete some blanks in the data to make all of the numbers line up before doing this, though. Make your work look professional.

Grading

The purpose of a chart is to quickly convey numeric information. If it takes longer to interpret the chart than it takes to interpret the numbers on your worksheet, something is wrong. If I can't easily understand your chart, you will be docked.