I need to create a chart, but the values for the X axis are inconsistent.
The values are date / time based. They are based on when sample readings are taken. So typically they could look like this:

27/11/2015 16:37
28/11/2015 09:00
29/11/2015 09:19
30/11/2015 10:03
01/12/2015 08:04

How can I format / display the X axis to show the readings in correctly spaced time intervals?



Thanks in advance

Please post a sample sheet. Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

If they are stored as true date/time values and not text, use an XY scatter chart.