How Charting deals with Null values

When your Series has NULL values, this can cause a problem with some types of charts. In particular, Line and Area charts do not display correctly when some values are missing.

There are a number of options which specify how to deal with NULLs.

Exclude where all values NULL

This option is on the Data tab.

When this is specified, a point will not be charted if the value is Null.

If you are charting multiple series, a point will only be excluded if the value is NULL for all series.

Include NULL values (will be displayed as 0)

This option is on the Series tab, and applies just to the selected series.

When this option is specified, the value will be charted by giving it a value of zero. For bar, point and bubble charts, this can be an appropriate way of depicting a NULL value.

Include NULL values (use avg)

This option is on the Series tab, and applies just to the selected series.

When this option is specified, the value will be charted by averaging the nearest non-NULL values. This is an appropriate option for line and area charts as it creates a smooth line between values.

AQT just uses a simple interpolation of nearest values. It does not use a more sophisticated averaging method.