Vermilion Parish Population Using Excel

(Information used was from the 2000 US Bureau Census)

Printable Written Directions  MS Word-Population 1   PDF File-Population 1
Printable Guided Directions (with Photos) MS Word Population 2   PDF File Population 2

Printable Population (No Directions) MS Word
Printable Population (No Directions) PDF FILE

1.         Go in your start menu and locate “Excel”
          (It may be located in your Microsoft Office” Set Up)

2.                Under “A” column near #1, type in the City Name “Abbeville”.

3.                Now slide to Column B (still on line 1) and type in the population “11,887

4.                Under “A” column near #2, type in the City Name “Kaplan”.

5.                Now slide to Column B (still on line 2) and type in the population “5,177

6.                Under “A” column near #3, type in the City Name “Erath”.

7.                Now slide to Column B (still on line 3) and type in the population “2,187

8.                Under “A” column near #4, type in the City Name “Delcambre”.

9.                Now slide to Column B (still on line 4) and type in the population “2,168

10.           Under “A” column near #5, type in the City Name “Gueydan”.

11.           Now slide to Column B (still on line 6) and type in the population “1,598

12.           Under “A” column near #1, type in the City Name “Maurice”.

13.           Now slide to Column B (still on line 6) and type in the population “642

14.           Once the data for this entered, go to “the last box and click on the cursor and leave it down then draw it to the left (toward Maurice) and then drag it straight up.

16.           Now go under “Insert” at the top and click “Charts” and decide the type of chart you want to display.

17.           Click “Next” at the bottom.

18.           Type in the Title “Vermilion Parish Population.

19.           Then click the button that says “as new sheet” and title it “VP Pop” and click finish.

20.           For different color bars, click on the bar itself and you will see the color chart pop up.  Choose the color you want.

21.           Go to the top menu and find “file”.  Then drag it down and find “SAVE DATA SET AS” and click on that.

22.           Save the data as your initials or name and VP POP on the desktop.

            Example: SamVP POP or smvp pop and print.

Hit Counter

Back to VP Kid's Page  

Abbeville Kaplan Erath Delcambre Gueydan Maurice Perry  Forked/Cow Island
Henry/Bancker Pecan Island Mouton Cove Indian Bayou Meaux Vermilion Tourism Lessons VPSB Site
Festivals Resources Animals Museums Un Gout Message Webmaster Roots.web Vermilion Historical Society