« Previous Next »

Thread: Generate Line Chart (3 lines) from a CSV file

Last post 07-05-2009 4:18 AM by ma_khan. 3 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (4 items)

Sort Posts:

  • 07-01-2009, 10:00 PM

    Generate Line Chart (3 lines) from a CSV file

     Hello,

     

    CSV file A

    Date, Place, Level

    12/6, A site, 12.435

    13/6, A site, 53.454

    14/6, A site, 1.545

    12/6, B site, 43.456

    13/6, B site, 14.542

    14/6, B site, 21.512

    12/6, C site, 12.212

    13/6, C site, 2.321

    14/6, C site, 32.514

     

    I have a CSV file like the one above.

    I would like output a line chart, with 3 lines, one of A, one for B and one for C

    X-axis would be Date, and Y-axis would be Level.

     

    If the CSV file is organized as below, I could generate the chart I want easily

     

    CSV file B

    Date, A Site, B Site C Site

    12/6, 12.435, 43.456, 12.212

    13/6, 53.454, 14.542, 2.321

    14/6, 1.545, 21.512, 32.514

     

    Would anyone advise on plotting the graph directly from CSV file A, or a method to convert file A to B?

     

    I am a newbie of Log Parser, just use it for one week

    Regards,

    Eric

      

     

  • 07-03-2009, 1:50 PM In reply to

    Re: Generate Line Chart (3 lines) from a CSV file

     if you want to make the chart in excel itself and then probably copy it into PPT or something like that then prepare it from excel directly...

    Regards,
    MA Khan
    http://www.iisworkstation.com

    “Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. ”
  • 07-04-2009, 4:53 AM In reply to

    Re: Generate Line Chart (3 lines) from a CSV file

    i would like to generate it by log parser..and automate the process..

     As i am doing some performance analysis on SAN, there are many  graph i would need to produce.

     Is there any method to do them in log parser?

     

    Thx!

  • 07-05-2009, 4:18 AM In reply to

    Re: Generate Line Chart (3 lines) from a CSV file

     there are ways through which you can prepare graphs ... but the problem is there is not enough documentation on LP on net... wont be able to direct you to a link... :(

     

    Regards,
    MA Khan
    http://www.iisworkstation.com

    “Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. ”
Page 1 of 1 (4 items)
Microsoft Communities