I swear I could do this faster by hand, but the task requires it be done in excel. That said, I am trying to graph some data -- the x-axis will be the same 9 or so items, and the y-axis I want to be time, I'm thinking 12(:01) AM to 11 AM, with major units being every hour in between. I will be adding different sets of data, one set for each day, so a line graph with markers works the best. Instead of doing what I want, the y-axis goes from 12 AM to 12 PM and repeats multiple times for each day, so the multiple lines do not overlap and are all above each other. I hope what I am asking makes sense, so any help would be much appreciated. If you need any more detail, just let me know and I'll get back as soon as I can. Here is what I currently have for reference.
Thanks!
Bookmarks