Stacked Column Perhaps?

Options

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


Tags:

Best Answer

  • Gia Thinh
    Gia Thinh ✭✭✭✭✭✭
    Answer ✓
    Options

    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 Technology Co., LTD - Smartsheet Solution Partner.

Answers