D. Style file format

  2. Support
  3. User manual
  4. Style file format

The technical structure of a think-cell style file is described in the following section. It provides an overview of the file, its content and its hiearchy, and brief explanations for logical subsections, showing what style settings can be defined for think-cell elements. It is followed by a description on how to work with style files in general and their specific structure in File Structure. The detailed explanation of each element is given below, starting with Defining colors, line styles and markers.

D.1
Hierarchy of XML elements
D.2
File Structure
D.3
Defining colors, line styles and markers
D.4
Using colors, lines and markers in schemes
D.5
Customizing charts
D.6
Customizing text properties
D.7
Customizing labels
D.8
Customizing lines
D.9
Customizing Harvey ball and checkbox

D.1 Hierarchy of XML elements

The following elements are used to define colors, lines, and markers respectively. They are made available in the floating toolbar of applicable think-cell elements in PowerPoint and can be referenced in further definitions in the style file. They are described in Defining colors, line styles and markers.

  • fillLst
    • noFill
    • solidFill
      • schemeClr
        • lumMod
        • lumOff
      • srgbClr
      • sdrgbClr
      • scrgbClr
      • prstClr
    • patFill
      • fgClr + bgClr
  • lnLst
    • ln
      • prstDash
  • markerLst
    • noMarker
    • marker
      • symbol
  • solidfillRefBackground

The following elements define the default line and grid line style used throughout think-cell. They are described in Customizing lines.

  • lnfillDefault
    • solidfillRef
    • lnRef
  • lnfillGridline
    • solidfillRef
    • lnRef

The following elements define the lists of styles for shapes, fill, line, and marker schemes respectively. They are made available in the floating toolbar for applicable think-cell elements and can be referenced in further definitions in the style file. They are described in Using colors, lines and markers in schemes.

  • shapestyleLst
    • shapestyle
      • fillref
      • lnfill
  • fillschemeLst
    • fillscheme
      • lnfillSegment
        • solidfillRef
        • lnRef
      • lnfillSegmentMekko
        • solidfillRef
        • lnRef
      • fillRef
      • seriesCountSpecific
        • fillRef
  • lnfillmarkerSchemeLst
    • lnfillmarkerScheme
      • lnfillmarker
        • solidfillRef
        • lnRef
        • markerRef
      • seriesCountSpecific
        • lnfillmarker
  • fillmarkerSchemeLst
    • fillmarkerscheme
      • fillmarker
        • solidfillRef
        • markerRef
      • seriesCountSpecific
        • fillmarker

The following elements can be used to define a default fill scheme for all charts and specific charts. They are described in Customizing charts.

  • fillSchemeRefDefault
  • fillSchemeRefDefaultStacked
  • fillSchemeRefDefaultWaterfall
  • fillSchemeRefDefaultClustered
  • fillSchemeRefDefaultMekko
  • fillSchemeRefDefaultArea
  • fillSchemeRefDefaultPie
  • fillSchemeRefDefaultBubble
  • lnfillmarkerSchemeRefDefault
  • lnfillmarkerSchemeRefDefaultCombination
  • fillmarkerSchemeRefDefault

The following elements set the default text style for think-cell text fields. They are described in Customizing text properties.

  • defPPr
    • defRPr

The following elements define the style properties of different labels. They are described in Customizing labels.

  • label
    • lnfillLeaderLine
      • lnRef
    • shapestyleRefBubble
    • sumLabelPosition

The following elements define the properties of lines for axes and legends. They are described in Customizing lines.

  • chart
    • lnfillAxis
      • solidfillRef
      • lnRef
    • lnfillAxisCategory
      • solidfillRef
      • lnRef
  • legend
    • lnfill
      • solidFillRef
      • lnRef

The following elements define the style and behavior of Harvey balls and checkboxes. They are described in Customizing Harvey ball and checkbox.

  • harveyball
    • fillRefCompleted + fillRefBackground
    • lnfill
  • checkbox
    • fillRef
    • lnfill
    • choices
      • glyph
        • solidfillRef
        • font
        • t
      • pic
        • Relationship

D.2 File Structure

