[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format Intellectual Property Rights Notice for Open Specifications Documentation

1289.1.1CT_SparklineGroups

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: sparklineGroups

CT_SparklineGroups is a complex type that specifies the groups of sparklines on the sheet. MUST contain fewer than 2³¹ elements.

Child Elements:

sparklineGroup: A CT_SparklineGroup element (section 2.6.7) that specifies properties for a single sparkline group.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

1290

1291

1292

1293

1294

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

1294.1.1CT_SparklineGroup

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_SparklineGroups

CT_SparklineGroup is a complex type that specifies properties for a sparkline group.

Child Elements:

colorSeries: A CT_Color ([ISO/IEC29500-4:2012] section A.2) element that specifies the color for each sparkline in this sparkline group. The auto attribute of the CT_Color element MUST NOT exist.

colorNegative: A CT_Color element that specifies the color of the negative data points for each sparkline in this sparkline group. The auto attribute of the CT_Color element MUST NOT exist.

colorAxis: A CT_Color element that specifies the color of the horizontal axis for each sparkline in this sparkline group. The auto attribute of the CT_Color element MUST NOT exist.

colorMarkers: A CT_Color element that specifies the color of the data markers for each sparkline in this sparkline group. The auto attribute of the CT_Color element MUST NOT exist.

colorFirst: A CT_Color element that specifies the color of the first data point for each sparkline in this sparkline group. The auto attribute of the CT_Color element MUST NOT exist.

colorLast: A CT_Color element that specifies the color of the last data point for each sparkline in this sparkline group. The auto attribute of the CT_Color element MUST NOT exist.

colorHigh: A CT_Color element that specifies the color of the highest data point for each sparkline in this sparkline group. The auto attribute of the CT_Color element MUST NOT exist.

colorLow: A CT_Color element that specifies the color of the lowest data point for each sparkline in this sparkline group. The auto attribute of the CT_Color element MUST NOT exist.

xm:f: An f element (section 2.4.3) that specifies the date range for the sparkline group. The syntax, as specified in section 2.2.2, for this f element is the following:

1295sparklinegroup-formula = single-sheet-area / [single-sheet-prefix / book-prefix] name

Additionally, if a single-sheet-area is specified, that single-sheet-area MUST contain cells from either a single row or a single column.

sparklines: A CT_Sparklines element (section 2.6.8) that specifies properties for individual sparklines.

Attributes:

manualMax: A double ([XMLSCHEMA2] section 3.2.5) attribute that specifies the maximum for the vertical axis that is shared across all sparklines in this sparkline group. This attribute MUST NOT exist if maxAxisType does not equal "custom".

manualMin: A double attribute that specifies the minimum for the vertical axis that is shared across all sparklines in this sparkline group. This attribute MUST NOT exist if minAxisType does not equal "custom".

lineWeight: A double attribute that specifies the line weight for each sparkline in the sparkline group, where the line weight is measured in points. MUST be greater than or equal to zero, and MUST be less than or equal to 1584.

type: An ST_SparklineType attribute (section 2.7.5) that specifies the type of the sparkline group.

dateAxis: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether this sparkline group uses a date axis.

Value of dateAxis	Meaning
"false"	No date axis is specified for this sparkline group.
"true"	A date axis is specified for this sparkline group.

displayEmptyCellsAs: An ST_DispBlanksAs attribute (section 2.7.3) that specifies how empty cells are plotted.

markers: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether data markers are displayed for each sparkline in this sparkline group.

Value	Meaning
"true"	Data markers are displayed for each sparkline in this sparkline group.
"false"	No data marker is displayed for sparkline in this sparkline group.

high: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the data points with the highest value are formatted differently for each sparkline in this sparkline group.

Value	Meaning
"true"	Data points (2) with the highest value are formatted differently for each sparkline in this sparkline group.
"false"	No data point with the highest value is formatted for sparkline in this sparkline group.

low: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the data points with the lowest value are formatted differently for each sparkline in this sparkline group.

Value	Meaning
"true"	Data points with the lowest value are formatted differently for each sparkline in this sparkline group.
"false"	No data point with the lowest value is formatted for sparkline in this sparkline group.

first: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the first data point is formatted differently for each sparkline in this sparkline group.

Value	Meaning
"true"	The first data point is formatted differently for each sparkline in this sparkline group.
"false"	The first data point is not formatted for sparkline in this sparkline group.

last: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the last data point is formatted differently for each sparkline in this sparkline group.

Value	Meaning
"true"	The last data point is formatted differently for each sparkline in this sparkline group.
"false"	The last data point is not formatted for sparkline in this sparkline group.

negative: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the negative data points are formatted differently for each sparkline in this sparkline group.

Value	Meaning
"true"	The negative data point is formatted differently for each sparkline in this sparkline group.
"false"	The negative data point is not formatted for sparkline in this sparkline group.

displayXAxis: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the horizontal axis is displayed for each sparkline in this sparkline group.

Value	Meaning
"true"	The horizontal axis is displayed for each sparkline in this sparkline group.
"false"	No horizontal axis is displayed for sparkline in this sparkline group.

displayHidden: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether data in hidden cells are plotted for the sparklines in this sparkline group.

Value	Meaning
"true"	Data in hidden cells are plotted for the sparklines in this sparkline group.
"false"	Data in hidden cells are not plotted for the sparklines in this sparkline group.

minAxisType: An ST_SparklineAxisMinMax attribute (section 2.7.4) that specifies how the vertical axis minimums for the sparklines in this sparkline group are calculated.

maxAxisType: An ST_SparklineAxisMinMax attribute that specifies how the vertical axis maximums for the sparklines in this sparkline group are calculated.

rightToLeft: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether each sparkline in the sparkline group is displayed in a right-to-left manner.

Value	Meaning
"true"	Each sparkline in the sparkline group is displayed in a right-to-left manner.
"false"	Not all sparklines in the sparkline group is displayed in a right-to-left manner.

xr2:uid: An ST_Guid ([ISO/IEC29500-1:2012] section 22.9.2.4) attribute that specifies the unique id of the sparkline group. If any instance of this type specifies this attribute, then all instances MUST specify it, and the values must be distinct.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

1296

1297

1298

1299

1300

1301

1302

1303

1304

1305

1306

1307

1308

1309

1310

1311

1312

1313

1314

1315

1316

1317

1318

1319

1320

1321

1322

1323

1324

1325

1326

1327

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).