graph 100% bar chart

[Patrickstudent]

I would like to compile a 100% bar chart in excel based on the data below. When I select the first two variables, excel merges 'marriage clause' and 'no marriage clause' and makes a graph per time period. I would like to put the three variables, i.e. marriage, disease, and death, into one graph, all of which per time period (so: marriage 1621-1791, 17th century, 18th century; disease 1621-1791, 17th century, and 18th century). However, excel does not know what columns I would like to merge. How can I do that?

Thanks in advance

	marriage clauses	no marriage clauses	disease clauses	no disease clauses	death clauses	no death clauses
1621–1791	28	193	27	194	86	135
17th century	18	121	16	123	44	95
18th century	10	72	11	71	42	40

[#2]

@Patrickstudent 

You'll have to rearrange the data for this. See Create Excel Cluster Stack Charts for instructions.

Data:

Chart:

Sample workbook attached below.