<ST_Style> (Style)

This simple type specifies that its contents will contain an integer between 1 and 48. The value determines the default formatting for all chart elements through the tables described below.

The default font is the minor font as defined by the document’s theme. The default font size for each element is the font size of the chart, except for the title which is always 120% the font size of the chart. If the chart does not have a font size set, then the default font size is 10. Axis titles and chart titles are bold by default, while all other chart elements are normal. The default font color is the same as the Axis & Major Gridlines Line Color.

The default line style, fill style, and effect style are determined by the tables below. Each of the default includes a themed line, fill, or effect (None, Subtle, Moderate, or Intense) and a color to be used when applying that line, fill, or effect. In some cases, both the themed formatting and the color vary per style, in other cases they do not. The default line width is determined by the theme, except for lines for data points it is multipled by the line width value given in the table.

Table 1: Chart element defaults

This table lists whether the default is constant or whether it depends on the ST_Style using one of the later tables.

Other Lines includes Drop Lines, Error Bars, High Low Lines, Leader Lines, Series Lines, and Trendlines.

Fills for Data Points (2-D) includes 2-D bar, filled radar, stock, bubble, pie, doughnut and area charts.

Fills for Data Points (3-D) includes all 3-D charts.

Lines for Data Points includes lines on 2-D line, scatter, bubble, and radar charts.

Markers for Data Points includes markers on 2-D line, scatter, and radar charts.

Table 2: Default line formatting per chart style

This table lists line formatting for several chart elements by style.

Table 3: Default fill formatting per chart style

This table lists fill formatting for several chart elements by style.

Table 4: Up and down bars default formatting per chart style

This table lists line, fill, and effect formatting for up and down bars by style. The color listed as accent1-6 means that the first style uses accent1, the next uses accent2, up to the sixth uses accent6.

Table 5: Default data point formatting per chart style

This table lists line, fill, and effect formatting for data points by style. Some of the formatting is a repeating pattern described in the next table (denoted by "Pattern"). Other use a fade pattern in which the first series is a certain% shade of the color listed and the last series is an certain% tint of the color listed. The intermediate colors are linearly interpolated by shade and tint to the listed color. The starting shade% and ending tint% are determined by the spreadsheet application, where shades are always darker than tints.

Note: A suggested way to implement this percentage is by using the formula: shade/tint percent = -70 + 140 * (SeriesFormattingIndex / (HighestFormattingIndexOfAllSeriesOnAllGraphs + 1)). In this case the series formatting index is the idx attribute value for the series. Negative outputs are shades, and positive outputs are tints.

Note: The arrows across the top of the table indicate which columns apply for that row: i.e., for Fills, Lines, or Markers. So, for example, only the last two columns for Lines for Data Points apply.

Table 6: Default data point formatting per data point

This table contains the formatting patterns used for each data point when there are is one series, or each series when there is just one series. The patterns in this table can repeat, see the pictures below the table for an illustration.

Above are two charts showing the same monochromatic pattern, just with a different number of series. Note that these charts just have tint and shade adjusted for each series beginning and ending at the same values.

Above is a pattern that has 6 distinct accent colors. The colors repeat every 6 data points, but the tint/shade is changed for each set.

This simple type's contents are a restriction of the XML Schema unsignedByte datatype.

This simple type also specifies the following restrictions:

• This simple type has a minimum value of greater than or equal to 1.

• This simple type has a maximum value of less than or equal to 48.

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_Style">
	<restriction base="xsd:unsignedByte">
	<minInclusive value="1"/>
	<maxInclusive value="48"/>
	</restriction>
</simpleType>