Share via

1.3.1 Charts

  • Article

Chart extensions add a number of features to charts ([ISO/IEC29500-1:2016] section 21.2). Following are the new extensions:

  • The invertSolidFillFmt extension for the ser element described in [ISO/IEC29500-1:2016] section 21.2.2.170 and the ser element described in [ISO/IEC29500-1:2016] section 21.2.2.174 specify the color of the negative data points of the chart series ([ISO/IEC29500-1:2016] section 21.2).

  • The pivotOptions extension for the chartspace element ([ISO/IEC29500-1:2016] section 21.2.2.29) specifies which pivot controls appear on the chart ([ISO/IEC29500-1:2016] section 21.2).

  • The style extension for the chartspace element ([ISO/IEC29500-1:2016] section 21.2.2.29) specifies the new styles of the chart ([ISO/IEC29500-1:2016] section 21.2).

  • The filteredLineSeries extension for the lineChart element ([ISO/IEC29500-1:2016] section 21.2.2.97) and the line3DChart ([ISO/IEC29500-1:2016] section 21.2.2.96) specifies a series that has been filtered from the chart ([ISO/IEC29500-1:2016] section 21.2).

  • The filteredScatterSeries extension for the scatterChart element ([ISO/IEC29500-1:2016] section 21.2.2.161) specifies a series that has been filtered from the chart ([ISO/IEC29500-1:2016] section 21.2).

  • The filteredRadarSeries extension for the radarChart element ([ISO/IEC29500-1:2016] section 21.2.2.153) specifies a series that has been filtered from the chart ([ISO/IEC29500-1:2016] section 21.2).

  • The filteredBarSeries extension for the barChart element ([ISO/IEC29500-1:2016] section 21.2.2.16) and the bar3DChart ([ISO/IEC29500-1:2016] section 21.2.2.15) specifies a series that has been filtered from the chart ([ISO/IEC29500-1:2016] section 21.2).

  • The filteredAreaSeries extension for the areaChart element ([ISO/IEC29500-1:2016] section 21.2.2.5) and the area3DChart ([ISO/IEC29500-1:2016] section 21.2.2.4) specifies a series that has been filtered from the chart ([ISO/IEC29500-1:2016] section 21.2).

  • The filteredBubbleSeries extension for the bubbleChart element ([ISO/IEC29500-1:2016] section 21.2.2.20) specifies a series that has been filtered from the chart ([ISO/IEC29500-1:2016] section 21.2).

  • The filteredSurfaceSeries extension for the surfaceChart element ([ISO/IEC29500-1:2016] section 21.2.2.204) and the surface3DChart ([ISO/IEC29500-1:2016] section 21.2.2.203) specifies a series that has been filtered from the chart ([ISO/IEC29500-1:2016] section 21.2).

  • The fullRef extension for the strRef element ([ISO/IEC29500-1:2016] section 21.2.2.201) and the numRef ([ISO/IEC29500-1:2016] section 21.2.2.123) and the multiLvlStrRef ([ISO/IEC29500-1:2016] section 21.2.2.115) specifies the non-filtered data source reference for filtered out chart ([ISO/IEC29500-1:2016] section 21.2) series data.

  • The levelRef extension for the strRef element ([ISO/IEC29500-1:2016] section 21.2.2.201) and the numRef ([ISO/IEC29500-1:2016] section 21.2.2.123) and the multiLvlStrRef ([ISO/IEC29500-1:2016] section 21.2.2.115) specifies the data source reference for the currently selected label level for a chart ([ISO/IEC29500-1:2016] section 21.2) category axis or a chart ([ISO/IEC29500-1:2016] section 21.2) series title.

  • The formulaRef extension for the strRef element ([ISO/IEC29500-1:2016] section 21.2.2.201) and the numRef ([ISO/IEC29500-1:2016] section 21.2.2.123) and the multiLvlStrRef ([ISO/IEC29500-1:2016] section 21.2.2.115) specifies the data source reference of the parent element when the parent is part of an extension list.

  • The filteredSeriesTitle extension for the ser element ([ISO/IEC29500-1:2016] section 21.2.2.168) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.170) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.174) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.171) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.172) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.169) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.167) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.173) specifies a chart ([ISO/IEC29500-1:2016] section 21.2) series title that has been filtered from the chart ([ISO/IEC29500-1:2016] section 21.2).

  • The filteredCategoryTitle extension for the ser element ([ISO/IEC29500-1:2016] section 21.2.2.168) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.170) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.174) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.171) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.172) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.169) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.167) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.173) specifies a chart ([ISO/IEC29500-1:2016] section 21.2) category title that has been filtered from the chart ([ISO/IEC29500-1:2016] section 21.2).

  • The pivotSource extension for the chartspace element ([ISO/IEC29500-1:2016] section 21.2.2.29) specifies the source Non-Worksheet PivotTable ( [MS-XLSX] section 2.3.3 and [MS-XLSB] section 2.2.5.5 for the chart ([ISO/IEC29500-1:2016] section 21.2).

  • The numFmt extension for the catAx element ([ISO/IEC29500-1:2016] section 21.2.2.25), dateAx element ([ISO/IEC29500-1:2016] section 21.2.2.39), serAx element ([ISO/IEC29500-1:2016] section 21.2.2.175) and valAx element ([ISO/IEC29500-1:2016] section 21.2.2.226) that specifies the number formatting for the chart category axis, date axis, series axis and value axis ([ISO/IEC29500-1:2016] section 21.2) whose pivotSource element specifies a Non-Worksheet PivotTable ([MS-XLSX] section 2.3.3 and [MS-XLSB] section 2.2.5.5).

    The showLeaderLines extension for the dLbls element ([ISO/IEC29500-1:2016] section 21.2.2.49) specifies whether leader lines will be rendered for Datalabels (section 2.2.1.2) in a chart of any type.

  • The leaderLines extension for the dLbls element ([ISO/IEC29500-1:2016] section 21.2.2.49) specifies the formatting of leader lines for Datalabels in a chart of any type.

  • The datalabelsRange extension for the ser element ([ISO/IEC29500-1:2016] section 21.2.2.168) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.170) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.174) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.171) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.172) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.169) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.167) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.173) specifies the reference to the formula from which the values of dLbls element on a chart series ([ISO/IEC29500-1:2016] section 21.2) are obtained.

  • The categoryFilterExceptions extension for the ser element ([ISO/IEC29500-1:2016] section 21.2.2.168) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.170) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.174) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.171) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.172) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.169) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.167) and the ser element ([ISO/IEC29500-1:2016] section 21.2.2.173) specifies special formatting properties of data points that have been filtered out from the chart series ([ISO/IEC29500-1:2016] section 21.2).

  • The dlblFieldTable extension for the dLbls element ([ISO/IEC29500-1:2016] section 21.2.2.49) or the dLbl element ([ISO/IEC29500-1:2016] section 21.2.2.47) specifies the list of formulas from which the value of individual data fields in the Datalabel (section 2.2.1.3) is obtained.

  • The xForSave extension for the dLbl element ([ISO/IEC29500-1:2016] section 21.2.2.47) specifies if this Datalabel was created as an exception entry only for saving, but is treated the same as the prototype Datalabel in the collection.

  • The showDataLabelsRange extension for the dLbls element ([ISO/IEC29500-1:2016] section 21.2.2.49) or the dLbl element ([ISO/IEC29500-1:2016] section 21.2.2.47) specifies if the value of the Datalabel contains the range field which allows values to be specified from a formula for multiple Datalabels.

  • The tx extension for the dLbls element ([ISO/IEC29500-1:2016] section 21.2.2.49) specifies the custom text associated with the Datalabels collection, which determines the value of each Datalabel in that collection.

  • The spPr extension for the dLbls element ([ISO/IEC29500-1:2016] section 21.2.2.49) or the dLbl element ([ISO/IEC29500-1:2016] section 21.2.2.47) specifies the shape geometry for the Datalabel.

  • The layout extension for the dLbls element ([ISO/IEC29500-1:2016] section 21.2.2.49) or the dLbl element ([ISO/IEC29500-1:2016] section 21.2.2.47) specifies the custom size of the Datalabel.

  • The autoCat extension for the strLit element ([ISO/IEC29500-1:2016] section 21.2.2.200) specifies if the category captions for the chart series were automatically generated and saved out as literal data.

  • The pivotOptions16 extension for the chartspace element ([ISO/IEC29500-1:2016] section 21.2.2.29) specifies additional pivot controls that can appear on the chart ([ISO/IEC29500-1:2016] section 21.2).