2.1.1443 Part 1 Section 21.2.2.42, dispBlanksAs (Display Blanks As)

a.   The standard places no restriction on @val beyond ST_DisplayBlanksAs.

The following table shows which chart types support which methods of displaying blank cells.  The supported methods often depend on the chart’s grouping ("[ISO/IEC-29500-1] §21.2.2.76; grouping") type.

Chart Type

Gap

Span

Zero

Default

("[ISO/IEC-29500-1] §21.2.2.16; barChart (Bar Charts)")

gap

("[ISO/IEC-29500-1] §21.2.2.15; bar3DChart (3D Bar Charts)")

gap

("[ISO/IEC-29500-1] §21.2.2.5; areaChart (Area Charts)") where grouping is standard

gap

("[ISO/IEC-29500-1] §21.2.2.5; areaChart (Area Charts)") where grouping is not standard

zero

("[ISO/IEC-29500-1] §21.2.2.4; area3DChart (3D Area Charts)")

zero

("[ISO/IEC-29500-1] §21.2.2.97; lineChart (Line Charts)") where grouping is standard

gap

("[ISO/IEC-29500-1] §21.2.2.97; lineChart (Line Charts)") where grouping is not standard

zero

("[ISO/IEC-29500-1] §21.2.2.96; line3DChart (3D Line Charts)")

gap

("[ISO/IEC-29500-1] §21.2.2.141; pieChart (Pie Charts)")

gap

("[ISO/IEC-29500-1] §21.2.2.140; pie3DChart (3D Pie Charts)")

gap

("[ISO/IEC-29500-1] §21.2.2.50; doughnutChart (Doughnut Charts)")

gap

("[ISO/IEC-29500-1] §21.2.2.20; bubbleChart (Bubble Charts)")

gap

("[ISO/IEC-29500-1] §21.2.2.161; scatterChart (Scatter Charts)")

gap

("[ISO/IEC-29500-1] §21.2.2.153; radarChart (Radar Charts)")

gap

If a method of displaying blank cells not supported by the chart type is specified, the chart uses its default method of displaying blank cells.

Show: