home bbs files messages ]

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