Generate Line Chart (3 lines) from a CSV fileRSS

4 replies

Last post Feb 20, 2019 10:15 PM by LandonEvans

‹ Previous Thread|Next Thread ›
  • Generate Line Chart (3 lines) from a CSV file

    Jul 01, 2009 10:00 PM|pentiumeric|LINK

     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

      

     

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

    Jul 03, 2009 01:50 PM|ma_khan|LINK

     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...

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

    Jul 04, 2009 04:53 AM|pentiumeric|LINK

    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!

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

    Jul 05, 2009 04:18 AM|ma_khan|LINK

     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... :(

     

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

    Feb 20, 2019 10:15 PM|LandonEvans|LINK

    I suggest you try https://zetexcel.com/. it will speed up your work and also help in cross-platform application.

‹ Previous Thread|Next Thread ›