Forum Discussion

Patrickstudent's avatar
Patrickstudent
Copper Contributor
Oct 02, 2022

graph 100% bar chart

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 clausesno marriage clausesdisease clausesno disease clausesdeath clausesno death clauses
1621–1791281932719486135
17th century18121161234495
18th century107211714240

 

 

Resources