# How to Create a Timeline with Dates in Excel (4 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

A timeline shows tasks or projects with dates in chronological order. It allows the audience to view all tasks or projects in a single spot. Today, we will learn to create a timeline with dates in Excel. In this article, we will demonstrate 4 easy methods. These methods are easy and save you time. So, without further ado, letâ€™s start the discussion.

Watch Video â€“ Create a Timeline with Dates in Excel

## How to Create Timeline with Dates in Excel: 4 Ways

To explain the methods, we will use a dataset that contains information about the Projects of a company. It contains the Starting Date and the Finishing Date of each project. We will try to create a timeline using this dataset throughout the whole article.

### 1. Generate a Timeline with Dates Using SmartArt in Excel

In the first method, we will use the SmartArt option to create a timeline with dates in Excel. It is the easiest method. The steps are simple. So, letâ€™s follow the steps below to learn the process.

STEPS:

• First of all, select Insert and then, select Illustrations. A drop-down menu will occur.
• Select SmartArt from the drop-down menu. It will open the SmartArt GraphicÂ window.

• Secondly, select Process and then, select the Basic TimelineÂ icon.

• Click OK to proceed. You can choose other timeline arts too.

• After clicking OK, the timeline will appear on the worksheet.
• Now, select the less than (<)Â symbol.

• After selecting the less than (<) symbol, a new box will appear.
• Next, press Enter to add more solid circles to the timeline. We need a total of 6 solid circles to complete the timeline.

• After adding the solid circles, the timeline will look like the picture below.

• In the following step, write your text in the â€˜Type your text hereâ€™ in order.

• Finally, click anywhere in the sheet to see a timeline with dates like the picture below.

### 2. Insert Scatter Chart to Create a Timeline with Dates in Excel

Another way to create a timeline with dates in Excel is to use the Scatter Chart. Here, we will use the previous dataset. You can also use other types of charts to create your timeline. Letâ€™s pay attention to the steps below to learn the method.

STEPS:

• In the first place, select any cell of the dataset and press Ctrl + A to select all the used cells.

• Secondly, go to the Insert tab and select the Scatter Chart icon. A drop-down menu will occur.
• Select the first icon from the drop-down menu.

• After that, you will see a plot on your worksheet like the picture below.

• In the following step, click on the plus (+)Â sign.
• Select Axis and then, deselect Primary Vertical.

• Again, click on the plus (+)Â sign.
• Select Axis Titles and deselect Gridlines.
• Then, select Legend >> Right.

• Next, change the titles and make the graph more understandable.

• One more time, click on the plus (+) icon and select Data Labels > Left.

• Now, click on a starting date point and right-click on it. A menu will occur.
• Select Format Data Labels from there.

• Instantly, the Format Data Labels option will appear on the right side of the screen.
• Select Right in the Label PositionÂ category.

• In the end, you will see a timeline with dates like the screenshot below.

• You can also use the Pie Charts to create a timeline like below.

### 3. Apply Excel Pivot Table Analysis to Make Timeline with Dates

Excel Pivot Table offers a lot of useful features. You can use the pivot table analysis to make a timeline with dates. This process is tricky. So, letâ€™s observe the steps below to learn it.

STEPS:

• In the beginning, select a cell in your dataset and then, select Insert >> Table.
• Alternatively, you can press Ctrl + T.

• In the second step, click OK in the Create Table dialog box. Make sure you select the â€˜My table has headersâ€™ box.

• Your table will be like the picture below.

• Thirdly, select Insert >> PivotTable.

• A dialog box will pop up. Just click OK to proceed.

• After that, the PivotTable Fields will occur on the right side of a new sheet.

• Select Projects, Starting Date, Finishing Date, Months, & Months2.
• Drag the Months, Months2, Starting Date, and Finishing Date fields in the Legend (Series)Â box.
• Also, drag the Starting Date and Finishing Date fields in the Values box.
• One more thing, make sure the Projects field is in the Axis (Categories) box.

• In the following step, right-click on the Count of Starting Date and select Value Field Settings.

• In the Value Field Settings window, select Sum and then, select Number Format. It will open the Format CellsÂ window.

• In the Format Cells window, select Date and then, select the 14-Mar-12Â format.

• Now, click OK to see results like the picture below.

• As a result, click on the plus (+) icon and select Data Labels.

• In the end, change the position of the Data Labels to make them more readable.

• To save the timeline as a picture, right-click on the graph and select Save as Picture.

### 4. Create Timeline with Dates Manually in Excel

You can also create a timeline with dates manually in Excel. It is a super easy process. Here, we will use the same dataset again. So, without any delay, letâ€™s follow the steps below.

STEPS:

• Firstly, select a cell in the dataset and press Ctrl + A to select all the used cells.

• Secondly, go to the Home tab and select the Orientation icon. A drop-down menu will occur.
• Select Angle Counterclockwise from there.

• After that, the dataset will look like the picture below.

• Now, autofit the rows.

• Finally, add some colors to make the timeline more presentable.

Read More: How to Create a Timeline Chart in Excel

## Things to Remember

There are some things you need to remember when you are trying to create a timeline with dates in Excel.

• In Method-1, choose the SmartArt Graphic according to your needs.
• You can use different types of charts instead of â€˜Scatter Chartsâ€™ in Method-2.
• In Method-3, you may not get the timeline in chronological order sometimes.

## Conclusion

<< Go Back to Timeline in Excel | Learn Excel

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF