Differ Non-Detect Data Points in XY Charts

<< Click to Display Table of Contents >>

Navigation:  Professional > Tools & Charts > XY Charts >

Differ Non-Detect Data Points in XY Charts

The Differ Non-Detects chart parameter in XY Charts in Professional has "Yes" and "No" values and defaults to "No". When "Yes" is selected, the diamond shape is applied to non-detects data points of a default scatter chart where the default shape of data points is circle.

 

Note: For the Differ Non-detects parameter to work, the Dataset of the XY Charts must have a column named DETECT_FLAG (e.g., an Analytical Results II report results table has it). XY Charts processes or formats non-detects points by finding their associated DETECT_FLAG values (=N).

 

Here is an example:

1.Run the Analytical Results II Report with some non-detect values (DETECT_FLAG = N) in the results.

2.Click the XY Chart PRO_Graph-XY-16 button on the grid toolbar. Select Group Series By as CHEMICAL_NAME and Differ Non-detects as "Yes". Click Add Series to create a chart.

 

Notes:

Non-detect points use diamond shaped symbols and the same colors as other markers of their corresponding series.

If non-detect values are relatively small, they may not be seen clearly. Press mouse-left key on a place of the chart area and drag it to select an area around the non-detects to zoom in. Double-click on the chart area of the zoomed in chart to bring the original chart back.

 

3.Select View > Advanced > All Series, find Misc in the Advanced tab, and modify ScatterConnectType from None to Line. You can see a line-scatter chart with differed non-detects points.

4.Click Send To Excel from the Chart Toolbar to export the chart to Excel. Unhide the data worksheet to change the formats of the Y-axis by entering max of Y = 50 to see non-detect points clearly.