PptAxisSettings

PptAxisSettings

This page is currently under construction. Represents an axis on a chart and contains the various settings about how it should be displayed to Powerpoint.

AxisLine

Axis Line settings, defaults to a light grey solid line Accepts a named LIST of PptLineSettings values

AxisType

The type of axis. An axis can be of type Value (for numeric data), Category (for displaying strings and categorical data), or Series (the other bottom axis in a 3D chart) Category is normally the X axis but is reversed with the Value axis for bar charts. Series axis is only used for 3d charts. Accepts STRING values: Value, Category, Series

Crosses

Where an axis crosses. By default an axis crosses at 0. It can also be set to cross at the min or max value on an axis. Accepts STRING values: AutoZero, Maximum, Minimum

LabelPosition

Axis label position (including None) Accepts STRING values: High, Low, NextTo, None

LabelsFont

The font and color of the Axis labels (only used if shown) Accepts a named LIST of ExportingFontAndColor values

LabelsRotation

The clockwise rotation of the labels in degrees Accepts INTEGER values -360 to 360

LogarithmicBase

Number base for Logarithmic axis scaling (null means not logarithmic scaling) Accepts REAL values or NULL

MajorGridLine

Major Grid Line settings, defaults to no line Accepts a named LIST of PptLineSettings values

MajorTickMark

Sets the positioning of the major tick marks of an axis relative to the axis line. By default we set it to None, meaning we don't display the major tick marks. Accepts STRING values: Cross, Inside, None, Outside

MajorUnit

The gap between the major grid lines and axis labels (null means use PowerPoint default) Accepts REAL values or NULL

Maximum

The upper bound of the axis. (null means powerpoint decides) Accepts REAL values or NULL

Minimum

The lower bound of the axis. (null means powerpoint decides) Accepts REAL values or NULL

MinorGridLine

Minor Grid Line settings, defaults to no line Accepts a named LIST of PptLineSettings values

MinorTickMark

Sets the positioning of the minor tick marks of an axis relative to the axis line. By default we set it to None, meaning we don't display the minor tick marks. Accepts STRING values: Cross, Inside, None, Outside

MinorUnit

The gap between the minor grid lines (null means use PowerPoint default) Acceepts REAL values or NULL

NumberFormat

The number format for Axis labels (defauls to "General"). Represented by a "format code" as used in powerpoint, eg. "$#,##0.0", "d/mm/yyyy", "[$-x-systime]h:mm:ss AM/PM", "0.00%", "# ?/?", "0.00E+00", "@" Accepts STRING values

Orientation

The order of values on a Value axis, from maximum to minimum or from minimum to maximum. Its worth noting that powerpoint defaults to MaxMin, but we default to MinMax to match what Displayr charts look like. Accepts STRING values: MaxMin, MinMax

Position

The position of the axis on a chart. Accepts STRING values: Bottom, Left, Top, Right

ShowTitle

Whether or not to show the Axis title Accepts LOGICAL values: TRUE, FALSE

TitleFont

The font and color of the Axis title (only used if shown) Accepts a named LIST of ExportingFontAndColor values