Can't get data from a web page to chart in excel. Any solutions?

[goody444]

I want to chart some data I have copied from an internet website. I hav
two columns: column 1 is time and column 2 is a fluctuating value. Ther
are many data points so I cannot hand type the numbers. Here is a
example of the data I am trying to plot:

http://www.tradingday.com/is/siri.html

use this link and at the bottom there will be stock ticker values. Thi
is where the data is copied from. I would like to chart both "time" an
"price". My problem is listed below:

When I paste the numbers into excel, the columns of cells are "merged
so I have to split them to edit. Once that is done, I try to chart th
data but the graph comes up as completely blank.

I have also tried pasting the data as "paste special" pasting only wit
"values" yet this also does not work. It's not the data; if I type
sample of the data next to it, excel has no problem charting it. I
seems to be the format when the cell is pasted.

I have even gone through and tried to reformat the data, yet no matte
which format for the cells I choose, the numbers do not change. I hav
also gotten rid of any protection on the cells (ie locked data).

Does anyone have any idea how I can get these numbers to chart?

Sorry if that is confusing, please respond with any questions you have
Any help will be greatly appreciated!

Thanks

 

[R..VENKATARAMAN]

dont copy and paste use get external data in excel

open an excel workbook and any sheet
click data(menubar)-get extgernal dafa-new webquery.
in the<new webquery>window type the url
in the <address> bar
further steps are in excel 2002
click <go>
the whole web page will come in the window
the tables will have an yellow arrow
click the arrow of the particualr window and the arrow becomes a tick
then click <import>
follow the wizard
the table comes in excel and you can use it whatver purpose you want.
if there is problem send me an email