Gantt chart with Gaps

[#1]

Does anyone have any ideas how to create a Gantt chart where there is a gap in the work stream, like in the example below (Albina, Milan).

My data is daily (binary either 1 or 0 for each day) rather than period based with start and end dates.

I've tried the bar chart on its side with offsets approach but can't get the gap that is required.

Any thoughts would be welcome.

Preferably without using extensions.

[Kushal_Chawda · Accepted solution]

see this

How to create a Gantt chart using a Pivot table