+ Reply to Thread
Results 1 to 1 of 1

How to make a real time active line chart

  1. #1
    Forum Contributor
    Join Date
    11-14-2014
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    100

    How to make a real time active line chart

    I have made the excel workbook [attached]
    I want it to plot a two line chart of time against two updating values defined in two cells that are fed from an updating web page
    I have got the data feed for the chart working using VBA so that every 5 min's a new date/time and the two values are added to the chart data feed, however the new time is not adding to the actual graph when the data updates and for some reason when i run the macro it seems to disable the "auto refresh" for the two web page's feed's

    can anyone throw any light on this

    cheer's

    P/s often when the web page does actually manage to up date due to the web page itself the web data appears in different cells on the sheet which is why you will see that I have had to ask excel to first find the data cell i want and then place the value into another cell before the macro reads it.
    Attached Files Attached Files
    Last edited by semajjames; 02-03-2015 at 12:35 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 12-01-2013, 06:11 PM
  2. Line chart values shows deviation from real data
    By ssshnitco in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-07-2013, 04:32 PM
  3. Real Time Line Chart revisited.
    By GuluGuluu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2012, 09:32 AM
  4. How to make =NOW() real time?
    By Lewis Koh in forum Excel General
    Replies: 3
    Last Post: 04-22-2010, 08:19 AM
  5. Showing length of active cell in real time
    By jgoog in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2006, 06:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1