In this tutorial we show how to use the graphing package to plot data directly from spreadsheets in real time.
The first step is to configure the graph software to request the data from a server script. The server script will open and read the spreadsheet and pass the data to the graph. This is done with the parameter 'JpGraphPropertyFile'.
Here is the configuration used for this graph:-
For this example we have created the data script with PHP but the server side script can be written in any server side language e.g. Java, ASP, Python etc.
The script is fairly straight forward and performs the following steps:-
Whenever the spreadsheet is updated the graph will automatically update with the new values.