Stacked Column Perhaps?

jezright

On Hover (dashboard) I want to be able to see all the types of projects that each one has been assigned to through different colors. Kindly assist on how to go about this

Gia Thinh

Hi jezright,

1. Create a Metric sheet : rows are the Assignee name and columns are project types, then use formula to caculate types of projects that each one has been assigned to
2. On the Dashboard, create a STACKED BAR chart that pull in the data from the Metric sheet

Below is my example. Hope it works for you.

Gia Thinh

Hi jezright,

1. Create a Metric sheet : rows are the Assignee name and columns are project types, then use formula to caculate types of projects that each one has been assigned to
2. On the Dashboard, create a STACKED BAR chart that pull in the data from the Metric sheet

Below is my example. Hope it works for you.

jezright

Thank you. Please, do you have the formula?

Gia Thinh

Try COUNTIFS function for your counting use case. Below is an example .

=COUNTIFS({Sales phụ trách}, Sales@row, {Giai đoạn sales}, @cell = "8 - CLOSE")

jezright

Thank you