Results 1 to 2 of 2

Thread: Excel 2010 graph

  1. #1

    Excel 2010 graph



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Excel 2010 with PowerPivot Add-In.
    Gantt chart.
    Edit labels and date/time to suit.
    http://www.mediafire.com/view/x40f09.../11_10_14.xlsm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •