Forum Discussion

ThasiNguyen's avatar
ThasiNguyen
Copper Contributor
Apr 07, 2023

DRAW CHART IN EXCEL

 

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.

 

 

excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Apr 08, 2023

    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.

     

Resources