Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
k_kefalas
Contributor
Contributor

Concatenate different tables and show null vales in chart

Hi,

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

0 Replies