How to Create a Timeline in Excel

Method 1 of 3:

Using SmartArt (Excel 2007 or Later)

Create a new spreadsheet. SmartArt creates a new graphic layout for you to add data. It does not transform your existing data, so create a new blank spreadsheet for your timeline.
Open the SmartArt menu. Depending on your version of Excel, either click the SmartArt tab in the ribbon menu, or click the Insert tab, then the SmartArt button. This option is available in Excel 2007 or later.
Select the timeline from the Process submenu. Click Process in the SmartArt ribbon menu, in the Insert Smart Art Graphic group. In the drop-down menu that appears, select Basic Timeline (a right-facing arrow).
1. You can adapt various other Process graphics to use as timeline. To see the name of each graphic, move your cursor over the icon and wait until the hover text appears.
Add more events. By default you only start out with a few events. To add more, select the timeline. A Text Pane should appear to the left of the graphic. Click the + button at the top of the text pane to add a new timeline event.
1. To enlarge the timeline without adding new events, click the timeline to show a box outline. Drag the right or left side of the box outward.
Edit your timeline. Type in the Text Pane box to add entries. You can also copy-paste data into the timeline and have Excel guess at how to arrange it. Typically, you'll end up with each column of data as a single timeline entry.

Method 2 of 3:

Using Pivot Table Analysis (Excel 2013 or Later)

Open the spreadsheet that has a pivot table. In order to automatically generate a timeline, your data must be organized into a pivot table. You also need the pivot table analyze menu, which was introduced in Excel 2013.^{[1] X Research source}
Click anywhere inside the pivot table. This will open the 'PIVOT TABLE TOOLS' in the top ribbon.
Click 'Analyze'. This will open a ribbon with options to manipulate the data in the table.
Click 'Insert Timeline'. A dialog box will pop up showing fields that correspond to a date format. Note that dates entered as text will not be recognized.
Select the Applicable field and click OK. A new box that allows you to navigate through your timeline will appear.
Select how the data will be filtered. Depending on the available information you can select how the data will be filtered. (Either by months, years or quarters).
Examine monthly data. When you click on a month in the Timeline Control Box, the pivot table will show data that pertains to that particular month alone.
Broaden your selection. You may widen your selection by clicking and dragging the sides of the slider.

Method 3 of 3:

Using a Basic Spreadsheet (Any Version)

Consider downloading a template. While not necessary, a template will save you some work by setting up the timeline structure for you. You can check whether you already have a timeline template by browsing options in the File → New or File → New from Template commands. Otherwise, search online for user-created timeline templates. If you don't want to use a template, continue on to the next step.
1. If your timeline tracks the progress of a multi-branched project, consider looking for "Gantt chart" templates instead.^{[2] X Research source}
Start your own timeline from ordinary cells. You can set up a basic timeline with an ordinary blank spreadsheet. Type the dates of your timeline in one row, spacing them out with blank cells roughly in proportion to the time between them.
Write your timeline entries. In the cell directly above or below each date, write a description of the event that happened on that date. Don't worry if it looks sloppy.
1. Alternating descriptions above and below the date tend to make the most readable timelines.
Angle the descriptions. Select the row containing your descriptions. Click the Home tab in the ribbon menu, then look for the Orientation button under the Alignment group. (In some versions, the Orientation button looks like the letters abc.) Click this button and select one of the angled text options. The rotated text should make your descriptions fit the timeline.
1. If you are using Excel 2003 or earlier, instead right-click the selected cells. Select Format Cells, then the Alignment tab. Type in the number of degrees you'd like the text to rotate, then click OK.^{[3] X Research source}

Samuel Daniel

Update 05 March 2020

You should read it

May be interested

Things to do when switching to Facebook's Timeline interface
facebook's new timeline interface has been in effect for many users. here are the tweaks to consider when switching to this interface.
Already able to use Windows Timeline on Google Chrome and Mozilla Firefox
windows timeline support is an extension / addon that allows chrome and firefox users to use it on many windows 10 devices like microsoft edge.
How to create multiple timelines on Twitter home screen
similar to reddit's custom feed, you can now create multiple timelines on your twitter home screen with lists. now, let's learn how to create multiple timelines on twitter for android and ios through the following article.
How to draw charts in Excel
drawing diagrams on excel are basic and often done, when displaying data based on tables or comparing figures together.
How to create a password protection for Excel sheets
in addition to creating passwords for excel files, we can proceed to set the password for each sheet in excel data to prevent the ability to edit the sheet content, but can still view the content.
Aspire Timeline Ultra laptop line from Acer
the product is capable of working super fast when integrated with many technologies that were previously reserved for high-end ultrabooks.
How to create bullet list in Excel
creating bullet lists (notation lists) in excel is not as simple as in word because there is no bullet button on the ribbon in excel. therefore, this article will show you 7 ways to create bullet list in excel.
Instructions on how to create diagonal lines in Excel box
manipulating 1 cell into 2 diagonal triangles with a line on excel is a very basic operation and is often performed during the process of creating tables on excel.
How to create Text Box in Excel
text box on excel is similar to creating on word, helping you create artistic text frames, attracting content viewers.
How to create flashing letters on Excel
to create flashing words on excel, we need to use vba programming language.