Making colour Bar Chart of road progress Work

[vidhate0123]

[TABLE="width: 256"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD="colspan: 3"]Road Work Completed[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"][TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]From[/TD]
[TD]To[/TD]
[TD]Side[/TD]
[TD]Item[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]10[/TD]
[TD]LHS[/TD]
[TD]DLC[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]20[/TD]
[TD]LHS[/TD]
[TD]DLC[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]14[/TD]
[TD]RHS[/TD]
[TD]DLC[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]26[/TD]
[TD]RHS[/TD]
[TD]DLC[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]8[/TD]
[TD]LHS[/TD]
[TD]PQC[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]12[/TD]
[TD]RHS[/TD]
[TD]PQC[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]26[/TD]
[TD]RHS[/TD]
[TD]PQC[/TD]
[/TR]
</tbody>[/TABLE]


[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Base of this data I want to draw colour Bar chart / Progress chart as shown in below

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]PQC LHS[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DLC LHS[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Kilometer[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]12[/TD]
[TD]14[/TD]
[TD]16[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]22[/TD]
[TD]24[/TD]
[TD]26[/TD]
[TD]28[/TD]
[TD]30[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DLC RHS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PQC RHS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


As here is not option of format fill cell by colour so I show it by written "C"

 

[Fluff]

You can do that using Conditional formatting

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	From	To	Side	Item				PQC LHS
2	0	10	LHS	DLC
3	18	20	LHS	DLC				DLC LHS
4	8	14	RHS	DLC
5	18	26	RHS	DLC				Kilometer	0	2	4	6	8	10	12	14	16	18	20	22	24	26	28	30	32
6	0	8	LHS	PQC
7	8	12	RHS	PQC				DLC RHS
8	20	26	RHS	PQC
9								PQC RHS
Color

Select I1:Y9 new rule, use a formula
=SUMPRODUCT(($D$2:$D$8&" "&$C$2:$C$8=$H1)*($A$2:$A$8<=I$5)*($B$2:$B$8>=I$5))
& select the format

 

[vidhate0123]

Thanks for Reply. Its working .
Can you send me in VBA code .

 

[Fluff]

If you need VBA, then simply record a macro of you doing it manually.