July 4, 2019
Hi, thank you for checking out my query and thank you in advance for your time and effort for any help or suggestions.
The easiest way to visualise what I am trying to do is show an image.
I'd like to display how many excuses did each company have during each period, this would be added to each month.
For example: In Jan-19 ABC company had the following occurrences 1 x Cat Caught My Tongue, 0 x Fish Out of Water, 5 x Delayed by Weather, 8 x Missed Dinner.
I have 4 other companies who also have statistics against the excuses for that same period.
I also don't know which is the best chart to use and how to display the data so it makes sense.
I have attached the sample file that might be useful to work with.
It would be immensely useful if this could be done.
Excel Analysis Toolpak
March 16, 2019