+ Reply to Thread
Results 1 to 2 of 2

Moving Chart

  1. #1
    Registered User
    Join Date
    11-16-2018
    Location
    Russellville, Arkansas
    MS-Off Ver
    2010
    Posts
    1

    Moving Chart

    I need to be able to have a live plot of data vs timestamp. Is this possible in excel. For example, I would like 30 data points plotted. When the next time stamp is met (say every 30 seconds) then the oldest data point drops off and the new one is added. Thanks epduane

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Moving Chart

    Short but useless answer -- yes, this is possible.

    I find that a lot of charting questions are really spreadsheet questions, but you have not shared any details of your spreadsheet. In a broad overview, I would expect something like the following procedure:
    1) Import step to bring raw data into the spreadsheet (sounds like you already have this step).
    2a) Add a helper range with appropriate formulas to extract the most recent 30 points from the raw data. OR
    2b) Add appropriate dynamic named ranges that point to the most recent 30 points in the raw data.
    3) Create chart that uses either 2a or 2b as the source data.

    What part do you get stuck on?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Error when moving chart into another chart sheet
    By pp57 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-05-2017, 11:20 AM
  2. Excel Line Chart - 12 month chart moving with dates
    By rockycj in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-13-2013, 06:41 PM
  3. Moving a chart with VBA
    By jeskit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2011, 06:23 AM
  4. Chart with moving range
    By CarlosAndres in forum Excel General
    Replies: 2
    Last Post: 06-09-2010, 11:01 AM
  5. Moving Pivot Chart Fields on a chart sheet
    By sherobot in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-28-2006, 05:15 PM
  6. Moving data for a chart
    By ajames in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-13-2006, 10:30 PM
  7. [SOLVED] Chart items moving around
    By Marcus Langell in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-26-2005, 05:05 AM

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