Draw Strip Chart

[vidhate0123]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]from[/TD]
[TD]To[/TD]
[TD]side[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]10[/TD]
[TD]LHS[/TD]
[TD]DLC[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]25[/TD]
[TD]LHS[/TD]
[TD]DLC[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]16[/TD]
[TD]RHS[/TD]
[TD]DLC[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8[/TD]
[TD]LHS[/TD]
[TD]PQC[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]25[/TD]
[TD]LHS[/TD]
[TD]PQC[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]12[/TD]
[TD]RHS[/TD]
[TD]PQC[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]PQC LHS[/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][/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]Chainage[/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]DLC LHS[/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 LHS[/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]

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


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]PQC LHS[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/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]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]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chainage[/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]DLC LHS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/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][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PQC LHS[/TD]
[TD][/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]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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).