stacked column chart - how to overlay multiple columns and maintain "gaps"?

[JugglerJAF]

I've been asked by our new training manager to chart employee progress against training plan. There are multiple training elements, each of which can have up to 5 modules (some only have 2).

I'm thinking of setting up something like the image below, but can't figure out how to get each "box" to colour as each module is marked as complete (based on another column containing TRUE/FALSE for each course/module.

I created the chart below by setting a value of 1 (or N/A#) for each module and creating a stacked bar chart, then manually colouring it to give an example of the desired output, but I can't figure out how to do the data layout or create a chart to update automatically. I'm sure I'll need multiple columns overlaid on top of each other, but I can;t figure out how to keep a "gap" for any modules not completed.

Any suggestions greatly appreciated!

 

[GraH]

One possibility is setting up the chart as followed.
Then format each series "Training" as grey fill with black border, and each series "Training Done" with green fill and black border.

Book1
	C	D	E	F	G	H	I	J	K
2	Training	Alpha	Bravo	Charlie		Training Done	Alpha	Bravo	Charlie
3	Module1	#N/A	#N/A	1		Module1 Done	1	1
4	Module2	#N/A	1	#N/A		Module2 Done	1		1
5	Module3	#N/A		#N/A		Module3 Done	1		1
6	Module4	#N/A				Module4 Done	1
7	Module5	1				Module5 Done
Sheet2

Cell Formulas
Range	Formula
E3:E4,D3:D7,F3:F5	E3	=IF(J3,NA(),1)