Hi
I need to create a graph in Excel, but the data have start and end dates. I've got more than 300 000 lines with data like that. Do you know how I can create a bar/line chart for daily/monthly MW maintenance with data like below (time on x-axis and MW on y-axis)?
I need to create a graph in Excel, but the data have start and end dates. I've got more than 300 000 lines with data like that. Do you know how I can create a bar/line chart for daily/monthly MW maintenance with data like below (time on x-axis and MW on y-axis)?
| Maintenance | MW | Start time | End time |
| Station 1 | 2300 | 2014/12/04 02:38 | 2015/04/06 07:12 |
| Station 23 | 3600 | 2015/01/05 11:21 | 2015/03/18 02:12 |
| Station 89 | 1800 | 2015/01/06 02:38 | 2015/05/06 01:33 |