How Do You Create A Line Graph In Excel 2007?
Using world population census data as an example, learn how to efficiently graph data in a line graph using Microsoft Excel 2007. A video intended to accompany these instructions can be found at: http://www.youtube.com/watch?v=Rn_275psJFc Open Microsoft Excel. You see a blank grid with numbers in a column along the left side of the screen, and letters running across the top row. For the purposes of this tutorial, U.S. Census data of the world population will be used (provided from http://www.census.gov/ipc/www/idb/worldpop.php). Open your internet browser to the URL provided above. For example purposes, use data from the years 2000 through 2010. Left-click column A, Row 1 (A1). Type the title of your x values, in this instance being ‘Year’. Type 2000 into A2. Type 2001 into A3. Left-click and hold A2, then drag to A3 and release. Move the cursor to the bottom right corner of A3. The cursor turns into a thin black cross. Click and hold, then drag down to the bottom of A12 and release. Y