think-cell style files are XML files conforming to the schema

https://schemas.think-cell.com/30711/tcstyle.xsd

Note: Only style files that successfully validate against the XML schema are supported. It is possible that a style file that is technically not fully valid, e.g., by omitting some elements, still loads in a given version of think-cell, but that may not hold true in future releases.

D.2.1 style

The style element is the root element of a style file. The mandatory attribute name sets the name that is shown in the image  More menu as the currently active style. The attributes xmlns, xmlns:xsi and xsi:schemaLocation should not be changed from the example when creating a new style file. An optional attribute basedOn may reference a legacy base style. The corresponding .tcbasestyle file must be present in the installation directory to load a style file with the attribute basedOn.

Style files created for earlier versions of think-cell continue to work unchanged. If you want to use additional elements that are only supported in the current release, you need to update the build number in the attributes xmlns and xsi:schemaLocation to the one shown in the following example.

Example: 

<style name="Example style name" 
xmlns="https://schemas.think-cell.com/30711/tcstyle" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation= 
  "https://schemas.think-cell.com/30711/tcstyle 
   https://schemas.think-cell.com/30711/tcstyle.xsd"> 
... 
</style>

At this time you may also need to make changes to other elements to make sure the style file adheres to the format described here.

D.2.2 noStyle

If a style file only contains this element, loading it will remove the current style information from the slide master.

Example: 

<noStyle 
xmlns="https://schemas.think-cell.com/30711/tcstyle" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation= 
  "https://schemas.think-cell.com/30711/tcstyle 
   https://schemas.think-cell.com/30711/tcstyle.xsd"/>

D.3 Defining colors, line styles and markers

D.3.1 Colors

schemeClr

A fill based on one of PowerPoint’s built-in scheme colors. The attribute val specifies the color using the values bg1, tx1, accent1, accent2, accent3, accent4, accent5, accent6, dk1, lt1, dk2, lt2, hlink, folHlink, bg2 or tx2. When using schemeClr, the name attribute of the parent solidFill element will typically be set to the same value as the val attribute. Then, think-cell will use the name that appears in PowerPoint’s scheme colors dialog, depending on the version of PowerPoint and the user interface language.

Example: 

<solidFill name="accent2"> 
  <schemeClr val="accent2"/> 
</solidFill>

lumMod

Percentage by which to modulate the luminance of a color. It is typically nested inside a schemeClr to modify it, but can also modify the other color types described below.

Example: 

<solidFill name="Accent 1, Darker 20%"> 
  <schemeClr val="accent1"> 
    <lumMod val="80%"/> 
  </schemeClr> 
</solidFill>

lumOff

Percentage by which to shift the luminance of a color, but with its hue and saturation unchanged. It is typically nested inside a schemeClr to modify it, but can also modify the other color types described below.

Example: 

<solidFill name="Accent 1, Lighter 20%"> 
  <schemeClr val="accent1"> 
    <lumMod val="80%"/> 
    <lumOff val="20%"/> 
  </schemeClr> 
</solidFill>

srgbClr

A fill based on a color defined using values for the red, green and blue components. The attribute val contains six hexadecimal characters for the three components.

Example: 

<srgbClr val="FF00FF"/>

sdrgbClr

A fill based on a color defined using values for the red, green and blue components. The attributes r, g and b each contain numbers between 0 and 255.

Example: 

<sdrgbClr r="0" g="255" b="0"/>

scrgbClr

A fill based on a color defined using values for the red, green and blue components. The attributes r, g and b each contain percentage values between 0% and 100%. The percentage values may use integers or decimal numbers with 2 decimal places and a dot as the separator.

Example: 

<scrgbClr r="0%" g="100%" b="66.66%"/>

prstClr

A fill based on the preset colors defined in the Office Open XML standard. The attribute val specifies the color name and must be one of the names from AliceBlue to YellowGreen enumerated in 

msdn.microsoft.com/en-us/library/ 
documentformat.openxml.drawing.presetcolorvalues.aspx

or in subsection 20.1.10.47 of the Office Open XML standard.

Example: 

<prstClr val="white"/>

D.3.2 Fills

solidFill

