Date and time in X axis when in different columns

[Thoron6]

Morning,

I have a set of data like the below:

--------------00:30 01:00 01:30 02:00
01/01/2018 12 ---11--- 15 --- 20
02/01/2018 15 ---17 ---19 --- 25
03/01/2018 21 ---26 ---32 --- 40
etc.

I am trying to get the date and time on the X axis of a chart with the data going across in a line chart.

Any help would be appreciated.

Thank you

 

[pbornemeier]

You would have to reformat the data to plot to look like this before plotting

01/01/2018 00:30 12
01/01/2018 01:00 11
01/01/2018 01:30 15
01/01/2018 02:00 20
...
This could be done in memory (with some limitations in plotting a graph from a memory array) or placed on another worksheet which would allow the normal Excel graph options.

Is the data already in an Excel worksheet with the date in column A and each of the half hour data in corresponding columns B:AW (00:30 to 24:00)?
Or is this a text output of some data collection system?

In my experience 00:00 is used instead of 24:00. Is that the case for your setup and B should contain 00:00 or does AW contain 24:00 values?