Best Way to Create a Stacked Bar Chart from multiple columns

Question

I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart  and put into a dashboard if I can.

The columns I am trying to make into a stacked chart are:

Lead, project and phase.

The issue is that there are several leads and I need the stacked bar chart to show in different colors for each lead where the project is at.

Examples:

Lead 1 has 15 projects - 3 in Phase 1, 4 in Phase 2, 1 in Phase 3, 1 in phase 4, 6 On Hold

Lead 2 has 5 projects - 1 in Phase 1 and 2 in Phase 2 and 2 On Hold

Etc.

Basically - there would be a stacked bar for each lead with the total # of projects they have, but it would be broken out in stacks/count by phase.

Jenny A. · Answer

Screenshot 2026-06-08 081840.png

Attached is my terrible mockup. This is the current graph, I just modified how I would like it to look. Each colored section would be what phase the project is in. Under each person it shows how many projects they have (in the colored sections) and what phase they are in. Not sure if that made sense. This info would pull into a report from a sheet and that report is what would be charted.

So there would be each lead - and for each lead it would chart how many projects they have (like 15 total), but the bar would also be broken out into stacks (so of the 15 - 5 are On Hold, 10 are in Phase 1, etc).

Thanks

darkmatter · Answer

Hey @Jenny A. Could you share a mock-up of how you want the chart to look (what you want to appear on legend, x axis, y axis, stacked bar groups). I'll then be able to advise exactly.

Thanks

Matt