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

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

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[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