Making graphs from updates...
 

Im currently monitoring the information from numerous different "single
figures" of data from a website, and wish to make a Time/Cost graph....
I was hoping to firstly monitor one figure, which alters due to
automatic updating, and plot a graph showing the change of this single
cost by time...eg. day 1 = 1.4, day 2 = 1.44, day 3 = 1.494 .....and
for it to plot the figures accordingly...

Also, i may need to do this with multiple figures, e.g. the same as
above but with resulting graphs placed on the same graph, showing the
fluctuations of for example 10 prices...

It would be perfect if it was possible to select the figures to observe
and add them to the next line after a certain time period in excel, on a
blank worksheet so i could make whatever graphs i needed...

If someone could help me it would be greatly appreciated...

Sincerly

Adrian :-)


--
ELBeanzio
------------------------------------------------------------------------
ELBeanzio's Profile: http://www.excelforum.com/member.php...o&userid=28949
View this thread: http://www.excelforum.com/showthread...hreadid=489442

Making graphs from updates...
 

Ive had a thorough sweep of the forum history and have found 3 very
similar questions relating to a stock ticker...I thought id repeat
myself so people understand me completley....

I have a cell that has a basic formulad calculation to give me a
figure...it says 1.78....tommorow it will say something like 1.75 and
the following day 1.72....I want excel to add a column with the date,
everyday with the updated figure...e.g..

30/11/05 1/12/05 2/12/05 3/12/05 4/12/05 5/15/05
6/12.....
1.78 1.75 1.72 1.70 1.69
1.69 1........

So..the days and the new updated figures that have been calculated from
figures off the website can be accumulated like a stock ticker......Does
anyone know how to do this ??? please help if you do..im at "
" if you do...

Please please please help !!!


--
ELBeanzio
------------------------------------------------------------------------
ELBeanzio's Profile: http://www.excelforum.com/member.php...o&userid=28949
View this thread: http://www.excelforum.com/showthread...hreadid=489442

Making graphs from updates...
 

I think the reason why eveyone is avoiding this post like the plague is
because it requres specific VBA and would prove to be a total pain in
the backside to explain without knowing exactly what needs to be
done....if you know this to be true please someone say yes......


--
ELBeanzio
------------------------------------------------------------------------
ELBeanzio's Profile: http://www.excelforum.com/member.php...o&userid=28949
View this thread: http://www.excelforum.com/showthread...hreadid=489442