Excel graphs

[Murr007]

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)?



[TABLE="width: 457"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Maintenance[/TD]
[TD] MW[/TD]
[TD] Start time[/TD]
[TD] End time[/TD]
[/TR]
[TR]
[TD]Station 1[/TD]
[TD="align: right"]2300[/TD]
[TD="align: right"]2014/12/04 02:38[/TD]
[TD="align: right"]2015/04/06 07:12[/TD]
[/TR]
[TR]
[TD]Station 23[/TD]
[TD="align: right"]3600[/TD]
[TD="align: right"]2015/01/05 11:21[/TD]
[TD="align: right"]2015/03/18 02:12[/TD]
[/TR]
[TR]
[TD]Station 89[/TD]
[TD="align: right"]1800[/TD]
[TD="align: right"]2015/01/06 02:38[/TD]
[TD="align: right"]2015/05/06 01:33[/TD]
[/TR]
</tbody>[/TABLE]

 

[Steve=True]

Hi Murr007,

Looking at your data, so you want a horizontal line for Station 1 at 2300 YAxis starting from Horizontal Dec-4-2014 going until Apr-6-2015?

And then you want a horizontal line for Station 23 at 3600 YAxis starting from Horizontal Jan-05-2015 going until Mar-18-2015?

Finally, you want a horizontal line for Station 1 at 2300 YAxis starting from Horizontal Jan-6-2014 going until May-6-2015?

Steve=True