0 Replies Latest reply: Jul 13, 2017 4:16 AM by kostas kefalas RSS

    Concatenate different tables and show null vales in chart

    kostas kefalas

      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