Help with dashboard graph


Hello -

I am trying to create a graph that will allow me to depict the following:

  • Show the number of headcount by month per department

I created a report with the above data points and grouped it by department and planned start month (see below)

But I am not getting the result I want in a graph (see below)

I want my legend to depict the name of the department: ex. blue=Supply Chain, red=Tech Ops

Any advice?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!