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?

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.

bbinnard said:

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!