software

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

www.tradingday.com/is/siri.html

use this link and at the bottom there will be stock ticker values. This
is where the data is copied from. I would like to chart both quot;timequot; and
quot;pricequot;. My problem is listed below:

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

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

I have even gone through and tried to reformat the data, yet no matter
which format for the cells I choose, the numbers do not change. I have
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!--
goody444
------------------------------------------------------------------------
goody444's Profile: www.excelforum.com/member.php...oamp;userid=32015
View this thread: www.excelforum.com/showthread...hreadid=517638dont 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 thelt;new webquerygt;window type the url
in the lt;addressgt; bar
further steps are in excel 2002
click lt;gogt;
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 lt;importgt;
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

quot;goody444quot; gt; wrote in
message ...
gt;
gt; I want to chart some data I have copied from an internet website. I have
gt; two columns: column 1 is time and column 2 is a fluctuating value. There
gt; are many data points so I cannot hand type the numbers. Here is an
gt; example of the data I am trying to plot:
gt;
gt; www.tradingday.com/is/siri.html
gt;
gt; use this link and at the bottom there will be stock ticker values. This
gt; is where the data is copied from. I would like to chart both quot;timequot; and
gt; quot;pricequot;. My problem is listed below:
gt;
gt; When I paste the numbers into excel, the columns of cells are quot;mergedquot;
gt; so I have to split them to edit. Once that is done, I try to chart the
gt; data but the graph comes up as completely blank.
gt;
gt; I have also tried pasting the data as quot;paste specialquot; pasting only with
gt; quot;valuesquot; yet this also does not work. It's not the data; if I type a
gt; sample of the data next to it, excel has no problem charting it. It
gt; seems to be the format when the cell is pasted.
gt;
gt; I have even gone through and tried to reformat the data, yet no matter
gt; which format for the cells I choose, the numbers do not change. I have
gt; also gotten rid of any protection on the cells (ie locked data).
gt;
gt; Does anyone have any idea how I can get these numbers to chart?
gt;
gt; Sorry if that is confusing, please respond with any questions you have.
gt; Any help will be greatly appreciated!
gt;
gt; Thanks!
gt;
gt;
gt; --
gt; goody444
gt; ------------------------------------------------------------------------
gt; goody444's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32015
gt; View this thread: www.excelforum.com/showthread...hreadid=517638
gt;