DRAW CHART IN EXCEL

[ThasiNguyen]

hi everyones , i have a table like this, so i want to draw a chart only one line that value at 0:00 of the before day connect to value of 1:00 in the nextday 

to make a chart like this 

Thanks alots for helping me.

[#2]

@ThasiNguyen You would have to flatten the data first into a table with one column for the hour, one for the date and one for the value. Then, a regular line chart will do the job.

Flattening the data can be done with Power Query as demonstrated in the attached example.