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!
<colgroup><col><col><col span="4"><col span="3"></colgroup><tbody>
</tbody>
Q1 | Q2 | Q3 | Q4 | CY 2017 | CY 2018 | CY 2019 | ||
Labor-based | Funded Backlog | 25% | 22% | 19% | 16% | 20% | 20% | 20% |
Labor-based | Unfunded Backlog | 1% | 1% | 0% | 0% | 0% | 0% | 0% |
Labor-based | Follow On | 68% | 67% | 60% | 60% | 64% | 63% | 63% |
Labor-based | New Business | 7% | 10% | 22% | 24% | 15% | 17% | 17% |
Data Sales | Funded Backlog | 9% | 0% | 0% | 0% | 2% | 1% | 1% |
Data Sales | Unfunded Backlog | 0% | 0% | 0% | 0% | 0% | 0% | 0% |
Data Sales | Follow On | 67% | 42% | 30% | 28% | 38% | 35% | 35% |
Data Sales | New Business | 24% | 58% | 70% | 72% | 61% | 64% | 64% |
Total | Funded Backlog | 20% | 15% | 11% | 9% | 14% | 13% | 13% |
Total | Unfunded Backlog | 0% | 0% | 0% | 0% | 0% | 0% | 0% |
Total | Follow On | 68% | 59% | 48% | 46% | 54% | 53% | 52% |
Total | New Business | 12% | 25% | 41% | 44% | 32% | 34% | 35% |
<colgroup><col><col><col span="4"><col span="3"></colgroup><tbody>
</tbody>