Share via

2.6.1.15 formulaRef

  • Article

Target namespace: http://schemas.microsoft.com/office/drawing/2012/chart

A CT_FormulaRef element (section 2.6.3.15) that specifies the visible data source reference for filtered out chart ([ISO/IEC29500-1:2016] section 21.2) series data. This element specifies the reference for the series caption or values or category labels for a chart series that is filtered out from the chart.

This reference is in the form of a book, sheet, and cell reference. This reference does not include the equals sign.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this element.

 <xsd:element name="formulaRef" type="CT_FormulaRef"/>

See section 5.13 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).