{"id":1840,"date":"2023-08-14T06:00:00","date_gmt":"2023-08-14T10:00:00","guid":{"rendered":"https:\/\/tech.mountdesales.net\/?p=1840"},"modified":"2023-04-05T10:52:09","modified_gmt":"2023-04-05T14:52:09","slug":"create-a-timeline-in-google-sheets","status":"publish","type":"post","link":"https:\/\/tech.mountdesales.net\/?p=1840","title":{"rendered":"Create a Timeline in Google Sheets"},"content":{"rendered":"\n

Original article is at https:\/\/www.techrepublic.com\/article\/how-to-create-timeline-google-sheets\/<\/a><\/p>\n\n\n\n

Visualize planned projects or historical events in a timeline created from a range of cells in Google Sheets on the web.<\/p>\n\n\n\n

[NOTE: This is done in a web browser
on a desktop or laptop – NOT the ipad]<\/p>\n\n\n

\n
\"\"
Creating a timeline from Google Sheets<\/figcaption><\/figure><\/div>\n\n\n

In November 2022, Google Sheets added a\u00a0timeline view<\/a>, which lets you select a set of cells that contain text and dates and create a new spreadsheet tab that displays those items in a horizontal timeline where each event row displays as a discrete item in the timeline. This type of timeline may be most useful to visualize future events, such as project plans or forecasts. It also may aid understanding of past events, such as for after-action analysis or historical studies.<\/p>\n\n\n\n

To create or display timelines, you\u2019ll need to use Google Sheets<\/a> on the web with a desktop browser, such as Chrome.<\/p>\n\n\n\n

1. Enter events, dates and durations<\/h2>\n\n\n\n

First, you\u2019ll need to enter at least two pieces of data for each event you want to display in your timeline: An event name and a date. The event name should be a word \u2014 or a few words \u2014 that encapsulates the essence of the timeline event. The date simply needs to be any standard-format year, month and day.<\/p>\n\n\n\n

In many cases, you\u2019ll also want to specify either an end date or duration of the event. This additional component of information allows the system to show not only single-day events, but also multi-day, multi-month or even multi-year events.<\/p>\n\n\n\n

The example spreadsheet in Figure A<\/strong> shows a sample software selection process, with columns that indicate an activity (column A) along with separate cells that specify a start date (column B) and end date (column C) of each phase.<\/p>\n\n\n\n

Figure A<\/strong><\/p>\n\n\n\n

\"Enter
Enter events and dates, then select Insert > Timeline in Google Sheets on the web to create a timeline.<\/figcaption><\/figure>\n\n\n\n

2. Create a timeline<\/h2>\n\n\n\n

From within the spreadsheet with your entered events and dates, select Insert > Timeline. This brings up a prompt that allows you to enter the spreadsheet range for your timeline data. The example indicates that the timeline will use data in Sheet1 cells from A2 to C13, or Sheet1!A2:C13 (Figure A<\/strong>).<\/p>\n\n\n\n

Enter the range for your timeline events and dates, then select OK. The system will create and insert a new timeline sheet, as shown in the lower-left of Figure A<\/strong>, between Sheet 1 and Sheet 2.<\/p>\n\n\n\n

3. Modify scale<\/h2>\n\n\n\n

The default display of a newly-created timeline may not necessarily place all events in view. You might select one of the longer-duration options from the timescale drop-down menu (e.g., days, weeks, months, quarters, years or multiyear) to adjust the view as desired. In Figure B<\/strong>, I selected Quarters, for example.<\/p>\n\n\n\n

Figure B<\/strong><\/p>\n\n\n\n

\"Adjust
Adjust the time scale for your timeline in Google Sheets as desired.<\/figcaption><\/figure>\n\n\n\n

4. Optional: Group items<\/h2>\n\n\n\n

The timeline also supports the ability to group activities with the addition of another column of data. For example, you might add a column to indicate a person or team responsible for the event demarcated on each row. In Figure C<\/strong>, for example, column A contains the various groups responsible for each step: IT Leadership, All affected groups, Selection team, etc.<\/p>\n\n\n\n

Figure C<\/strong><\/p>\n\n\n\n

\"You
You may enter an additional column of data in Google Sheets by which to group events.<\/figcaption><\/figure>\n\n\n\n

To adjust the display so items are grouped by these general categories, select Settings (between the 100% indicator and the Support options), and then, choose the corresponding column for the Card group dropdown. Figure D<\/strong>, for example, shows the timeline events grouped by Column A content.<\/p>\n\n\n\n

Figure D<\/strong><\/p>\n\n\n\n

\"Timeline
Timeline events are shown here grouped by data in Column A of Google Sheets.<\/figcaption><\/figure>\n\n\n\n

5. Optional: Customize colors<\/h2>\n\n\n\n

You may modify event colors in two different ways.<\/p>\n\n\n\n

First, within the spreadsheet, choose one or more cells, then select the pouring paint bucket icon, and pick a fill color. For example, cells in column A in Figure C<\/strong> are set to different colors to indicate different groups (eg., blue for IT Leadership and green for All affected people).<\/p>\n\n\n\n

Alternatively, from the timeline display, you may select an event, which then displays the Card details to the right of the spreadsheet (Figure E<\/strong>). From this side panel, you may select and then change the card color as desired. The side panel also offers an Edit data button, in the lower right, which when selected, returns you to the sheet that contains the source data for the timeline.<\/p>\n\n\n\n

Figure E<\/strong><\/p>\n\n\n\n

\"To
To adjust an event box color in Google Sheets, either change the fill color for the event cell or select the displayed timeline event and modify the card color from the side panel.<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"

Original article is at https:\/\/www.techrepublic.com\/article\/how-to-create-timeline-google-sheets\/ Visualize planned projects or historical events in a timeline created from a range of cells in Google Sheets on the web. [NOTE: This is done in a web browser on a desktop or laptop – NOT the ipad] In November 2022, Google Sheets added a\u00a0timeline view, which lets you select … Continue reading Create a Timeline in Google Sheets<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[38,30],"tags":[6,498,633,632],"class_list":["post-1840","post","type-post","status-publish","format-standard","hentry","category-google-more","category-more","tag-google","tag-how","tag-sheets","tag-timeline"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p42ogX-tG","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":321,"url":"https:\/\/tech.mountdesales.net\/?p=321","url_meta":{"origin":1840,"position":0},"title":"10th grade iPad App List [2014]","author":"tech","date":"08\/22\/2014","format":false,"excerpt":"Category App Name Core Adobe Reader Core Chrome Core Flashcards* Core Free Graphing Calculator Core Garageband Core Google Docs Core Google Drive Core Google Sheets Core iBooks Core iMovie Core iTunes U Core Kindle Core Meraki Core Moodle mobile Core MyScript Calculator Core Notability Core Photon Core Podcasts Core Show\u2026","rel":"","context":"In "Faculty"","block_context":{"text":"Faculty","link":"https:\/\/tech.mountdesales.net\/?cat=10"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":725,"url":"https:\/\/tech.mountdesales.net\/?p=725","url_meta":{"origin":1840,"position":1},"title":"iPad Apps List – August 2016","author":"Tom Rule","date":"08\/09\/2016","format":false,"excerpt":"Here is the starting iPad apps list on student iPads. This WILL change as we progress during the semester, and it does NOT contain any class-specific apps that will be installed later. UPPER SCHOOL Adobe Acrobat Bible Gateway Building Atoms HD Lite Checkers Free Chess - Learn Chess Chess Free\u2026","rel":"","context":"In "iPads"","block_context":{"text":"iPads","link":"https:\/\/tech.mountdesales.net\/?cat=2"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":323,"url":"https:\/\/tech.mountdesales.net\/?p=323","url_meta":{"origin":1840,"position":2},"title":"11th grade iPad app list [2014]","author":"tech","date":"08\/22\/2014","format":false,"excerpt":"Category App Name Core Adobe Reader Core Chrome Core Flashcards* Core Free Graphing Calculator Core Garageband Core Google Docs Core Google Drive Core Google Sheets Core iBooks Core iMovie Core iTunes U Core Kindle Core Meraki Core Moodle mobile Core MyScript Calculator Core Notability Core Photon Core Podcasts Core Show\u2026","rel":"","context":"In "Faculty"","block_context":{"text":"Faculty","link":"https:\/\/tech.mountdesales.net\/?cat=10"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":325,"url":"https:\/\/tech.mountdesales.net\/?p=325","url_meta":{"origin":1840,"position":3},"title":"12 grade iPad App List [2014]","author":"tech","date":"08\/22\/2014","format":false,"excerpt":"Category App Name Core Adobe Reader Core Chrome Core Flashcards* Core Free Graphing Calculator Core Garageband Core Google Docs Core Google Drive Core Google Sheets Core iBooks Core iMovie Core iTunes U Core Kindle Core Meraki Core Moodle mobile Core MyScript Calculator Core Notability Core Photon Core Podcasts Core Show\u2026","rel":"","context":"In "Faculty"","block_context":{"text":"Faculty","link":"https:\/\/tech.mountdesales.net\/?cat=10"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":536,"url":"https:\/\/tech.mountdesales.net\/?p=536","url_meta":{"origin":1840,"position":4},"title":"2015 iPad App Lists","author":"Tom Rule","date":"07\/16\/2015","format":false,"excerpt":"Scroll down for the Middle school lists. First the Apps that are being used somewhere for some grade or class, then others that are already \"in stock\" but are not. BOLDFACE = paid app Apps that we use - Upper School Art Adobe Photoshop Touch Art Dramatic Black & White\u2026","rel":"","context":"In "Apps"","block_context":{"text":"Apps","link":"https:\/\/tech.mountdesales.net\/?cat=145"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":381,"url":"https:\/\/tech.mountdesales.net\/?p=381","url_meta":{"origin":1840,"position":5},"title":"“There’s not enough room to update to 8”","author":"Tom Rule","date":"10\/09\/2014","format":false,"excerpt":"Check other apps that might be taking up room. Music - delete it all. Photo Stream - turn it off. That takes up room. Google apps - Docs, Sheets, Drive all have an option to access a file offline. Make sure there are no files stored locally. Find the \"On\u2026","rel":"","context":"In "Faculty"","block_context":{"text":"Faculty","link":"https:\/\/tech.mountdesales.net\/?cat=10"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/tech.mountdesales.net\/index.php?rest_route=\/wp\/v2\/posts\/1840","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tech.mountdesales.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech.mountdesales.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech.mountdesales.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tech.mountdesales.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1840"}],"version-history":[{"count":1,"href":"https:\/\/tech.mountdesales.net\/index.php?rest_route=\/wp\/v2\/posts\/1840\/revisions"}],"predecessor-version":[{"id":1842,"href":"https:\/\/tech.mountdesales.net\/index.php?rest_route=\/wp\/v2\/posts\/1840\/revisions\/1842"}],"wp:attachment":[{"href":"https:\/\/tech.mountdesales.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech.mountdesales.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech.mountdesales.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}