2.1.1452 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.