Essential Question: How can a chart be altered to show deceptive data?

Enter this data in Excel™.

Increases in Expenses
2001
$2,000
2002
$2,078
2003
$3.110
2004
$3,250
2005
$3,400
2006
$3,550

  • Make a line graph with the data from this table.
  • To use years as labels...at Step 2 of the Chart Wizard, click on Series. Remove Series 1.
  • At Step 3:
    • complete Title and Axes names.
    • remove the legend
  • Complete the chart

  • Make a second chart following the directions above
  • Click on the numbers in the Y axis
  • Go to Format...Selected axis...change the range

updated Thursday, May 28, 2009
©2007 Miles River Middle School | Contact us