PptPointLabel

PptPointLabel

This represents the label on one data point in a series and contains the various pieces of data required to be exported/updated in Powerpoint. A value of NULL in any field means the PptSeriesLabels value will be respected.

BackgroundColor

The fill color (eg.legend background, markers, radar fill in radar chart (if RadarStyle==Filled), area color in area charts, bar color in bar charts, surface color in surface charts(if Wireframe==false), bubble color in bubble charts) Accepts STRING values in the format: #RRGGBB, #RRGGBBAA or NULL

BackgroundPattern

The type of pattern used as background fill (if BackgroundPattern and BackgroundPatternColor are set) Accepts STRING values: Horizontal, Min, Vertical, ForwardDiagonal, BackwardDiagonal, Cross, LargeGrid, Max, DiagonalCross, Percent05, Percent10, Percent20, Percent25, Percent30, Percent40, Percent50, Percent60, Percent70, Percent75, Percent80, Percent90, LightDownwardDiagonal, LightUpwardDiagonal, DarkDownwardDiagonal, DarkUpwardDiagonal, WideDownwardDiagonal, WideUpwardDiagonal, LightVertical, LightHorizontal, NarrowVertical, NarrowHorizontal, DarkVertical, DarkHorizontal, DashedDownwardDiagonal, DashedUpwardDiagonal, DashedHorizontal, DashedVertical, SmallConfetti, LargeConfetti, ZigZag, Wave, DiagonalBrick, HorizontalBrick, Weave, Plaid, Divot, DottedGrid, DottedDiamond, Shingle, Trellis, Sphere, SmallGrid, SmallCheckerBoard, LargeCheckerBoard, OutlinedDiamond, SolidDiamond or NULL

BackgroundPatternColor

The foreground color of the pattern used as background fill (if BackgroundPattern and BackgroundPatternColor are set) Accepts STRING values in the format: #RRGGBB, #RRGGBBAA or NULL

BackgroundShadow

If set to true, the background fill will be a radial gradient from BackgroundColor (centre) to transparent (edges). NOTE: This overrides BackgroundPattern/ BackgroundPatternColor Accepts LOGICAL values: TRUE, FALSE

Font

The default font and color of the data label (unless overriden in PptPointLabel.Segments) Accepts a named LIST of ExportingFontAndColor values or NULL

Index

The 0-based index of the data point within this series which this label applies to. Accepts INTEGER values 0 to 4,294,967,295

NumberingFormat

If not null, this overrides the numbering format of the value field. Accepts STRING values or NULL

OutlineColor

The outline color (eg.radar outline in radar charts (if RadarStyle!=Filled), scatter line color in scatter charts(if ScatterStyle!=Marker), surface wireframe color in surface charts(if Wireframe==true), line color in 2d line charts) Accepts STRING values in the format: #RRGGBB, #RRGGBBAA or NULL

OutlineShape

The shape which this data label should be (only makes a meaningful difference if OutlineStyle != None) Accepts STRING values: Rectangle, RoundRectangle, Ellipse, RightArrowCallout, DownArrowCallout, LeftArrowCallout, UpArrowCallout, WedgeRectangleCallout, WedgeRoundRectangleCallout, WedgeEllipseCallout, BorderCallout1, BorderCallout2, AccentCallout1, AccentCallout2 or NULL

OutlineStyle

Line style (null defaults to None) Accepts STRING values: Solid, Dash, Dot, DashDot, DashDotDot, Custom, None or NULL

OutlineWidth

Line width in Points (null for ppt default width) Accepts REAL values or NULL

Position

The position of the data label Accepts STRING values: BestFit, Bottom, Center, InsideBase, InsideEnd, Left, OutsideEnd, Right, Top or NULL NOTE: Although you can safely set this value to any of the accepted values, it will only have an effect in the following combinations: - Bar charts (not 3d): Center, InsideEnd, InsideBase, OutsideEnd - Stacked bar charts (not 3d): Center, InsideEnd, InsideBase - Scatter, bubble, line (not 3d) and stock charts: Center, Left, Right, Top, Bottom - Pie, of pie, 3d pie charts (not doughnut): Center, InsideEnd, OutsideEnd, BestFit

PositionOffset

The manual offset of the data label from its default position, expressed as a fraction of the plot area size. X, Y values should be between -1 and 1. Accepts a named LIST of PointF values or NULL

Segments

If set, this list of segments overrides the default label text, making the ShowValue/ShowCategoryName/etc flags irrelevant for this label (except for ShowLegendKey). Each segment is either a hard coded string literal or a linked field (such as value, category name, series name, etc). Accepts a LIST of named LISTS of LabelSegment values

Separator

If not null, this overrides the default powerpoint separator when multiple ShowValue/ShowCategory/etc flags are true. Accepts STRING values or NULL

ShowBubbleSize

Whether we should show bubble sizes in data labels Accepts LOGICAL values: TRUE, FALSE or NULL

ShowCategoryName

Whether we should show category names in data labels (in XY type plots, this means show the X value) Accepts LOGICAL values: TRUE, FALSE or NULL

ShowLegendKey

Whether we should show legend keys in data labels Accepts LOGICAL values: TRUE, FALSE or NULL

ShowPercent

Whether we should show percentages in data labels Accepts LOGICAL values: TRUE, FALSE or NULL

ShowSeriesName

Whether we should show series names in data labels Accepts LOGICAL values: TRUE, FALSE or NULL

ShowValue

Whether we should show values in data labels (in XY type plots, this means show the Y value) Accepts LOGICAL values: TRUE, FALSE or NULL