Time on X-Axis

[odoolead50]

Hello Team,
I am trying to solve the below questions and I have attached a data file. I tried a line chart and excel only picks each day. I want to a line bar based on 15 minute intervals for each day

1. 15min interval kwh power - X—Axis time, Y-Axis kwh
2. Daily sum 30 days - Days on X-Axis, Y-Axis kwh

Thanks for all the help

 

[vletm]

odoolead50​

Could You show some kind of visual idea of Your needs?
... especially Daily sum 30 days ... from Your 30 days data.

 

[p45cal]

Use an xy scatter for the 15 minute chart (first chart in attached), and pivot & chart, grouping the times by day (second chart).