3 Ways to Create a Timeline in Excel

Table of contents:

3 Ways to Create a Timeline in Excel
3 Ways to Create a Timeline in Excel

Video: 3 Ways to Create a Timeline in Excel

Video: 3 Ways to Create a Timeline in Excel
Video: Tutorial on How to Convert Word Document to Excel 2024, November
Anonim

Excel is not a graphics-focused program, but it does provide several ways to create a timeline. If you have Excel 2013 or later, you can even create it automatically from a pivot table. For older versions of Excel, you need SmartArt, a template, or you need to rearrange the cells of a spreadsheet.

Step

Method 1 of 3: Using SmartArt (Excel 2007 or Later)

Create a Timeline in Excel Step 1
Create a Timeline in Excel Step 1

Step 1. Create a new spreadsheet

SmartArt creates a new graphic layout for you to enter data. The program doesn't modify any existing data so create a blank spreadsheet for your timeline.

Create a Timeline in Excel Step 2
Create a Timeline in Excel Step 2

Step 2. Open the SmartArt menu

Depending on the version of Excel, click the SmartArt label on the ribbon menu, or click the Insert label and then the SmartArt button. This option is available in Excel 2007 or later.

Create a Timeline in Excel Step 3
Create a Timeline in Excel Step 3

Step 3. Select the timeline from the Process submenu

Click Process on the SmartArt ribbon menu, in the Smart Art Graphic group. In the drop-down menu that appears, select Basic Timeline (arrow pointing to the right).

You can customize various other Process graphics to use as timelines. To see the name of each graphic, move the cursor over the icon and wait for the cloud text to appear

Create a Timeline in Excel Step 4
Create a Timeline in Excel Step 4

Step 4. Add more events

In the beginning, you just start with a few events. To add an event, select a timeline. The Text Pane options will appear to the left of the graphic. Click the + button at the top of the text pane to add a new event to the timeline.

To enlarge the timeline without adding new events, click the timeline to display a grid outline. Slide the right or left side of the box out

Create a Timeline in Excel Step 5
Create a Timeline in Excel Step 5

Step 5. Edit your timeline

Type in the Text Pane box to add an entry. You can also copy and paste data into a timeline and let Excel guess how to organize it. Typically, each column of data will be organized as a single timeline entry.

Method 2 of 3: Using Pivot Table Analysis (Excel 2013 or Later)

Create a Timeline in Excel Step 6
Create a Timeline in Excel Step 6

Step 1. Open the spreadsheet that has the pivot table

To be able to create timelines automatically, the data needs to be organized into a pivot table. You'll also need the pivot table analysis menu, which has been available since Excel 2013.

Create a Timeline in Excel Step 7
Create a Timeline in Excel Step 7

Step 2. Click anywhere in the pivot table

This will open “PIVOT TABLE TOOLS” at the top of the ribbon.

Create a Timeline in Excel Step 8
Create a Timeline in Excel Step 8

Step 3. Click “Analyze”

This will open a ribbon with options for manipulating the data in the table.

Create a Timeline in Excel Step 9
Create a Timeline in Excel Step 9

Step 4. Click “Insert Timeline”

A dialog box will appear showing a text box related to the date format. Note that Excel will not recognize the date entered as text.

Create a Timeline in Excel Step 10
Create a Timeline in Excel Step 10

Step 5. Select the Applicable box and click OK

A new box that will allow you to move around in your timeline will appear.

Create a Timeline in Excel Step 11
Create a Timeline in Excel Step 11

Step 6. Choose how the data will be filtered

Depending on the availability of information, you can choose how the data will be filtered (by month, year, or quarter).

Create a Timeline in Excel Step 12
Create a Timeline in Excel Step 12

Step 7. Check monthly data

When you click on a month in the Timeline Control Box, the pivot table will show data relating to that month only.

Create a Timeline in Excel Step 13
Create a Timeline in Excel Step 13

Step 8. Expand the selection

You can expand the selection by clicking and moving the side slider.

Method 3 of 3: Using a Basic Spreadsheet (Any Version)

Create a Timeline in Excel Step 14
Create a Timeline in Excel Step 14

Step 1. Consider downloading a template

While not required, templates will make your work easier by setting a timeline structure. You can check whether Excel already has a timeline template by using the File → New or File → New from Template commands. Otherwise, look for user-generated templates on the internet. If you don't want to use a template, continue to the next step.

If your timeline of monitoring project progress is multi-pronged, consider looking for a "Gantt chart" template

Create a Timeline in Excel Step 15
Create a Timeline in Excel Step 15

Step 2. Start your own timeline from a regular cell

You can build a basic timeline with a blank spreadsheet. Type the timeline dates in one line, and space the black cells more or less in proportion to the time between them.

Create a Timeline in Excel Step 16
Create a Timeline in Excel Step 16

Step 3. Write down the timeline entry

In the cell immediately above or below each date, write a description of the events that occurred on that date. Don't worry if your work looks messy.

Alternate the location of the description above and below the date for easy reading

Create a Timeline in Excel Step 17
Create a Timeline in Excel Step 17

Step 4. Italicize the description

Select the row that contains the description. Click the Home label on the ribbon menu, then look under the Orientation button under the Alignment group (in some versions, the Orientation button looks like the letter abc.) Click this button and select one of the italic text options. The text that plays will become a description regarding the timeline.

If you are using Excel 2003 or an earlier version, right-click on the selected cell. Select Format Cells, then the Alignment label. Type the number of degrees of inclination you want, then click OK

Recommended: