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:

Product	Assignment 1	Assignment 2	Assignment 3	Assignment 4
Item 1	08/15/2015	10/10/2015	03/14/2015	02/10/2014
Item 2	03/01/2014	05/01/2015	07/02/2014	02/11/2014
Item 3	02/25/2015	12/09/2014	10/05/2014	02/11/2015
Item 4.	04/26/2014	11/06/2015	04/23/2015	08/21/2015

<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>
</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.