I am looking for advice/direction on how best to solve this problem.

I have a sheet with 5 rows as follows describing 5 sequential tasks with
start date (which a week number) and duration (in weeks).

Design Architecture 10 2
Install Hardware 12 1
Install Software 13 3
Configure 16 4
Support 20 10

I want to reduce this to a single bar (row) with different colors
representing each task proportionate with duration.

Any help appreciated. Would prefer a VBA free solution since I am not a
programmer.

Thanks