Draw Strip Chart

[vidhate0123]

from	To	side	Type
0	10	LHS	DLC
15	25	LHS	DLC
8	16	RHS	DLC
2	8	LHS	PQC
20	25	LHS	PQC
10	12	RHS	PQC

<tbody>
</tbody>

PQC LHS
DLC LHS
Chainage	0	2	4	6	8	10	12	14	16	18	20	22	24	26	28	30	32
DLC LHS
PQC LHS

<tbody>
</tbody>

Above Data is available . Base of above data we have to make following Chart.

PQC LHS

C

C

C

C

C

C

DLC LHS

C

C

C

C

C

C

C

C

C

C

Chainage

0

2

4

6

8

10

12

14

16

18

20

22

24

26

28

30

32

DLC LHS

C

C

C

C

C

PQC LHS

C

C

<tbody>
</tbody>

This is progress chart of road construction & this stretches road work completes.Road length is 32 kilometer.Work completed values while showing in it may rounded up. First two table data is available. I have to only fill stretches by colour red C or fill totally by any colour.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ad-progress-work-post5186876.html#post5186876

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).