pasobze.blogg.se

Using excel for timelines in genealogy
Using excel for timelines in genealogy




  1. #Using excel for timelines in genealogy how to
  2. #Using excel for timelines in genealogy software
  3. #Using excel for timelines in genealogy professional

Timelines list events in a chronological order on a horizontal timescale.

#Using excel for timelines in genealogy professional

Excel does not offer a native way to create a timeline, but we can tweak a XY-plot to create a professional looking timeline.

#Using excel for timelines in genealogy how to

Julie Miller is a certified genealogists.This step-by-step Excel for Office 365 timeline tutorial explains how to create professional timelines using Microsoft’s popular spreadsheet tool. They are invaluable for analyzing and interpreting genealogical data and they add life and substance to your research.

#Using excel for timelines in genealogy software

Genelines and Genealogy Timeline are software programs designed specifically for making genealogy timelines.There also are Web sites that offer free timelines, such as .Ĭonsider adding timelines to your genealogical toolbox. Historical information for use in timelines can be found in history timetable books and historical event Web sites, such as “Timelines in History.” Some good sources for local events are state, county and town Web sites, published histories and historical societies.Ī timeline can be made using a word processor, spreadsheet program, a pencil and paper, special timeline software or a genealogy program that has built-in timeline software. The flood certainly impacted the family’s life and should be included in their timelines. Most of the city was under water, including my grandfather’s house. For example, Newport, Ky., was devastated by a flood in 1937. In many cases, regional and local events had more of an effect on an ancestor’s daily life than national or world events. For instance, anyone living in the United States in 1861 should have an entry for the American Civil War. Adding these events to a timeline will add depth to your research and place an ancestor in historical context. World and national events, such as wars and natural disasters, might have impacted an ancestor’s life. It will often direct the focus of future research efforts by identifying missing information. A timeline, like the one above, can aid in uncovering inconsistencies in data and exposing inaccurate conclusions about that data. This partial timeline of Theresa Huber’s life documents all the various stages of her life. Every source that mentions your ancestorshould be in their timeline.Ģ2 February 1834 - born: Steinbach, Baden, Germanyġ7 September 1861 - marriage to Anselm Huck: Steinbach, Baden, GermanyĢ3 June 1862 - birth of daughter Elizabeth: Steinbach, Baden, GermanyĦ June 1873 - death of husband: Steinbach, Baden, GermanyĢ0 November 1879 - immigrated: Port of New York, New Yorkġ June 1900 - census: Cincinnati, Hamilton Co., Ohio Items to include in a timeline are: Birth marriages divorces census directories education occupation land transactions military service immigration religious affiliation birth of family members, such as parents, siblings, spouse, children, grandchildren death of family members witnesses to events, such as marriages, baptisms wills retirement death burial and probate. Adding the ancestor’s age at the time of the event also is useful when evaluating information about things such as marriage, birth dates of children and military service. Start by making a list of every known fact about an ancestor. Depending on what I plan to use it for, I have made both plain lists and the more complex line structures. It can be as simple or as complicated as you like. In the case of an ancestor, it is a list of events from birth to death. Creating a timeline of an ancestor’s life will help you see their whole life picture instead of just the bits and pieces.Ī timeline is a chronological list of events. With all that data, it can be difficult to see how parts of an ancestor’s life fit together. If you look at your family history, you will likely find lots of facts organized in genealogy software or written on Family Group Sheets and Pedigree Charts.






Using excel for timelines in genealogy