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
- Customer Resources
- 67.1K Get Help
- 448 Global Discussions
- 154 Industry Talk
- 504 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 513 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!