A fill based on a single color. The color can be specified using either one of the child elements schemeClr, srgbClr, or prstClr. The attribute name contains the name shown in the color list.

Example: 

<solidFill name="White"> 
  <srgbClr val="FFFFFF"/> 
</solidFill>

pattFill

A patterned fill based on a pattern and two colors. The colors can be specified using the child elements fgClr and bgClr describing the foreground and background color of the pattern respectively. The pattern itself can be specified declaring the attribute prst and referencing a pattern described in Office Open XML. The attribute name contains the name shown in the color list.

Example: 

<pattFill name="Outlined diamond" prst="openDmnd"> 
  <fgClr> 
    <prstClr val="black"/> 
  </fgClr> 
  <bgClr> 
    <prstClr val="white"/> 
  </bgClr> 
</pattFill>

fgClr

Describes the foreground color of a pattern fill. The color can be specified using either one of the child elements schemeClr, srgbClr, or prstClr.

Example: 

<fgClr> 
  <prstClr val="black"/> 
</fgClr>

bgClr

Describes the background color of a pattern fill. See fgClr.

D.3.3 Choices in the fill color control

fillLst

A list of fills, described by multiple instances of the elements noFill, solidFill, or pattFill. The fills defined in this list are shown in the color control of the floating toolbar (see Color and fill).

Example: 

<fillLst> 
  <solidFill ... 
</fillLst>

noFill

When the user chooses this special fill from the color control, e.g., for a segment, the segment has no fill color. The attribute name contains the default name used in the color control, which cannot be changed. 

<noFill name="No Fill"/>

separator

A horizontal line in lists shown in the floating toolbar. It can be used inside fillLst, fillSchemeList and lnfillmarkerSchemeLst elements.

Example: 

<separator/>

D.3.4 Lines

ln

A line with certain weight based on a line type. The attribute w describes the weight of the line. The value for this attribute is noted in EMU (English Metric Unit). 12700 EMU are equivalent to a line weight of 1 pt. The attribute name contains a name used to reference this line style. The line type can be specified using the child element prstDash.

Example: 

<ln name="Solid 0.25 pt" w="3175"> 
  <prstDash val="solid"/> 
</ln>

prstDash

A line style based on the pre-set line styles defined in the Office Open XML standard. The attribute val specifies the line type using the values solid, dash, lgDash, dashDot, lgDashDot, lgDashDotDot, sysDot, sysDashDotDot, which correspond to the Office Open XML standard: 

msdn.microsoft.com/en-us/library/ 
documentformat.openxml.drawing.presetlinedashvalues.aspx

Example: 

<prstDash val="solid"/>

D.3.5 Choices in the line style control

lnLst

A list of lines described by one optional instance of the element noLine and at least one instances of the element ln. The lines defined in this list are shown in the line style control of the floating toolbar (see Line style). Furthermore, any line style referenced using lnRef for use in line charts (see Line chart), Universal connectors (see Universal connectors) and waterfall connectors (see Waterfall chart), outlines etc. must be defined here.

Example: 

<lnLst> 
  <ln ... 
</lnLst>

To describe each entry in the list, the w attribute of the ln element is converted to points, e.g., 3175 EMU to 1/4pt, and displayed together with a visual representation of the dash type.

D.3.6 Markers

marker

A marker with a certain shape. The attribute name contains the name shown in the marker style list. The marker shape can be specified using the child element symbol.

Example: 

<marker name="Marker Circle"> 
  <symbol val="circle"/> 
</marker>

symbol

A marker shape based on the preset marker shapes defined in the Office Open XML standard. The attribute val specifies the marker type using the values circle, triangle, diamond, square, star, x, hollowCircle, hollowTriangle, hollowDiamond, hollowSquare, dash, dot, plus. 

msdn.microsoft.com/en-us/library/ 
documentformat.openxml.drawing.charts.markerstylevalues.aspx

Example: 

<symbol val="circle"/>

D.3.7 Choices in the marker control

markerLst

A list of markers described by one optional instance of the element noMarker and at least one instance of the element marker. The markers defined in this list are shown in the marker control of the floating toolbar (see Marker shape).

