Creating a Time Plot Using the Chart Wizard
Posted by Dave on January 16, 2002 3:16 AM
I need to create a time plot displaying the varying elevation (feet above sea level) of a lake over a period of twelve years.
Originally, I made a chart on an Excel spreadsheet listing the years (1986-1997)chronologically in the left column and the feet above sea level in the right column. When I used the Chart Wizard, I chose a line graph. However, the feet above sea level showed up on the Y-axis with a range of 0 - 4500 feet. I needed specific numbers on the y-axis (i.e. 3807, 3812, etc.).
Likewise, the years showed up on the x-axis as numbers (i.e., 1,2,3) instead of in year format (i.e., 1986, 1987). Furthermore, the lines (yes, there were 2 instead of 1) on the graph was straight across the graph instead of varying.
What am I doing wrong, and how can I correct it?