There a three main ways that data can be shown on a chart 

• Creating a data series
• Creating a fixed-point series
• Creating an expression series

They are selected from the Source drop-down on the Chart Data tab.

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.

Dataset Group

The dataset group is the combination of results. For example, if you want to show the data from a PSD on a plot, your group and x and y will be on the PSD data group but we only want a single line per PSD General. We would set the dataset group to PSD General. This will then make a single line or each of the PSD General rows with the data from the correct table.

In simple terms, it's the grouping of the data together by a parent record. 

Group by

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))

 

For example, a proctor/compaction curve would use expressions. 

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