Making colour Bar Chart of road progress Work

[vidhate0123]

Road Work Completed
From To Side Item 0 10 LHS DLC 18 20 LHS DLC 8 14 RHS DLC 18 26 RHS DLC 0 8 LHS PQC 8 12 RHS PQC 20 26 RHS PQC <tbody> </tbody>
Base of this data I want to draw colour Bar chart / Progress chart as shown in below

<colgroup><col span="4"></colgroup><tbody>
</tbody>

PQC LHS

C

C

C

C

DLC LHS

C

C

C

C

C

C

C

Kilometer

0

2

4

6

8

10

12

14

16

18

20

22

24

26

28

30

32

DLC RHS

C

C

C

C

C

C

C

PQC RHS

C

C

C

C

C

<tbody>
</tbody>

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.