+ Reply to Thread
Results 1 to 2 of 2

chart/track changing text/log file

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

    chart/track changing text/log file

    I have a program that reads a multimeter (thermometer) and logs the data to a text (tab delimited) file. I am looking for some way to follow the trends in the log file in something close to real time. If I had Excel on this computer, it would be easy. I would "Import External Data -> From Text -> Text import wizard -> Tell Excel to refresh the table every minute -> Insert chart based on the data table". Without Excel, though, I don't see an easy way to get the same effect, and was wondering if anyone here is aware of something.

    I thought about using LibreOffice Calc for this, but Calc's "import data" command only seems to work for html or xml type files.
    I found some information that suggests that Notepad++ can continuously (every 3 s) update a text file that it has open. Notepad++ doesn't have any charting abilities, though.

    It's probably a long shot, but I thought I would ask this community if anyone here has any ideas.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: chart/track changing text/log file

    I realized that I did not update this thread with the solution a colleague found. We found that we could use a stand alone charting package called Veusz for this: https://veusz.github.io/ Without going into great detail, we figured out how to build a basic scatter chart from two columns in the output file, then found a checkbox on the Date->Reload dialog that will update the chart if/when the file changes.

+ 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. Changing chart legend without excel file
    By excelquestionz in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-21-2021, 01:09 PM
  2. [SOLVED] How to keep track of changing teams without losing data.
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-29-2017, 10:01 AM
  3. Changing text in a text box on a chart
    By sverra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2016, 12:47 PM
  4. insert a text file with a changing name
    By renderman7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2012, 06:22 PM
  5. Changing a comma separated text file and save it.
    By BristolBreeze in forum Excel General
    Replies: 0
    Last Post: 03-23-2006, 06:35 AM
  6. [SOLVED] Changing an excel spreadsheet into a text delimited file
    By octrickesirk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-26-2005, 05:15 PM
  7. Import changing text file to Excel
    By Mark G in forum Excel General
    Replies: 4
    Last Post: 04-11-2005, 02:47 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