Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Auto generate a graph help

02 Nov 2011   #1
dogwillhunt

Win7 64bit
 
 
Auto generate a graph help

Can any one help me find an app that will help me do this?

I want to automatically generate a line graph from a text CSV file that is automatically and constantly generated by another software I have running. Then I want the graph to be displayed/posted to a particular directory on my website, so it can be browsed to and seen whenever needed.

The generation of the data set is done automatically, and a new data point is added to the text CSV file every 30 seconds. It is set up in columns, and I would only need 4 of the 8 columns to be graphed.

I guess the graph could be a jpg and be generated locally and uploaded via auto reoccurring ftp. Or, the data text csv file could be auto ftp’d on a schedule to the web directory and the graph be auto generated there every time the text csv file is overwritten.

Any one know how to do this?


My System SpecsSystem Spec
.
02 Nov 2011   #2
bbinnard

Win7-64
 
 

If you know how to write VBA code you can do this with Excel. You can program Excel to read the data, create the graph, and export it to a JPG file that is in a folder accessible to your web server. With the right VBA code you can invoke FTP from within Excel and have it upload the graph image. If you have a web page that references this JPG a user will see the current graph any time they load or update the page.
My System SpecsSystem Spec
02 Nov 2011   #3
dogwillhunt

Win7 64bit
 
 

Quote   Quote: Originally Posted by bbinnard View Post
If you know how to write VBA code you can do this with Excel. You can program Excel to read the data, create the graph, and export it to a JPG file that is in a folder accessible to your web server. With the right VBA code you can invoke FTP from within Excel and have it upload the graph image. If you have a web page that references this JPG a user will see the current graph any time they load or update the page.
Thanks for the reply bbinnard, but I dont have Excel (been using LibreOffice) and I cant code at all!
My System SpecsSystem Spec
.

Reply

 Auto generate a graph help




Thread Tools




Similar help and support threads
Thread Forum
Graph upload bandwidth statistics over extended period
We are currently having issues with our internet connection, such as timing out on servers. After a lot of troubleshooting I think perhaps the issue is we are exceeding our upload bandwidth. To help identify this, I am looking for some software that can run in the background on a computer and graph...
Network & Sharing
*** Simple Muti-Series Line Graph ***
Goal: produce a line graph with these conditions * multiple lines (series) of K ** going across the graph using X data (horizontal axis) *** by Y (vertical axis) i don't know what to look for. the information out there is a mess, and it's hard to separate the garbage from the quality,...
Microsoft Office
Can't add values to Excel graph.
I just can't get new data to display on this graph (see below): http://www.mediafire.com/imgbnc.php/628220c5ad14e56fcc9c18f3a30331450461e373d13e7498ffb7e5c39e8d57af6g.jpg I enter the values in the table on the left, and they won't show up in the graph! This has just started happening, as you...
Microsoft Office
xperf disk io graph about flushes item
hi all, I have a question about an xperf diskI/O's item. whats meaning of flushes item of the diskI/O? Does it mean that write the log file to disk or other issue? there is its screenshot: http://i.imgur.com/T85et.jpg Why only my driver c has the flushes operation? (as the screenshot of...
Performance & Maintenance
Reliability Monitor Graph not working
Windows 7 Reliability Monitor Graph problem. I have 2 computers, both exactly the same hardware, running Windows 7 Home premium installed at the same time on both computers. (January 2010) The reliability monitor graph in one computer works as it should showing the details and reliability index....
Performance & Maintenance
Reliability Monitor Wont Display Graph
Im having a really tough to TS problem with the reliability monitor. For the last week, it no longer displays any data and the graph dosent render. It just display as blank with no data. Some things to note... 1. The RAC published and State data are being updated and published each day as...
Performance & Maintenance


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 07:26.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App