hi there to all,

the last few day i am trying to solve a problem with a chart.

here is the story:

i have a sheet with the following layout:

customer name activity type start date duration
cust1 act1 01/01/17 5
cust2 act2 04/01/17 7
cust3 act3 03/01/17 5
cust1 act4 03/01/17 4
cust4 act5 14/01/17 5
cust1 act6 14/01/17 15

what i have to do is to represent the above data in a chart showing for each customer how many activities has and what is the duration of each one.

any idea will be appreciated.

thanks in advance.