Below is my data and I am trying to create a stacked and clustered column chart where the X axis is the Q1, Q2, Q3, etc. And the Y axis is percentages. For each Qtr or CY I want to see 3 stacked columns right next to each other (no gaps and not overlapping). So for Q1 I want to see the first column for Labor-based, second for Data Sales and third for Total and then those columns would each be stacked with 4 colors representing Funded Backlog, Unfunded Backlog, Follow On and New Business. And then see those same 3 columns for each Qtr/CY. Any help much appreciated!
[TABLE="width: 694"]
<colgroup><col><col><col span="4"><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Q1[/TD]
[TD]Q2[/TD]
[TD]Q3[/TD]
[TD]Q4[/TD]
[TD]CY 2017[/TD]
[TD]CY 2018[/TD]
[TD]CY 2019[/TD]
[/TR]
[TR]
[TD]Labor-based[/TD]
[TD]Funded Backlog[/TD]
[TD="align: right"]25%[/TD]
[TD="align: right"]22%[/TD]
[TD="align: right"]19%[/TD]
[TD="align: right"]16%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]20%[/TD]
[/TR]
[TR]
[TD]Labor-based[/TD]
[TD]Unfunded Backlog[/TD]
[TD="align: right"]1%[/TD]
[TD="align: right"]1%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[/TR]
[TR]
[TD]Labor-based[/TD]
[TD]Follow On[/TD]
[TD="align: right"]68%[/TD]
[TD="align: right"]67%[/TD]
[TD="align: right"]60%[/TD]
[TD="align: right"]60%[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]63%[/TD]
[TD="align: right"]63%[/TD]
[/TR]
[TR]
[TD]Labor-based[/TD]
[TD]New Business[/TD]
[TD="align: right"]7%[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]22%[/TD]
[TD="align: right"]24%[/TD]
[TD="align: right"]15%[/TD]
[TD="align: right"]17%[/TD]
[TD="align: right"]17%[/TD]
[/TR]
[TR]
[TD]Data Sales[/TD]
[TD]Funded Backlog[/TD]
[TD="align: right"]9%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]2%[/TD]
[TD="align: right"]1%[/TD]
[TD="align: right"]1%[/TD]
[/TR]
[TR]
[TD]Data Sales[/TD]
[TD]Unfunded Backlog[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[/TR]
[TR]
[TD]Data Sales[/TD]
[TD]Follow On[/TD]
[TD="align: right"]67%[/TD]
[TD="align: right"]42%[/TD]
[TD="align: right"]30%[/TD]
[TD="align: right"]28%[/TD]
[TD="align: right"]38%[/TD]
[TD="align: right"]35%[/TD]
[TD="align: right"]35%[/TD]
[/TR]
[TR]
[TD]Data Sales[/TD]
[TD]New Business[/TD]
[TD="align: right"]24%[/TD]
[TD="align: right"]58%[/TD]
[TD="align: right"]70%[/TD]
[TD="align: right"]72%[/TD]
[TD="align: right"]61%[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]64%[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]Funded Backlog[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]15%[/TD]
[TD="align: right"]11%[/TD]
[TD="align: right"]9%[/TD]
[TD="align: right"]14%[/TD]
[TD="align: right"]13%[/TD]
[TD="align: right"]13%[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]Unfunded Backlog[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]Follow On[/TD]
[TD="align: right"]68%[/TD]
[TD="align: right"]59%[/TD]
[TD="align: right"]48%[/TD]
[TD="align: right"]46%[/TD]
[TD="align: right"]54%[/TD]
[TD="align: right"]53%[/TD]
[TD="align: right"]52%[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]New Business[/TD]
[TD="align: right"]12%[/TD]
[TD="align: right"]25%[/TD]
[TD="align: right"]41%[/TD]
[TD="align: right"]44%[/TD]
[TD="align: right"]32%[/TD]
[TD="align: right"]34%[/TD]
[TD="align: right"]35%[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 694"]
<colgroup><col><col><col span="4"><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Q1[/TD]
[TD]Q2[/TD]
[TD]Q3[/TD]
[TD]Q4[/TD]
[TD]CY 2017[/TD]
[TD]CY 2018[/TD]
[TD]CY 2019[/TD]
[/TR]
[TR]
[TD]Labor-based[/TD]
[TD]Funded Backlog[/TD]
[TD="align: right"]25%[/TD]
[TD="align: right"]22%[/TD]
[TD="align: right"]19%[/TD]
[TD="align: right"]16%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]20%[/TD]
[/TR]
[TR]
[TD]Labor-based[/TD]
[TD]Unfunded Backlog[/TD]
[TD="align: right"]1%[/TD]
[TD="align: right"]1%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[/TR]
[TR]
[TD]Labor-based[/TD]
[TD]Follow On[/TD]
[TD="align: right"]68%[/TD]
[TD="align: right"]67%[/TD]
[TD="align: right"]60%[/TD]
[TD="align: right"]60%[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]63%[/TD]
[TD="align: right"]63%[/TD]
[/TR]
[TR]
[TD]Labor-based[/TD]
[TD]New Business[/TD]
[TD="align: right"]7%[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]22%[/TD]
[TD="align: right"]24%[/TD]
[TD="align: right"]15%[/TD]
[TD="align: right"]17%[/TD]
[TD="align: right"]17%[/TD]
[/TR]
[TR]
[TD]Data Sales[/TD]
[TD]Funded Backlog[/TD]
[TD="align: right"]9%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]2%[/TD]
[TD="align: right"]1%[/TD]
[TD="align: right"]1%[/TD]
[/TR]
[TR]
[TD]Data Sales[/TD]
[TD]Unfunded Backlog[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[/TR]
[TR]
[TD]Data Sales[/TD]
[TD]Follow On[/TD]
[TD="align: right"]67%[/TD]
[TD="align: right"]42%[/TD]
[TD="align: right"]30%[/TD]
[TD="align: right"]28%[/TD]
[TD="align: right"]38%[/TD]
[TD="align: right"]35%[/TD]
[TD="align: right"]35%[/TD]
[/TR]
[TR]
[TD]Data Sales[/TD]
[TD]New Business[/TD]
[TD="align: right"]24%[/TD]
[TD="align: right"]58%[/TD]
[TD="align: right"]70%[/TD]
[TD="align: right"]72%[/TD]
[TD="align: right"]61%[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]64%[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]Funded Backlog[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]15%[/TD]
[TD="align: right"]11%[/TD]
[TD="align: right"]9%[/TD]
[TD="align: right"]14%[/TD]
[TD="align: right"]13%[/TD]
[TD="align: right"]13%[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]Unfunded Backlog[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]Follow On[/TD]
[TD="align: right"]68%[/TD]
[TD="align: right"]59%[/TD]
[TD="align: right"]48%[/TD]
[TD="align: right"]46%[/TD]
[TD="align: right"]54%[/TD]
[TD="align: right"]53%[/TD]
[TD="align: right"]52%[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]New Business[/TD]
[TD="align: right"]12%[/TD]
[TD="align: right"]25%[/TD]
[TD="align: right"]41%[/TD]
[TD="align: right"]44%[/TD]
[TD="align: right"]32%[/TD]
[TD="align: right"]34%[/TD]
[TD="align: right"]35%[/TD]
[/TR]
</tbody>[/TABLE]