Excel graph question (number & date)

[DLans]

Hi all,

I feel quite silly for not being able to figure this out. We queried some data using a plugin in Excel, to display resource consumption in our factories. In this example we're looking at the water consumption as measured by sensors across a 20 minute period: 

The consumption total column is formatted as "number, 9 decimals" and the Timestamp column has been formatted as "Time, hh:mm:ss" but tried custom as well. 

Over this period I'd like to make a super simple Excel graph, a line going up showing you when we used what amounts of water. However, the timestamp gets converted into a number which results in this:

How can I best display the consumption of water without seeing the timestamp as a line? I want the timestamps simply on the horizontal axis. Sorry for asking something so basic! 

[#2 · Accepted solution]

@DLans Try it this way (see attached).

You should only chart the consumption with the timestamps on the X-axis as labels.

[#3]

 @Riny_van_Eekelen That was as simple as I feared it would be, thank you!

[#4]

@DLans You're welcome!