If you want the time and date printed every two hours, you will need to Rows go left to right, columns go top to bottom) (By the way: The row with the time is not a row, but a column. It looks like the format for the axis labels is using only the time without the date. You can clearly see on the X axis that the markers are for 0:00 AM and these are consecutive days.įormat the X axis and you can see the settings for the Axis Options > Units will be 1 (for 1 day). As a last resort, you could reshape the timestamps in your logfile to some format that Excel can handle.Įxcel does not plot the time randomly. I'm guessing that your logfile is written by a device with a 'locale' that differs from the Internationalization settings on your machine, which makes it harder for Excel to properly recognize the timestamps. That option allows you to further specify the DMY order. "General" is the default, which does a fine job of recognizing dates, but you may need to nudge the process in the right direction by explicitly choosing "Date" type. Note how the Text Import Wizard offers the feature to customize each of the imported columns for data type. So your actual problem is getting the proper timestamps imported from some logfile.
#Xy scatter plot excel series
Based on no input, Excel has made up a series of consecutive dates starting with the awesome Zeroeth of January, 1900 !
I got exactly the same 7 labels "12:00:00 AM" like you had, but the ultimate indication of what is going on, is to put the axis labels in date format. I had to seriously tweak a CSV import to get this wrong on purpose - Excel seems to be getting frighteningly smart at recognizing import data. As noted by the error stands out because the text data are left-justified. I reproduced your problem by intentionally entering text instead of time data in the first column.
When entering proper timestamps in Excel, the scatterplot comes out right immediately (even though the axis labels need some tailoring to taste).
0 kommentar(er)
