Forum Discussion
Patrickstudent
Oct 02, 2022Copper Contributor
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 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 |
1 Reply
You'll have to rearrange the data for this. See Create Excel Cluster Stack Charts for instructions.
Data:
Chart:
Sample workbook attached below.