Stacked and Clustered Column Chart help

ShanaVT

Board Regular
Joined
May 12, 2010
Messages
86
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]
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top