Example: 

<markerLst> 
  <marker ... 
</markerLst>

noMarker

When the user chooses this special marker style from the marker style control, the marker has no fill color. The attribute name contains the default name used in the marker style control, which cannot be changed. 

<noMarker name="No Marker"/>

D.3.8 Chart background color

solidfillRefBackground

The actual background color for think-cell charts. This is only necessary to specify if the charts are placed on a colored rectangle rather than directly on the slide background. This color is used for shapes that are meant to seamlessly blend in with the background, e.g., boxed labels and value axis breaks. 

<solidfillRefBackground name="Yellow"/>

Using solidfillRefBackground is a last resort. First you should try to fix your template with regard to slide background and theme colors. Only if this still does not yield the desired result, use solidfillRefBackground to explicitly define the chart background color. It is typically used together with defRPr for text colors (see Customizing text properties).

D.4 Using colors, lines and markers in schemes

D.4.1 Choices in the label scheme control

shapestyleLst

A list of shape styles that can be referenced for defining default behavior of think-cell shapes. Individual shape styles are defined using the shapestyle child element. Currently, only the bubble of difference arrows may be using such a reference (see Customizing labels), thus the list can only hold one single item.

Example: 

<shapestyleLst> 
  <shapestyle ... 
</shapestyleLst>

shapestyle

A shape style. Must contain one fillref child element to define the background color of the shape, may contain additionally one lnfill child element and its subsequent child elements to describe the outline of the shape.

Example: 

<shapestyle name="Bubble"> 
  <fillRef name="bg1"/> 
  <lnfill> 
    <lnRef name="Solid 0.75 pt" /> 
    <solidfillRef name="Dark Gray" /> 
  </lnfill> 
</shapestyle>

D.4.2 Choices in the color scheme control

fillSchemeLst

A list of think-cell color schemes that will be used in the color scheme control of the floating toolbar (see Color scheme). Individual fill schemes are defined using the fillScheme child element.

Example: 

<fillSchemeLst> 
  <fillScheme name="Company fill scheme"> 
  ... 
</fillSchemeLst>

fillScheme

A color scheme consisting of a sequence of fills. It is defined by referencing fills using the child element fillRef. The attribute name contains the name that is used in the color scheme control. The attribute fillRefOtherSeries specifies which color to use for the Other Series (see Other Series).

If the optional boolean attribute reverse is set to 1, the list of fills will be applied in reverse order, starting with the first fill for the bottom-most series, the second fill for the series above, and so on.

The optional boolean attribute repeatLast controls what happens after each fill has been used once, i.e., once the number of segments is larger than the number of fill colors. Per default, or when it is explicitly set to 0, additional segments repeat the fill colors, starting with the first, then the second, and so forth. If repeatLast is set to 1, the last fill color specified in the color scheme will be used for all subsequent segments.

Example: 

<fillScheme name="Company fill scheme" 
            fillRefOtherSeries="Orange" 
            reverse="0" 
            repeatLast="0"> 
  <fillRef name="White"/> 
  ... 
</fillScheme>

Sometimes a color scheme works well for most charts, but less well for charts with very few series. For example, you may use a color scheme with one primary color, several shades of that color and then another primary color with several shades of it. If a chart only has two segments, you may prefer that both primary colors are used, instead of one primary color and one shade of it. You can solve this problem with the seriesCountSpecific child element.

seriesCountSpecific

A sequence of fills to be used as the color scheme if a chart has a specific number of series. The attribute seriesCount specifies for which count of series this sequence is used. You can use a range (seriesCount="1-3") or a number (seriesCount="2").

The chart automatically switches between the default fill sequence in fillScheme and any specific fill sequences in seriesCountSpecific whenever the number of series in the chart changes.

Example: 

<fillScheme name="Company fill scheme" 
            fillRefOtherSeries="Orange"> 
  <fillRef name="Red"/> 
  <fillRef name="Light Red"/> 
  <fillRef name="Lighter Red"/> 
  <fillRef name="Blue"/> 
  <fillRef name="Light Blue"/> 
  <fillRef name="Lighter Blue"/> 
  <seriesCountSpecific seriesCount="1-2"> 
    <fillRef name="Red"/> 
    <fillRef name="Blue"/> 
  </seriesCountSpecific> 
