locked
Generate Line Chart (3 lines) from a CSV file RRS feed

  • Question

  • User-521014437 posted

     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

    <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>

    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

    <o:p> </o:p>

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

    <o:p> </o:p>

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

    Regards,

    Eric

    <o:p> </o:p><o:p> </o:p>

     

    Wednesday, July 1, 2009 10:00 PM

All replies

  • User-1341446551 posted

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

    Friday, July 3, 2009 1:50 PM
  • User-521014437 posted

    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!

    Saturday, July 4, 2009 4:53 AM
  • User-1341446551 posted

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

     

    Sunday, July 5, 2009 4:18 AM
  • User-1800386268 posted

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

    Wednesday, February 20, 2019 10:15 PM