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.
With gratitude,
ShyPrincess
Good evening, see attached
There are too many variables to graph nicely even if you use two axes.
I foresee problems with the charts submitted, as your time sample and the number of excuses increases the charts will become very cramped
Hoped it gave you a direction at least
