Broadband Speeds

rctneil

rctneil

rctneil

Associate
Joined
31 Jan 2007
Posts
1,861
If I have a list of download speeds like as follows:

14th February 2009 17:41:19 2373 Kbps
14th February 2009 12:27:00 2112 Kbps
12th February 2009 20:46:24 2342 Kbps
11th February 2009 21:22:12 2354 Kbps
11th February 2009 21:19:46 2358 Kbps


How can I get Excel to draw a graph of that data as when I select the cells and ask it to do a line graph the graph is not correct and my Excel knowledge is a bit old. i am using Excel 2007
 
seperate the dates and speed into two columns. Select all the data and press the graph button.

If your data is in one long string then use the Left and Mid functions to get the part of the string you need.
 
While its not slick, it worked after a bit of comma separation first before importing it into Excel.
I find if you can get the date/time in one column and the speed figures into another (either by putting commas to separate the two before import) and remove the 'kbps' text and just leave the speed purely as numbers, it will work. Worked for me.
 
Change the dates to a format excel recognises. Then format cell and select the date/time format. then click the graph button.
 
Right, I am just trying some excel functions out. I have a group of cells which the data within them in auto populated from some other cells. How can I lock the cells to those values so when i delete the cells the data was brought from then the values will stay the same?
 
rctneil said:
Right, I am just trying some excel functions out. I have a group of cells which the data within them in auto populated from some other cells. How can I lock the cells to those values so when i delete the cells the data was brought from then the values will stay the same?
Click to expand...

If i understand you correctly, can't you have some sort of archive sheet that is populated using a macro - triggered on some event.
 
You must log in or register to reply here.
Back
Top Bottom