</fillScheme>

You can use multiple seriesCountSpecific elements inside one fillScheme if the ranges in the seriesCount attributes do not overlap. If none of the seriesCount attributes for any specific lists match the current series count, the sequence of fills from the parent element is used.

seriesCountSpecific supports the attributes reverse and repeatLast as for fillScheme.

fillRef

A reference to a fill defined in the fillLst element. The attribute name must match the value of the same attribute in the fill definition.

Example: 

<fillRef name="White"/>

D.4.3 Choices in the line scheme control

lnfillmarkerSchemeLst

A list of think-cell line schemes that will be used in the line scheme control of the floating toolbar. Individual line schemes are defined using the lnfillmarkerScheme child element.

Example: 

<lnfillmarkerSchemeLst> 
  <lnfillmarkerScheme name="Company line scheme"> 
  ... 
</lnfillmarkerSchemeLst>

lnfillmarkerScheme

A line scheme consisting of a sequence of combined line styles. It is defined by describing line styles using the child element lnfillmarker, which references a line, a color, and a marker. The attribute name contains the name that is used in the line scheme control. If necessary, seriesCountSpecific can be used with a different sequence of lnfillmarker for charts with only very few series (see seriesCountSpecific).

Example: 

<lnfillmarkerScheme name="Company line scheme"> 
  <lnfillmarker> 
    <lnRef name="Solid 18"/> 
    <solidfillRef name="accent1"/> 
    <markerRef name="No Marker"/> 
  </lnfillmarker> 
  ... 
</lnfillmarkerScheme>

lnfillmarker

A combined line style for line charts (see Line chart) described by the child elements lnRef, solidfillRef, and optionally markerRef referencing a line, a fill color, and a marker respectively.

Example: 

<lnfillmarker> 
  <lnRef name="Solid 18"/> 
  <solidfillRef name="accent1"/> 
  <markerRef name="No Marker"/> 
</lnfillmarker>

lnRef

A reference to a line defined in the lnLst element. The attribute name must match the value of the same attribute in the line definition. lnRef as a child element of lnfillmarker may not reference the noLine line type.

Example: 

<lnRef name="Solid 18"/>

solidfillRef

A reference to a fill color defined in the fillLst element. The attribute name must match the value of the same attribute in the fill definition.

Example: 

<solidfillRef name="accent1"/>

markerRef

A reference to a marker defined in the markerLst element. The attribute name must match the value of the same attribute in the marker definition.

Example: 

<markerRef name="No Marker"/>

D.4.4 Choices in the marker scheme control

fillmarkerSchemeLst

A list of think-cell marker schemes that will be used in the marker scheme control of the floating toolbar (see Marker scheme). Individual marker schemes are defined using the fillmarkerScheme child element.

Example: 

<fillmarkerSchemeLst> 
  <fillmarkerScheme name="Company marker scheme"> 
  ... 
</fillmarkerSchemeLst>

fillmarkerScheme

A marker scheme consisting of a sequence of markers. It is defined by referencing markers using the child element fillmarker. The attribute name contains the name that is used in the color scheme control. If necessary, seriesCountSpecific can be used with a different sequence of fillmarker for charts with only very few series (see seriesCountSpecific).

Example: 

<fillmarkerScheme name="Company marker scheme"> 
  <fillmarker> 
  ... 
</fillScheme>

fillmarker

A combined marker style consisting of a marker reference using the child element markerRef and an optional fill color reference using the child element solidfillRef. If markerRef references noMarker, solidfillRef will be ignored.

Example: 

<fillmarker> 
  <markerRef name="Square"/> 
  <solidfillRef name="Orange"/> 
</fillmarker>

D.5 Customizing charts

D.5.1 fillSchemeRefDefault

A reference to a fill scheme that is used as the default color scheme for all chart types. If one or several of the elements 

