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?
Answers
-
Hi @VaneT - Can you take a screenshot of your Chart Widget settings? This area might help provide insight for us.
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist | Process Improvement Enthusiast
-
-
@VaneT - I'd recommend trial and error! First, uncheck "Use column names as category labels." If that doesn't work, check it and then uncheck "Use first column as series labels." If that doesn't work, uncheck both! Sometimes it takes a little bit of playing with it to make it work in my experience.
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist | Process Improvement Enthusiast
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!