I am trying to merge 2 tables.
Specifically in the first excel there are specific dates that i have data regarding the time worked.
In the second excel i have a calendar with all dates (including those that no work was made).
I want to create a chart where, when i choose a month and a specific worker i want to see for the dates that no work was performed 0 hours and for the other days the times worked according to table 1.
Unfortunately till now when i choose a worker the chart shows only the specific date of the month that he worked and no 0 values for the days he didn' t work.
Thanxs in advance