Date and time in X axis when in different columns

Thoron6

New Member
Joined
Oct 27, 2015
Messages
27
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
 
Last edited:

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

pbornemeier

Well-known Member
Joined
May 24, 2005
Messages
3,874
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,099
Messages
5,570,210
Members
412,309
Latest member
Benky
Top