Excel Timeline Creator - Download as Excel by k6oDS4

VIEWS: 0 PAGES: 12

									                     Edit the cells shaded in blue.
                               Chart Title
                          Lincoln at Gettysburg                              Lincoln at Gettysburg
Event # Date     Event                                Height   Date          Event        Height
   1      1800   Born 01/15/1800                        20            1800 Born 01/15/1800         20
   2      1810   cats                                   13            1810 cats                    13
   3      1820   died                                   -9            1820 died                     -9
   4      1830   chickens hatched                       -6            1830 chickens hatched         -6
   5      1840   fajitas                                12            1840 fajitas                 12
   6      1850   log jam                                 7            1850 log jam                  7
   7      1860   horses out again                      -14            1860 horses out again -14
   8      1870   loaded again over night at louies      20                                    20
                                                                      1870 loaded again over night at louies
   9      1880   hogs out                               -9            1880 hogs out                 -9
  10      1890   rover                                  12            1890 rover                   12
  11      1900   feet                                   15            1900 feet                    15
  12      1910   hearts                                 18            1910 hearts                  18
  13      1920   children                              -21            1920 children                -21
  14      1923   hayfield                               17            1923 hayfield                17
  15      1926   fifteen                               -18            1926 fifteen                 -18
  16      1929   sixteen                                14            1929 sixteen                 14
  17      1932   seventeen                             -15            1932 seventeen               -15
  18      1935   eighteen                               11            1935 eighteen                11
  19      1938   nineteen                              -12            1938 nineteen                -12
  20                                                                     0            0             0
                                                Lincoln at Gettysburg
                                                                   loaded again over night at
     Born 01/15/1800
                                                                            louies                  hearts     hayfield
                                                                                             feet                   sixteen
             cats                     fajitas                                       rover                                eighteen
                                                 log jam


 1800               1820          1840               1860              1880              1900           1920              1940
                              chickens hatched
                       died                                                   hogs out
                                                                                                                              nineteen
                                                           horses out again                                              seventeen
                                                                                                                   fifteen
                                                                                                             children




                                                      For Excel Version 2007
To change horizontal Axis scale: If using the automatic scale, the horizontal axis will set the minimum value to zero if all
20 points are not used. To use fixed scale, click on the graph, when "chart tools" shows at the very top of the page click on
"layout" right below it. Then click on "axes" and "primary horizontal axis" and then at the bottom of the drop down menu
"more primary horizontal axis options." From the menu that will appear click on "fixed" and enter the minimum value for
your axis. Click on "fixed" in the next line and enter the maximum value for your horizontal axis. It should now be
configured properly.
To change horizontal Axis scale: If using the automatic scale, the horizontal axis will set the minimum value to zero if all
20 points are not used. To use fixed scale, click on the graph, when "chart tools" shows at the very top of the page click on
"layout" right below it. Then click on "axes" and "primary horizontal axis" and then at the bottom of the drop down menu
"more primary horizontal axis options." From the menu that will appear click on "fixed" and enter the minimum value for
your axis. Click on "fixed" in the next line and enter the maximum value for your horizontal axis. It should now be
configured properly.

								
To top