Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.lang.visual.basic    |    MS Visual Basic discussions, NOT dot-net    |    10,840 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 9,757 of 10,840    |
|    Saxman |
|    Graph Problem    |
|    20 Nov 05 12:19:08    |
      From: @btinternet.com              I have an Excel worksheet that extracts live data from the web to a column       at regular time intervals set by the user and is continuously updated.              I could transfer this data to another workbook/worksheet by creating a       macro and producing a graph wherby time could be reproduced along the       horizontal axis and the other data reproduced on the vertical axis?              I think I would have to create a timer function within the VB code, so the       data could be copied/pasted at a set intervals; or is there a simpler way?       I think each set fresh data would require pasting into a new column in a       new workbook/worksheet in order to create a graph simply?              There must be some coding that I could adapt from finacial worksheet       somewhere?              Sorry if I am not explicit enough, as I only have a basic knowledge of VB6.              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca