Creating a chart for number of hours scheduled per day

I have a table with the following columns
Estimated Duration
How do I create a chart with Estimated Duration on the Y and Date on the X.

In this case the Resource and Date Could be repeated on several rows.
I would like to show for a resource, the total number of estimated durations per date for each resource…

I have tried selecting Column series… but only the estimated duration is showing up and not the date is there something that am missing?

I have also created a slice to isolate data for each resource… but now how do create the column chart with sum of estimated duration per date and display date on x axis and Estimated Duration on the y axis.