Hi,
I have a number of consultants working for a number of customers and we invoice per hour. I have a database with consultant, customer, start/end date/time and duration for each occasion worked for the customer.
I would like to illustrate who has worked for which customer when and for how long on a monthly basis with a stacked bar chart with the consultants on the Y axis, dates on the X axis and customers in the legend. Sort of like a gantt chart but with multiple entries for each bar. Non-worked time between customers assignment should show as white in the chart.
Have been looking around for a solution but haven't found any. Anyone who can help me with this or point me in the right direction?
Br,
C
I have a number of consultants working for a number of customers and we invoice per hour. I have a database with consultant, customer, start/end date/time and duration for each occasion worked for the customer.
I would like to illustrate who has worked for which customer when and for how long on a monthly basis with a stacked bar chart with the consultants on the Y axis, dates on the X axis and customers in the legend. Sort of like a gantt chart but with multiple entries for each bar. Non-worked time between customers assignment should show as white in the chart.
Have been looking around for a solution but haven't found any. Anyone who can help me with this or point me in the right direction?
Br,
C