Auto generate a graph help

[dogwillhunt]

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?

 

[bbinnard]

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.

 

[dogwillhunt]

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!