+ Reply to Thread
Results 1 to 7 of 7

Create Realtime Data Trend Chart

  1. 08-12-2017, 01:08 PM #1
    PatR78
    PatR78 is offline
    Registered User
    Join Date
    08-10-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    2016
    Posts
    11

    Create Realtime Data Trend Chart

    Hi,

    I've got a worksheet where I have realtime data updating into a new row every second. I'm trying to then transfer this in real time into a line chart but have a very basic understanding of Excel and also can't seem to find an answer to this query anywhere.

    I have linked a video on youtube below which shows exaclty what I want to do but this seems to suggest that I need some extra software.

    Can somebody please confirm to me if this is possible using Excel 2016 as it is or if not please tell me how I can do this.

    Thank you in advance I've linked the video here : https://youtu.be/xLTEnd1u5Eo

    Pat
    Reply With QuoteRegister To Reply
  2. 08-12-2017, 01:36 PM #2
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Create Realtime Data Trend Chart

    Where does your file update from?
    Could we see the workbook? It would make it easier to provide a solution.

    BSB
    Reply With QuoteRegister To Reply
  3. 08-12-2017, 01:37 PM #3
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Create Realtime Data Trend Chart

    https://www.mrexcel.com/forum/excel-...end-chart.html

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this http://www.excelguru.ca/content.php?184 to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  4. 08-12-2017, 01:56 PM #4
    PatR78
    PatR78 is offline
    Registered User
    Join Date
    08-10-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    2016
    Posts
    11

    Re: Create Realtime Data Trend Chart

    It probably wont do any good as the file sent as is wouldnt be populated as it wouldnt be connected to the software. BUt if its possible to do whats in the video I can build one from scratch
    Last edited by PatR78; 08-12-2017 at 02:08 PM.
    Reply With QuoteRegister To Reply
  5. 08-12-2017, 02:21 PM #5
    PatR78
    PatR78 is offline
    Registered User
    Join Date
    08-10-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    2016
    Posts
    11

    Re: Create Realtime Data Trend Chart

    I just need to know how to replicate whats in the video
    Reply With QuoteRegister To Reply
  6. 08-12-2017, 02:47 PM #6
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Create Realtime Data Trend Chart

    In that case I suppose you don't read the link in #3.

    Or you did not understand it, but if so, you could asked for it.
    Reply With QuoteRegister To Reply
  7. 08-12-2017, 03:08 PM #7
    PatR78
    PatR78 is offline
    Registered User
    Join Date
    08-10-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    2016
    Posts
    11

    Re: Create Realtime Data Trend Chart

    Sorry I didn't know I was cross posting as I didn't realise the other forum was the same as this one.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to create a trend based on series of data
    By khan_riyadh in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-16-2015, 01:12 PM
  2. [SOLVED] How to create a line chart to compare trend of two activities
    By LWLS in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-27-2014, 09:59 AM
  3. to create a chart/ trend diagram from data in two excel sheets.
    By anishmathw in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-19-2012, 10:56 AM
  4. How to show a data trend without a chart
    By Tall Paul in forum Excel General
    Replies: 8
    Last Post: 12-18-2009, 10:26 AM
  5. Trend Data Representation: which chart?
    By babarorhum in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-21-2008, 01:52 PM
  6. Realtime chart example
    By ntoze in forum Excel General
    Replies: 2
    Last Post: 04-10-2006, 12:16 PM
  7. [SOLVED] How to create trend line chart for MEDIAN in Excel?
    By Nitin Gupta in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-03-2005, 08: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1