Home IIS.NET Forums Logparser Forums Output Targets Generate Line Chart (3 lines) from a CSV file
Last post Feb 20, 2019 10:15 PM by LandonEvans
4 Posts
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
862 Posts
MVP
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...
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!
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... :(
1 Post
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.
4 Posts
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
862 Posts
MVP
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...
4 Posts
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!
862 Posts
MVP
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... :(
1 Post
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.