Building a histogram or a stacked bar chart with date series data

user020184

Hi!

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

xyx

12-Nov-20

01-Jul-21

Planned Units

1,272h

32h

40h

40h

40h

32h

40h

abc

12-Nov-20

23-Aug-21

Planned Units

1,568h

32h

40h

40h

40h

32h

40h

 

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.

 

Thanks

MichelleH

Your best bet is going to be to reformat your data to have a separate row for each week the resource works, like below. That way you can simply sum the "Planned Units" column and use the "Week Start" column to group by week. 

 

Resource Name	Week Start	Planned Units
xyx	January 17, 2021	32
xyx	January 24, 2021	40