Form Single Time Line with Multiple Date Fields

[MrWhite23]

I'm working in Excel 2013 for windows. I 'm wondering if there is any way that I can take a table that tracks 4 different types of events for each record(row). What is the best method to get all of the events for all records placed into one chart where the horizontal axis is a timeline.

Example Dataset:

Item 1

Item 2

Item 3

Item 4.

<colgroup><col style="mso-width-source:userset;mso-width-alt:8576;width:201pt" width="268"> <col style="mso-width-source:userset;mso-width-alt:4032; width:95pt" span="4" width="126"> </colgroup><tbody>
[TD="width: 268"]Product[/TD]
[TD="width: 126"]Assignment 1[/TD]
[TD="width: 126"]Assignment 2[/TD]
[TD="width: 126"]Assignment 3[/TD]
[TD="width: 126"]Assignment 4[/TD]

[TD="class: xl66, align: right"]08/15/2015[/TD]
[TD="class: xl66, align: right"]10/10/2015[/TD]
[TD="class: xl66, align: right"]03/14/2015[/TD]
[TD="class: xl66, align: right"]02/10/2014[/TD]

[TD="class: xl66, align: right"]03/01/2014[/TD]
[TD="class: xl66, align: right"]05/01/2015[/TD]
[TD="class: xl66, align: right"]07/02/2014[/TD]
[TD="class: xl66, align: right"]02/11/2014[/TD]

[TD="class: xl66, align: right"]02/25/2015[/TD]
[TD="class: xl66, align: right"]12/09/2014[/TD]
[TD="class: xl66, align: right"]10/05/2014[/TD]
[TD="class: xl66, align: right"]02/11/2015[/TD]

[TD="class: xl66, align: right"]04/26/2014[/TD]
[TD="class: xl66, align: right"]11/06/2015[/TD]
[TD="class: xl66, align: right"]04/23/2015[/TD]
[TD="class: xl66, align: right"]08/21/2015[/TD]

</tbody>

Thanks in advance.

 

[blbat]

Create a contiguous time line across the top of your sheet, starting with your earliest date, ending with oldest date.
Items 1 through 4 remain as you have them in your example.

enter the assignment numbers in their corresponding cells.

i.e, Assignment 1 will be entered under date 08/15/2015 for Item 1.