Question

Prepare a table, a line graph, and a bar graph to show the following statistical data: According to the 2000 census, the town of Ardmore had a population of 34,567. By the 2010 census, the town’s population had decreased by 4,500. In the 2000 census, the town of Morrison had a population of 23,809, but by the 2010 census, the population had increased by 3,689. The 2010 census figure for the town of Berkesville was 25,675, which was an increase of 2,768 from the 2000 census.

How do I make a line graph for this data using excel? I am having trouble with this since it has multiple years and cities.

Answer 1

	2000	2010
Ardmore	34567	30067
Morrison	23809	27498
Berkesville	25675	28443

formula

	2000	2010
Ardmore	34567	=B2-4500
Morrison	23809	=B3+3689
Berkesville	=25675	=B4+2768

now select all thre columns

go to INSERT , 2-D line , line with markers

40000 35000 30000 25000 20000 15000 10000 5000 0 Ardmore Morrison Berkesville 2000 2010