I am working on making a scatter plot in Excel of some temperature data. I have
column A containing the date data as mm/dd/yy. column B containing the time data as hh:mm:ss AM/PM and the rest of the columns containing temperature data.
I am able to make a graph and get it to the axis size I want, however when I change the X-axis to a time variable, it somehow thinks the date is changing and not the time. I have about 4 hours of data, so I know this is incorrect. I am getting something like 1/0/00 12:00 AM when I really should be getting 4/3/13 1:50:59 PM. Does anyone know how to change the Excel settings to get the time I want?