PptSeriesLabels

From Q
Jump to navigation Jump to search

PptSeriesLabels

This represents the data labels on a series of a chart and contains the various pieces of data required to be exported/updated in Powerpoint. A value of NULL in any field means a default value will be used. NOTE FOR PIE-LIKE PLOTS: * Pie like plots (Pie, Donut, *OfPie, etc) are a special case for series labels * In powerpoint, labels for individual pie slices are stored as individual point DataLabels, however for simplicity we model them here as series labels * PptChartLabels.CustomSeries should be a list of all pie slices, or a list of one if all pie slice labels are the same

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

CustomPoints

A list of individual point labels. Accepts a LIST of named LISTS of PptPointLabel values

Font

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

LeaderLine

Leader Line settings, defaults to a black solid line (only used if ShowLeaderLines is true) Accepts a named LIST of PptLineSettings values

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

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

ShowLeaderLines

Whether there should be leader lines to the data label 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