troubleshooting Question

Using Excel 2010 to chart data from a text file

Avatar of David Spigelman
David SpigelmanFlag for United States of America asked on
Microsoft Excel
2 Comments1 Solution291 ViewsLast Modified:
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?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros