LinkBack URL
About LinkBacks
I am needing help recreating the attached in excel. It is showing the absentee rates for each department for both previous and current months. Attached is an excel document put with a picture off of PowerPoint. Any help is appreciated!
I am needing help recreating the attached in excel. It is showing the absentee rates for each department for both previous and current months. Attached is an excel document put with a picture off of PowerPoint. Any help is appreciated!
There are no data in the file. Please upload a sample file complete with raw data!!!!
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Here you go. Need a chart to show and compare each department's attendance rate for the different months to each other.
Thanks!example (2).xlsx
A bit of a guess, as I wasn't really sure what you expected to see!!
Is there a better way to show this?
The human eye isn't really programmed to filter a massive set of squiggles and see a pattern. If I was doing this for myself, I'd display a SINGLE department at a time, using a drop-down box to select the department. However, that's not what you asked for.
IMHO the solution to the problem, as posed by yourself, looks like a dog's breakfast...
Re-define what you want and work from there.
How would you do the drop down?
Like this, maybe? You can hide the green cells by positioning the graph on top of the green cells.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks