Forum Discussion
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 ...
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.