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
Anonim

Timelines are a new feature introduced by the 2010 version of Excel. It allows you to easily select a date range on a pivot table on an Excel worksheet. If you have an Excel sheet with a pivot table and dates, you can create a timeline to visually show your data.

Steps

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 to which you can add data. It doesn't transform the data you have, so you can create a new blank spreadsheet for the timeline.

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

Step 2. Open the SmartArt menu

Depending on your version of Excel, you can click the SmartArt bar in the menu, or the Insert bar and then the SmartArt button. The latter option is available in Excel 2007 and 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 in the SmartArt bar, inside the Insert a Smart Art Graphic group. In the drop-down menu that appears, select Baseline Timeline (indicated by an arrow on the right).

You can adapt many other Process graphics to your timeline. To see their name, move the mouse cursor over the icons and wait for it to appear

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

Step 4. Add other events

By default, you start with a few events; to add, select the timeline: a text field should appear on the left. Click the + button at the top of the panel to add a new event.

To enlarge the timeline without adding new events, click the timeline to bring up an outer box, then drag the right or left side

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

Step 5. Edit the timeline

Type in the Text field to add data. You can also copy and paste data into the timeline and let Excel fix it. Generally, each column of data will look like a single timeline.

Method 2 of 3: Using PivotTable 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 contains the pivot table

In order to use timelines, your data must be sorted in a pivot table.

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

Step 2. Click anywhere within the pivot table

This will allow you to open the "Pivot Table Tools" menu on the top ribbon.

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

Step 3. Click on "Analyze"

This will open a ribbon with the option to manipulate the table data.

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

Step 4. Click on "Insert Timeline"

A dialog box will appear showing the fields that match the date format. Warning: dates entered as text will not be recognized.

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

Step 5. Select the Applicable field and click OK

A new window will appear allowing you to navigate your timeline.

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

Step 6. Select the data filtering method

According to the information available, you will be able to choose how to filter the data. (By month, year or quarter).

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

Step 7. Review the monthly data

When you click on a month in the Timeline Control Window, you will only see data for that particular month in the pivot table.

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

Step 8. Expand your selection

You can decide to expand the selection by clicking and dragging the sides of the selector.

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

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

Step 1. Consider downloading a pattern

While not necessary, a schema (or template) will save you some work by creating the timeline structure for you. You can check if you already have a template by going to File → New or File → New from Template. Alternatively, search online for templates created by other users. But if you don't want to use a template, continue reading the next step.

If your timeline follows the progress of a very structured project, you might consider using a Gantt chart

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

Step 2. Start your timeline from normal cells

You can create a basic timeline from a classic blank worksheet. Type the timeline dates in a row, spacing them with blank cells roughly in proportion to the time pauses between them.

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

Step 3. Write down the characteristics of your timeline

In the cells directly above or below each date, write a description of the event. Don't worry if it looks a little sloppy.

Alternating descriptions above and below dates generally creates the most readable timelines

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

Step 4. Angola descriptions

Select the line containing your descriptions. Click the Home bar in the menu, then, in the Alignment group, find the Orientation button (in some versions the Orientation button has the letters abc). Click the button and select one of the proposed text slants: in this way the descriptions should enter the timeline.

Recommended: