Connect null values

If you have some gaps in your dataset, by enabling the Connect null values option, the previous and next data values will be connected in continuity so there is no break in the chart plotting. This option is only possible for certain chart types like Line, Spline, Step, all Area charts, Master/Details charts (except Column), and Dual Axis charts.

General settings

  1. In the upper-right corner, click EDIT.

  2. Click Data Series to expand the section.

  3. Select the General tab.

  4. Check the box next to Connect null values.

This option can be set only in the General section for all chart types listed above, except for Dual Axis charts. For Dual Axis charts, it is necessary to enable this option for individual series if that series is of Line, Spline, Step, or Area chart type.

Individual series settings

Let’s check out how you can enable this option for Dual Axis chart types:

  1. In the upper-right corner, click EDIT.

  2. Click Data Series to expand the section.

  3. Open the Series tab, and click a series to expand it.

  4. Check the box next to Connect null values.