fillSchemeRefDefaultStacked, 
fillSchemeRefDefaultWaterfall, 
fillSchemeRefDefaultClustered, 
fillSchemeRefDefaultMekko, 
fillSchemeRefDefaultArea, 
fillSchemeRefDefaultPie, 
fillSchemeRefDefaultBubble

are used, they override the default scheme set here for the corresponding specific chart type. If all of these elements are used, the fillSchemeRefDefault may be omitted.

Example: 

<fillSchemeRefDefault name="Company scheme"/>

D.5.2 fillSchemeRefDefaultStacked

The default color scheme for stacked charts.

Example: 

<fillSchemeRefDefaultStacked name="Stacked scheme"/>

D.5.3 fillSchemeRefDefaultWaterfall

The default color scheme for waterfall charts.

Example: 

<fillSchemeRefDefaultWaterfall 
  name="Waterfall scheme"/>

D.5.4 fillSchemeRefDefaultClustered

The default color scheme for clustered charts.

Example: 

<fillSchemeRefDefaultClustered 
  name="Clustered scheme"/>

D.5.5 fillSchemeRefDefaultMekko

The default color scheme for mekko charts.

Example: 

<fillSchemeRefDefaultMekko name="Mekko scheme"/>

D.5.6 fillSchemeRefDefaultArea

The default color scheme for area charts.

Example: 

<fillSchemeRefDefaultArea name="Area scheme"/>

D.5.7 fillSchemeRefDefaultPie

The default color scheme for pie charts.

Example: 

<fillSchemeRefDefaultPie name="Pie scheme"/>

D.5.8 fillSchemeRefDefaultBubble

The default color scheme for bubble charts.

Example: 

<fillSchemeRefDefaultBubble name="Bubble scheme"/>

D.5.9 lnfillmarkerSchemeRefDefault

The default color scheme for line charts.

Example: 

<lnfillmarkerSchemeRefDefault name="Line scheme"/>

D.5.10 lnfillmarkerSchemeRefDefaultCombination

The default color scheme for combination charts.

Example: 

<lnfillmarkerSchemeRefDefaultCombination 
  name="Combination scheme"/>

D.5.11 fillmarkerSchemeRefDefault

The default marker scheme for scatter charts.

Example: 

<fillmarkerSchemeRefDefault name="Shapes"/>

D.6 Customizing text properties

defPPr

The default paragraph properties for text in labels and text boxes. Properties for new labels and textboxes are taken from one of the text style levels of the body text placeholder. The appropriate text style level is chosen heuristically, which works fine in most cases. This behavior is selected by not using the defPPr element. If an inappropriate text style level is chosen, you can use the attribute lvl with numbers from 0 to 8 to explicitly specify the text style level. The numbering starts with 0, which corresponds to the first text style level. Therefore, 1 refers to the second level and so forth. From the paragraph properties of the specified text style level think-cell uses the font color for text in labels and text boxes.

Example: 

<defPPr lvl="3"/>

defRPr

The default properties for a run of text in labels and text boxes. It is possible to override the primary and alternative font color from the values derived from the PowerPoint color scheme. You can specify the primary font color using solidfillRef and the alternative font color using solidfillRefAlt. For each label the best color to maximize contrast with the label background is chosen automatically.

Example: 

<defPPr lvl="2">
	<defRPr>
		<solidfillRef name="Deep Red"/>
		<solidfillRefAlt name="Yellow"/>
	</defRPr>
</defPPr>

Using defRPr is a last resort. It is always preferable to change your template with regard to slide background and theme colors. Next you should set the correct text style level formatting in the master slide body text placeholder. Only if this is not possible or does not yield the desired result, use the lvl attribute of defPPr described above and if that still does not yield the desired result, use defRPr to explicitly define text colors.

Some of the circumstances that require using defRPr also require explicitly specifying the actual chart background color using solidfillRefBackground (see Chart background color).

D.7 Customizing labels

The element label contains elements customizing properties of labels. The following elements are child elements of label. Note that shapestyleRefBubble is a mandatory child element, whereas the other elements are optional.

lnfillLeaderLine

The line style used for the line between a segment label and the segment when the label is not placed inside the segment. If solidfillRef is not specified, instead of using the color from lnfillDefault, think-cell uses the color matching the automatically set label font color.

