Database source (Project Data)

The most common type of data to be plotted on a chart is the data from your database.  This is referred to as Project Data in the Source dropdown.

To specify this series type, you must select a Group and then select an X and Y column from that group.

If your dataset has more than one series within the Group, such as a PSD graph, then you can specify a field to split and group your data.  You can group by any field within the selected Group, parent groups, or depth-linked table.

Each group will be displayed with the next line style and symbol in the selected sets.  Create a line set /symbol set with a single style if you wish to display all the groups similarly.

Note: You can currently only group by a single parameter – if you need to split by multiple parameters, then you need to create a concatenated string in your Group and then select this field to group by.

Creating a Fixed Point Series

Fixed points are the second most common series type.  These can be used to draw fixed lines (such as A Line or Sieve Sizes on charts) or can be used to position labels at fixed points on a chart.

To create a set of points you need to define the coordinates of the points in simple x,y format with each point on a separate line.  Please note that no spaces are allowed between the values and the separator must be a coma.

0,0
10,10

To add labels to the data points, the label must be defined before the data, as shown below:

ML,45,5
MH,55,5
CL,45,55
CH,55,55

The example below shows 3 fixed-point datasets:

• The Aline is made up of 3 points, no markers and a black line style
• The vertical divide line at LL = 50 is made up of two point, no markers and a black line style
• The Classification labels are made up of 4 points with label values and use the ChartPoint symbol with a 2.5 scale so it appears to circle the label

Expression Series

An expression series is a powerful way to add a line or set of points to a chart that is defined by an equation.  For example a zero Air Voids Ratio line on a compaction test or a circle on a Mohr’s circle plot.

Any field that can be used for the group by parameter can be used in the expression.  To reference fields you must use the [GroupName.FieldName] format as shown below:

5% Air Voids Line

y = (1-(5/100))/((1/ [CompactionGeneral.ParticleDensity])+(x/100))

Circle of 10 radius centred on 30,30

y = 30-Sqrt(Pow(10,2)-Pow((x-30),2))

Note the following: 

• The Equation can be defined in terms of x = or y =   
• The program will divide the axis into a number of equally distributed points based on the Count number and apply the equation to each point to generate the data points
• When referencing the other axis in the equation, a lower case x or y must be used