So I have to do a project makes graphs in excel. My teacher is calling for line graphs, pretty easy I know. However, I first attempted to put all the data on one using multiple lines, well lets jst say that didnt work. So then I split it up into three graphs. One of the graphs uses time such as 12:00 AM/PM on the vertical axis and dates on the horizontal. The dates were pretty easy to figure out. However, I need to figure out how to make the vertical axis look right. I need it to contain AM and PM times. The intervals jump in groups of like 29 though. I want it to go easily from 12:00 to 12:30 to 1:00. I may be too new at this but I need to figure it out soon! Also is there an easy way to make the AM and PM go in the correct order. I know theres formulas and stuff but I am way to new at excel to know all of that and google isnt helping much. Thanks!
Bookmarks