I am trying to put together a chart that reflects application deadlines for roughly two dozen clients for the company I work for. Some of these clients have two or three different deadlines to reflect the multiple testing windows these clients have throughout the year. Essentially, I am trying to graphically depict application deadlines for the clients throughout the year to identify overlaps to better project staffing needs for the company. I have tried to setup a chart with the months of the year on one axis, the clients on another axis, and then create a simple bar-chart with the application deadlines.
The problem I keep running into is that the data I have is alphabetic, not numeric. Is there a way to create what I am going for here? If so, could someone point me to a resource that would walk me through this process?
Software/Hardware used: Microsoft Office 2007 or higher