21.2.3.46 ST_Style

21 DrawingML - Components Reference Material

21.2.3.46 ST_Style

This simple type specifies that its contents 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.

Line

Fill

Effect

Chart Element

Themed Line

Color

Themed Fill

Color

Themed Effect

Color

Axis

Subtle

Table 2

Axis Title
Chart Area
Chart Title
Data Labels
Data Table
Down Bars
Fills for Data Points (2-D)
Fills for Data Points (3-D)
Floor
Legend
Lines for Data Points

Fill

Effect

Line

Table 2

Fill

Subtle

Table 3

Effect

No Effect

Line

Fill

Effect

Line

Subtle

Table 2

Table 4

Subtle

Table 5

Subtle

Table 5

Table 2

No Line

Subtle

Table 5

Fill

Effect

Fill

Effect

Table 4

dk1

Table 5

dk1

Table 5

dk1

Table 3

No Effect

Fill

No Effect

N/A

No Effect

Line

Fill

Major Gridlines

Subtle

Table 2

N/A

Markers for Data Points

Subtle

Table 5

Minor Gridlines

Subtle

Table 2

N/A

Other Lines

Subtle

Table 2

N/A

Plot Area (2-D charts)

No Line

Subtle

Plot Area (3-D

charts)

Trendline Labels
Up Bars

Effect

No Effect

Table 5

dk1

No Effect

Table 3

No Effect

Line

Fill

Effect

Line

Table 4

Fill

Table 4

Effect

Table 4

dk1

Walls No Line Table 3 No Effect 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

Style

1-32

line formatting for several chart elements

by style.

Axis & Major Gridlines

Minor Gridlines

Chart Area, Data Table, & Floor

Other Lines

Floor & Chart Area

Color

Themed Line

tx1

50% tint of tx1

75% tint of tx1

tx1

Subtle

33-34

dk1

50% tint of tx1

75% tint of dk1

dk1

Subtle

35-40

dk1

50% tint of tx1

75% tint of dk1

25% shade of dk1

Subtle

41-48

dk1

90% tint of tx1

lt1

No Line

Table 3: Default fill formatting per chart style

This table lists

style.

fill formatting for several chart elements by

Style

Chart Area

Floor, Walls & Plot Area (2-D)

Floor & Walls

Color

Themed Fill

1-32

bg1

33-34

lt1

20% tint of dk1

35-40

lt1

accent1-6

41-48

dk1

95% tint of dk1

Fill

Subtle

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.

Up Bars

Down Bars

Themed

Up & Down Bars

Style

Fill Color

Fill

Effect

Line

Line Color

25% tint of dk1

85% tint of dk1

Subtle

None

Subtle

tx1

5% tint of dk1

95% tint of dk1

Subtle

None

Subtle

tx1

25% tint of accent1-6

25% shade of accent1-6

Subtle

None

Subtle

tx1

25% tint of dk1

85% tint of dk1

Subtle

tx1

5% tint of dk1

95% tint of dk1

Subtle

tx1

11-16

25% tint of accent1-6

25% shade of accent1-6

Subtle

tx1

25% tint of dk1

85% tint of dk1

Intense

Moderate

No ne

None

5% tint of dk1

95% tint of dk1

Intense

Moderate

None

19-24

25% tint of accent1-6

25% shade of accent1-6

Intense

Moderate

None

25% tint of dk1

85% tint of dk1

Intense

None

5% tint of dk1

95% tint of dk1

Intense

None

Up Bars

Down Bars

27-32

25% tint of accent1-6

25% shade of accent1-6

Intense

lt1

85% tint of dk1

Subtle

None

lt1

95% tint of dk1

Subtle

None

35-40

lt1

25% shade of accent1-6

Subtle

None

25% tint of dk1

85% tint of dk1

Intense

lt1

dk1

Intense

43-48

25% tint of accent1-6

25% shade of accent1-6

Intense

