Chart with 2 stories

[jebindavidson]

Hello,

I need my chart to tell two stories. For instance, Let's say 2 people are working on a task. One completes it but the other one is still working on it.

I have attached a sample file. I tried to create a chart, but it only allows to tell one story at a time. It can either say who is working on it or what stage it currently is in.

Let me know if there are better ways to represent.

Thanks for your help in advance.

[JeteMc]

Perhaps the following will help.
Convert Table2 into tbl_TeamsValues (green/white) using the following Power Query (Get & Transform) code:

Please Login or Register  to view this content.

2. From that table produce the chart on the Requirement sheet
Let us know if you have any questions.

[josephteh]

Perhaps a butterfly chart like this:
https://best-excel-tutorial.com/56-c...utterfly-chart