Example: 

<lnfillLeaderLine> 
  <lnRef name="Solid 0.5 pt"/> 
</lnfillLeaderLine>

shapestyleRefBubble

A reference to a shape defined in the shapestyleLst. The attribute name must match the value of the same attribute in the shape style definition. It defines the style of labels used in difference arrow.

Example: 

<shapestyleRefBubble name="Bubble"/>

sumLabelPosition

The position of total labels. The attribute val can have the following values (the positions are described for upright column charts and change correspondingly for rotated or flipped charts):

accordingToSign
Places total labels above the column for positive total values and below the column for negative total values. This is the default if the element is not present.
awayFromBaseline
Places total labels away from the baseline, i.e., the label is never placed between the column and the baseline.

The setting applies to floating columns in waterfall charts. Otherwise, both methods result in identical labels positions and sumLabelPosition is not relevant.

Example: 

<label> 
  <sumLabelPosition val="accordingToSign" /> 
</label>

D.8 Customizing lines

D.8.1 lnfillDefault

The default line type used throughout think-cell. Using a lnRef element to reference one of the lines in the lnLst element the dash type and weight is defined. One of the solid colors in the fillLst element is referenced using solidfillRef to set the color.

Example: 

<lnfillDefault> 
  <lnRef name="Solid 0.75 pt" /> 
  <solidfillRef name="tx1" /> 
</lnfillDefault>

If either the lnRef or the solidfillRef element is missing from one of the line style definitions below, the respective value from lnfillDefault is used.

lnfillGridline

The grid line style. It follows the same schema and rules as lnfillDefault above.

D.8.2 Segment outlines

The outlines of segments are defined on the fill scheme level, i.e., every scheme from the color scheme control can also set a line style for segment outlines. The following elements are therefore child elements of a fillScheme element.

lnfillSegment

The default outline style for this color scheme.

lnfillSegmentMekko

The outline style for Mekko charts using the parent element’s color scheme. If omitted, the line style from lnfillSegment is used.

Example

Here, noLine is used for segment outlines. However, as this is often not appropriate for Mekko charts, these use a thin solid line with the standard foreground color. 

<fillScheme name="PowerPoint Theme" ...> 
  <lnfillSegment> 
    <noLine/> 
  </lnfillSegment> 
  <lnfillSegmentMekko> 
    <lnRef name="Solid 0.25 pt" /> 
    <solidfillRef name="tx1" /> 
  </lnfillSegmentMekko> 
  <fillRef name="accent1"/> 
  ... 
</fillScheme>

D.8.3 Lines in charts

The element chart contains elements customizing lines in charts. The following elements are child elements of the element chart.

lnfillAxis

The default chart axis line style.

lnfillAxisCategory

The category axis line style. Can be used to set a thicker baseline weight. If omitted, lnfillAxis is used.

lnfillArrow

The default line style used for difference arrows.

lnfillArrowCAGR

The line style used for CAGR arrows.

lnfillArrowCategoryDifference

The line style used for total difference arrows.

lnfillArrowSegmentDifference

The line style used for level difference arrows.

lnfillExtensionLine

The line style used for extension lines of level difference arrows.

lnfillConnector

The line style used for connector lines.

lnfillConnectorWaterfall

The line style used for waterfall connector lines. If specified, the style overrides lnfillConnector. In addition to child elements lnRef and solidfillRef, lnfillConnectorWaterfall also supports a child element of <noLine /> to specify that waterfall connectors should not be visible, which is not possibly for lnfillConnector.

lnfillValueLine

The line style used for value lines.

lnfillTrendLine

The line style used for trendlines.

lnfillPartition

The line style used for partitions.

lnfillErrorBar

The line style used for error bars.

lnfillRidge

The line style used for the Mekko chart ridge.

D.8.4 Lines in the legend

The following element is a child element of the element legend.

lnfill

The outline of the think-cell shape. When this element is not used, the shape has no outline. If the element is used, but only specifies the line style or the color, the property left unspecified is set by lnfillDefault as usual.

Example: 

