Insert Timeline?

Pawel X Dmochowski

Summary

Insert Timeline?

Content

Hi,

Is it possible to add a dummy Timeline to Your project?

I have an excel file with names and reported hours in various weeks. I would like to always show ALL names in a given period (regardless if there is any data for that name/week or not) e.g.:

Name | Week # | Hrs

Paul | 1 | 40

Mark | 2 | 40

Jim | 2 | 40

In the above case - I would like to view all data between Week 1-3 but always see all three names. This means If I choose to view Week 3 only - I want to see all three names with 0 reported hours.

I'm trying to tackle the same issue in different ways but currently as soon as I add a filter to Week# (e.g. view only Week 3) I loose all rows for which there is no such data. How can I keep the names column fixed?

Regards,

Pawel.