Table 5: Default data point formatting per chart style

Up & Down Bars

None

Subtle

dk1

Subtle

dk1

Subtle

25% shade of accent1-6

None

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. end note]

[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. end note]

Fills for Data Points (2-D)

↓

Fills for Data Points (3-D)

↓

Lines for Data Points

↓

Markers for Data Points

↓

Effect

Fill

Style

Themed Effect

Themed Fill

Pattern

No Effect

Subtle

No Effect

Subtle

No Effect

Subtle

accent1 fade

No Effect

Subtle

accent2 fade

No Effect

Subtle

accent3 fade

No Effect

Subtle

accent4 fade

No Effect

Subtle

accent5 fade

No Effect

Subtle

accent6 fade

Subtle

accent1 fade

Subtle

accent2 fade

Subtle

accent3 fade

Subtle

accent4 fade

Subtle

accent5 fade

Subtle

accent6

Fill

Themed Fill

Subtle

Line

Themed Line

No Line

Subtle

Line

Color or Pattern

lt1

Line

Width

Pattern

accent1 fade

accent2 fade

accent3 fade

accent4 fade

accent5 fade

accent6 fade

accent1 fade

accent2 fade

accent3 fade

accent4 fade

accent5 fade

accent6

Moderate

Intense

Moderate

Intense

Moderate

Intense

Moderate

Intense

Moderate

Intense

Moderate

Intense

Moderate

Intense

Moderate

Intense

No Effect

Subtle

fade

accent1 fade

accent2 fade

accent3 fade

accent4 fade

accent5 fade

accent6 fade

accent1 fade

accent2 fade

accent3 fade

accent4 fade

accent5 fade

accent6 fade

Subtle

Intense

Subtle

Intense

Subtle

No Line

Subtle

fade

accent1 fade

accent2 fade

accent3 fade

accent4 fade

accent5 fade

accent6 fade

accent1 fade

accent2 fade

accent3 fade

accent4 fade

accent5 fade

accent6 fade

50% shade

No Effect

Subtle

No Effect

Subtle

accent1 fade

No Effect

Subtle

accent2 fade

No Effect

Subtle

accent3 fade

No Effect

Subtle

accent4 fade

No Effect

Subtle

accent5 fade

No Effect

Subtle

accent6 fade

Intense

accent1 fade

Intense

accent2 fade

Intense

accent3 fade

Intense

accent4 fade

Intense

accent5 fade

Intense

accent6 fade

Subtle

Intense

Subtle

No Line

of dk1

Pattern 3

50% shade of accent1

50% shade of accent2

50% shade of accent3

50% shade of accent4

50% shade of accent5

50% shade of accent6

accent1 fade

accent2 fade

accent3 fade

accent4 fade

accent5 fade

accent6 fade

accent1 fade

accent2 fade

accent3 fade

accent4 fade

accent5 fade

accent6 fade

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.

Pattern

Data Point 1

Data Point 2

Data Point 3

Data Point 4

Data Point 5

Data Point 6

88.5% tint of dk1

55% tint of dk1

78% tint of dk1

92.5% tint of dk1

70% tint of dk1

30% tint of dk1

accent1

accent2

accent3

accent4

Accent5

accent6

50% shade of accent1

50% shade of accent2

50% shade of accent3

50% shade of accent4

50% shade of accent5

50% shade of accent6

5% tint of dk1

55% tint of dk1

78% tint of dk1

15% tint of dk1

70% tint of dk1

30% tint of dk1

Above are two charts showing the same monochromatic pattern, just with a different number of series. [Note: These charts just have tint and shade adjusted for each series beginning and ending at the same values. end note]

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 W3C 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.

[Note: The W3C XML Schema definition of this simple type’s content model (ST_Style) is located in A.5.1. end note]

Last updated on March 14, 2025

21.2.3.45 ST_SplitType 21.2.3.47 ST_TickLblPos