<legend> 
  <lnfill> 
    <lnRef name="Solid 0.75 pt" /> 
    <solidfillRef name="Dark Gray" /> 
  </lnfill> 
</legend>

D.9 Customizing Harvey ball and checkbox

D.9.1 harveyball

A combined style for the Harvey ball consisting of the child elements fillRefCompleted, fillRefBackground, and lnfill to describe the color of the completion state and, the background color and the outline of the Harvey ball respectively. The required attribute sz defines the default font size of the Harvey ball in one hundredth of a point.

Example: 

<harveyball sz="1400"> 
  <fillRefCompleted name="Black"/> 
  <fillRefBackground name="Light Orange"/> 
  <lnfill> 
    <lnRef name="Solid 0.5 pt"/> 
    <solidfillRef name="accent1"/> 
  </lnfill> 
</harveyball>

D.9.2 fillRefCompleted

See fillRef.

D.9.3 fillRefBackground

See fillRef.

D.9.4 checkbox

A combined style for the Checkbox consisting of the child element fillRef to describe the background color of the Checkbox, the child element lnfill to describe the Checkbox’s outline and the list of symbols, characters and pictures in the child element choices. The required attribute sz defines the default font size of the Checkbox in one hundredth of a point. The size of each glyph has to be defined separately.

Example: 

<checkbox sz="1400"> 
  <fillRef name="No Fill"/> 
  <lnfill> 
    <noLine/> 
  </lnfill> 
  <choices> 
    <glyph hotkeys="VO1" sz="1867"> 
      <solidfillRef name="Green"/> 
      <t>v</t> 
    </glyph> 
    <glyph hotkeys="X2" sz="1867"> 
      <solidfillRef name="Pink"/> 
      <font typeface="Arial Unicode MS"/> 
      <t>&#10007;</t> 
    </glyph> 
    <glyph hotkeys="Q3" sz="1867"> 
      <font typeface="Arial Unicode MS"/> 
      <t>?</t> 
    </glyph> 
    <pic hotkeys="R4"> 
      <Relationship Target="traffic_light_horizontal_red.emf"/> 
    </pic> 
    <glyph hotkeys=" 0" sz="1867"> 
      <t> </t> 
    </glyph> 
  </choices> 
</checkbox>

D.9.5 choices

A list of choices to be used in a checkbox. The list can contain any number of the elements glyph for characters and symbols and pic for pictures.

D.9.6 glyph

A glyph (character or symbol) that is used as one of the choices of a checkbox. The attribute hotkeys describes a list of hotkey characters that select the glyph. The child elements solidFillRef describes the color of the character or symbol, font its font and t the character or symbol itself. The required attribute sz defines the default font size of the character in one hundredth of a point, independent from the checkbox’s total size.

Example: 

<glyph hotkeys="qQ3" sz="1867"> 
  <solidfillRef name="Blue"/> 
  <font typeface="Arial Unicode MS"/> 
  <t>?</t> 
</glyph>

D.9.7 t

A character or symbol used in a glyph (itself used in a checkbox). The contents of this element can be a verbatim character (a), a Unicode symbol or a numeric character reference to a Unicode code point. The numeric reference can be given using decimal numbers (&#10007;) or hexadecimal numbers (&#x2717;).

D.9.8 pic

A picture that is used as one of the choices of a checkbox. The file name of an EMF file with the picture is given as the attribute Target of the child element Relationship. The attribute hotkeys describes a list of hotkey characters that select the picture.

Example: 

<pic hotkeys="R4"> 
  <Relationship Target="traffic_light_horizontal_red.emf"/> 
</pic>

To create an EMF file of any shape in PowerPoint:

  1. Right-click the shape or selection of shapes.
  2. Choose Save as Picture.
  3. Make sure to save as type Enhanced Windows Metafile (*.emf).

Of course, you can also use a suitable graphics editor to create an EMF file.

Appendix

Not yet a user?

Try for free See all features

Share

think-cell uses cookies to improve the functionality, performance and security of this site. Your consent is necessary if you want to use the full functionality of this site. More information on the use of cookies by think-cell, your consent and your privacy rights can be found in our privacy policy.