title: 24 hour date time graph plotted on x axis in excel
body: <p>So im trying to plot a graph with the date on the x axis and the tide in metres on the y axis over a 2 week period, like this:</p>
  
  <p><a href="https://i.stack.imgur.com/sJXaf.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sJXaf.jpg" alt="enter image description here"></a></p>
  
  <p>with this information:</p>
  
  <p><a href="https://i.stack.imgur.com/N2dux.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N2dux.jpg" alt="enter image description here"></a></p>
  
  <p>If tried using scatter graphs but I don't know how to add the date aspect of the chart.</p>
  
  <p>If you could help that would be much appreciated.</p>