Google Chart Workload diagram

[Fr333zz]

Hi all,

I've a little problem how i should get started with making the following graph.

So what does this graph contains:

• Automatic updated X-axis with starting date today and with a total span of 2 years. x-axis step is 1 week.
• Y-axis contains the weekly needed hours splitted up in 5 probability groups. 

Current data that is inserted in SalesForce:

• Project kick-off date
• Project implementation data
• Hours needed for the full project

What does the graph needs to calculate or show:

• Calculate the weekly needed hours (this can also be done in SalesForce, TBD)
• Compare the date of the week in the X-axis. If the date falls in the range of the kick-off date and implementation data, the hours will need to be displayed.
• Multiple projects will be inserted in this chart and need to be added to each other to see the full workload, that why we need the area chart.

This graph is currently made in Excel and we want to make this happen in SalesForce, which then will need to be in HTML.

Could someone give me some advice on how I should get started here?

Thanks for your support!

Grtzz. Fr333zz