Building a histogram or a stacked bar chart with date series data
I have a datasource as excel file which I want to use to build a stacked bar chart. The data has a series of columns with week range as dates and hours worked per week against a project for a a particular person. Now I want to build a stacked bar against this data but seems like the dates dont allow me that option. If someone can please help me out with it would really appreciate it.
The data looks like :
|Resource Name||Start||Finish||Units & Costs||Total||January 17, 2021 - January 23, 2021||January 24, 2021 - January 30, 2021||January 31, 2021 - February 6, 2021||February 7, 2021 - February 13, 2021||February 14, 2021 - February 20, 2021||February 21, 2021 - February 27, 2021|
I want to build a stacked bar with hours by the week mentioned in the columns. The issue is those date ranges does not act as date and gives me an issue plotting the graph.
Help will be greatly appreciated.