2.1.1447 Part 1 Section 21.2.2.48, dLblPos (Data Label Position)

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

In Office, if the ancestor does not include a ser element any position value is allowed. However, if a ser element is an ancestor the following rules apply based on the chart group ancestor:

  • For chart groups ofPieChart ("[ISO/IEC-29500-1] §21.2.2.126; ofPieChart (Pie of Pie or Bar of Pie Charts)"), pie3DChart ("[ISO/IEC-29500-1] §21.2.2.140; pie3DChart (3D Pie Charts)"), and pieChart ("[ISO/IEC-29500-1] §21.2.2.141; pieChart (Pie Charts)") the valid positions are BestFit, OutsideEnd, InsideEnd, Center.

  • For the chart groups barChart ("[ISO/IEC-29500-1] §21.2.2.16; barChart (Bar Charts)") where grouping is clustered the valid positions are InsideBase, InsideEnd, OutsideEnd, Center.

  • For the chart groups barChart ("[ISO/IEC-29500-1] §21.2.2.16; barChart (Bar Charts)") where grouping is stacked or percentStacked the valid positions are InsideBase, InsideEnd, Center.

  • For chart groups bubbleChart ("[ISO/IEC-29500-1] §21.2.2.20; bubbleChart (Bubble Charts)"), lineChart ("[ISO/IEC-29500-1] §21.2.2.97; lineChart (Line Charts)"), scatterChart ("[ISO/IEC-29500-1] §21.2.2.161; scatterChart (Scatter Charts)"), and stockChart ("[ISO/IEC-29500-1] §21.2.2.161; scatterChart (Scatter Charts)") the valid positions are left, right, bottom, top, center.

For chart groups areaChart "[ISO/IEC-29500-1] §21.2.2.5; areaChart (Area Charts)"), area3DChart ("[ISO/IEC-29500-1] §21.2.2.4; area3DChart (3D Area Charts)"), bar3DChart ("[ISO/IEC-29500-1] §21.2.2.15; bar3DChart (3D Bar Charts)"), doughnutChart ("[ISO/IEC-29500-1] §21.2.2.50; doughnutChart (Doughnut Charts)"), line3DChart ("[ISO/IEC-29500-1] §21.2.2.96; line3DChart (3D Line Charts)"), radarChart ("[ISO/IEC-29500-1] §21.2.2.153; radarChart (Radar Charts)") this element shall not be specified.

b.   The standard does not define the behavior when the dLblPos element is omitted.

For Office, the following lists the chart types and their default position based on the chart group ancestor:

  • For chart groups ofPieChart ("[ISO/IEC-29500-1] §21.2.2.126; ofPieChart (Pie of Pie or Bar of Pie Charts)"), pie3DChart ("[ISO/IEC-29500-1] §21.2.2.140; pie3DChart (3D Pie Charts)"), and pieChart ("[ISO/IEC-29500-1] §21.2.2.141; pieChart (Pie Charts)") the automatic position is BestFit.

  • For chart groups areaChart "[ISO/IEC-29500-1] §21.2.2.5; areaChart (Area Charts)"), area3DChart ("[ISO/IEC-29500-1] §21.2.2.4; area3DChart (3D Area Charts)"), and doughnutChart ("[ISO/IEC-29500-1] §21.2.2.50; doughnutChart (Doughnut Charts)") the automatic position is Center.

  • For chart groups barChart ("[ISO/IEC-29500-1] §21.2.2.16; barChart (Bar Charts)") and bar3DChart ("[ISO/IEC-29500-1] §21.2.2.15; bar3DChart (3D Bar Charts)") where grouping ("[ISO/IEC-29500-1] §21.2.2.77; grouping") is stacked or percentStacked; the automatic position is Center.

  • For chart groups barChart, and bar3Dchart where grouping is clustered, and radarChart ("[ISO/IEC-29500-1] §21.2.2.153; radarChart (Radar Charts)") the automatic position is OutsideEnd.

  • For chart groups bubbleChart ("[ISO/IEC-29500-1] §21.2.2.20; bubbleChart (Bubble Charts)"), scatterChart ("[ISO/IEC-29500-1] §21.2.2.161; scatterChart (Scatter Charts)"), stockChart ("[ISO/IEC-29500-1] §21.2.2.161; scatterChart (Scatter Charts)"), lineChart ("[ISO/IEC-29500-1] §21.2.2.97; lineChart (Line Charts)"), and line3DChart ("[ISO/IEC-29500-1] §21.2.2.96; line3DChart (3D Line Charts)") the automatic position is Right.

Show: