The Extension for Microsoft Excel has functionality to add data to charts once it has been reported into the spreadsheet.
You can set up charts in Excel using the normal techniques. It is however impossible to determine how many rows of data will be returned by the report as this will depend on your project size.
In the example below a standard Excel graph has been set up on the template sheet and a data set has been added to the graph. Two important items to note here are that the data set is called SPT and the chart is called Chart 2 (see name at the top left of the image)
Once your Excel chart has been set up you can then use the tools built into the Extension to ensure that all the data is plotted correctly.
To Link a chart on your template sheet to the data returned from the Extension follow the steps below.
Click the Charts icon on the Ribbon bar to bring the Chart form up as shown below.
The Charts form lists every data set that is available on every Chart on the template sheet. To link the dataset to the data returned from the Extension you must set the Table parameter to the name of the table you inserted into the worksheet, and the X and Y source values to the columns you want to plot. Click OK when these values have been set.
Generate the report to see all the values returned added to the chart.
It is important to note that the drop-down list of headers includes all the fields you have selected to return to your spreadsheet plus any equation columns you have added yourself (as long as you have put text in the cell at the top of the column as detailed in adding equations to the data table)
There is no limit to the number of charts you can have on the template page, or the number of series on these charts that link to reported data.
Generating Summary Graphs
Summary Graphs allow you to group your data into themed datasets, for example plotting all the Atterberg results on a single A-line plot with each Geology on a different data series.
To use this functionality activate one or more of the Summary column in your Charts window as shown below.
When this option is selected the program will generate a worksheet called summary when it runs and will add the selected dataset to the graph on the summary sheet for each grouped sheet on your workbook as shown below.