Visualizing relationship of similar tasks across many different Projects

[RogerC]

I have a schedule of Project level activities that encompasses tasks spanning multiple separate projects. Each Project is individually implemented at a different business location around the globe. However, any individual location may be impacted by the schedule of more than one project in the list at any given time.

At the Program Management level, I need to graphically visualize the relationships of all tasks across all projects. For example, I need to understand the extent to which any single location is being impacted by the tasks of multiple projects over the time period from start to finish of all projects.

My goal is to graphically visualize the magnitude of effort required at the sites when multiple projects are in work. Basically, I need a graphic timeline of all Tasks over the three year period shown by Site, Project and Task Durations (days).

A highly simplified version of my combined Task Schedule data for 4 Projects being deployed across 3 Sites might look like this:

Excel 2013/2016

	A	B	C	D	E
1	Site	Project	Task	Start	Finish
2	New York	A	Survey	07/1/17	08/11/17
3	New York	A	Approval	09/5/17	10/5/17
4	New York	A	Budget	02/1/18	04/30/18
5	New York	A	Install	06/1/18	09/17/18
6	New York	A	Go Live	09/20/18	09/22/18
7	New York	B	Survey	09/10/18	10/1/18
8	New York	B	Approval	10/27/18	10/29/18
9	New York	B	Budget	12/1/18	12/14/18
10	New York	B	Install	12/20/18	12/30/18
11	New York	B	Go Live	01/10/19	01/15/19
12	Phoenix	C	Survey	09/10/18	10/1/18
13	Phoenix	C	Approval	10/17/18	10/19/18
14	Phoenix	C	Budget	11/11/18	12/11/18
15	Phoenix	C	Install	01/3/19	02/27/19
16	Phoenix	C	Go Live	03/3/19	03/4/19
17	Phoenix	A	Survey	07/1/17	08/1/17
18	Phoenix	A	Approval	08/5/17	09/5/17
19	Phoenix	A	Budget	02/1/18	02/28/18
20	Phoenix	A	Install	06/1/18	09/17/18
21	Phoenix	A	Go Live	09/20/18	09/22/18
22	Paris	D	Survey	07/1/18	08/11/18
23	Paris	D	Approval	11/5/18	11/15/18
24	Paris	D	Budget	02/1/19	09/30/19
25	Paris	D	Install	07/1/19	08/17/19
26	Paris	D	Go Live	08/1/19	08/31/19

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Can this be done effectively using standard Excel charting? If so, can someone recommend a chart type?

Or would this better be done using some more advanced Excel functionality?

Looking for advice. Thank you.

 

[RogerC]

Any charting gurus able to point me in the direction of how to best display the overlapping of tasks across Locations and Projects?