asked on Using Excel 2010 to chart data from a text file
I'm trying to track some network performance stats on a couple of workstations. I've written a small vbscript to handle the job, and it works nicely, in the background, generating a tab-delimited text file as it goes. I have it running as a scheduled task, that kicks off every 5 minutes.
The fields are as follows:
site
TimeStamp
ResponseTime
So my file might look something like:
www.yahoo.com 11:06:37 AM 672
www.ucla.edu 11:06:37 AM 110
www.whatever.com 11:06:38 AM 169
www.yahoo.com 11:11:37 AM 535
www.ucla.edu 11:11:37 AM 115
www.whatever.com 11:11:38 AM 168
www.yahoo.com 11:16:37 AM 588
www.ucla.edu 11:16:37 AM 111
www.whatever.com 11:16:38 AM 170
What I want is a chart that will show the response times in the vertical axis, and the time on the horizontal axis. I want each site to have its own colored line in the graph.
How do I do that?
The fields are as follows:
site
TimeStamp
ResponseTime
So my file might look something like:
www.yahoo.com 11:06:37 AM 672
www.ucla.edu 11:06:37 AM 110
www.whatever.com 11:06:38 AM 169
www.yahoo.com 11:11:37 AM 535
www.ucla.edu 11:11:37 AM 115
www.whatever.com 11:11:38 AM 168
www.yahoo.com 11:16:37 AM 588
www.ucla.edu 11:16:37 AM 111
www.whatever.com 11:16:38 AM 170
What I want is a chart that will show the response times in the vertical axis, and the time on the horizontal axis. I want each site to have its own colored line in the graph.
How do I do that?
Microsoft Excel
Last Comment
David Spigelman
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
The sample is exactly what I had envisioned. I have to look up how you did the whole dynamic range thing - I'm not really familiar with the INDEX() function, but yeah - this does what I wanted. Thanks!