Date not showing correctly on X Axis.

hi all, I'm new here but after spending a day trying to work this out I thought I would ask you all,

basically I have date and time in one column, and temperature, wind speed, gusts, humidity, pressure in separate columns.

I can plot the data up fine however the axis with the date/time on it just shows numbers as follows
Capture.PNG

I'm unsure if I've formatted the columns correctly for date time, I'm by no means an expert on excel, but I needed to get this all plotted up this evening as I've got some work to do with the data for a piece of coursework.


thanks I'm sure its quite an easy problem to fix, I just don't know how to do it!

I have attached the excel workbook incase anyone fancies having a look at it

thanks all
HarryCapture.PNG

Hi
In your column A replace the point with colon.

Hi
In your column A replace the point with colon.

i will give that a try thank you José. i will report back..

hiya ive tried that and it does this to the date, changes it to just a date instead of a time, and when i plot it, it only shows the date on the x axis

Capture.PNG

really unsure why its doing that?

thanks harry