Fixed Chart Object properties
A fixed object in a chart is an object not created with the Chart toolbar. See “Chart Window properties” and “Chart Background properties” for chart properties. For a list of drawn chart objects (such as arrows), see “Drawn Chart Object properties”.
To view properties, arguments, and syntax for fixed chart objects, see the reference topics that follow.
Fixed Chart Object names
The following table lists the names for the objects in a fixed chart:
Property
|
Description
|
G$Base
|
Base of a 3D chart
|
G$BulletSeries[n]
|
nth level of bulleted text in a bullet chart;the first level is 1, the second is 2
|
G$Graph
|
Background of the chart window
|
G$LeftWall
|
Left wall of a 3D chart grid
|
G$Legend
|
Chart legend
|
G$Series[x,y]
|
yth data point of the xth series in the chart
|
G$SeriesLabel
|
Series labels
|
G$Title
|
Title, subtitle, and title box of the chart
|
G$X1Axis
|
x-axis
|
G$X1Title
|
x-axis title
|
G$Y1Axis
|
Primary y-axis
|
G$Y1Title
|
Primary y-axis title
|
G$Y2Axis
|
Secondary y-axis
|
G$Y2Title
|
Secondary y-axis title
|
Area Fill properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the area fill properties.
The following table lists properties and syntax for the Area Fill object:
Property
|
Syntax
|
Description
|
Area Fill
|
[NBName]ChartName:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Border Settings
|
Border_Setting s;S0W1 | S0W2 | S0W3 | S0W4 | S1W1 | S2W1 | S3W1 | S4W1 | S5W1, Red, Blue, Green
|
|
Fill Settings
|
Fill_Settings
|
|
Example
{SelectObject “G$RightWall”}
{SetProperty Fill_Settings;”Pattern;Horizontal Grid;;172;87;86;255;255;255″}
Area Series properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the area series properties.
The following table lists properties and syntax for the Area Series object:
Property
|
Syntax
|
Description
|
Area Series
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Analyze
|
Analyze;None | Aggregration | Moving Average | Linear Fit | Exponential Fit,…
Note: If Aggregration, other arguments are:…<Table>, Show in Legend?(0 | 1), Days | Weeks | Months | Quarters | Years, Weeks | Months | Quarters | Years, SUM | AVG | STD | STDS | MIN | MAX | VAR | VARS
|
|
|
Note: If Moving Average, other arguments are:…<Table>, Show in Legend?(0 | 1), Period, None | Standard
|
|
|
Note: If Linear Fit or Exponential Fit, other arguments are:…<Table>, Show in Legend?(0 | 1)
|
Border Settings
|
Border_Settings;S0W1 | S0W2 | S0W3 | S0W4 | S1W1 | S2W1 | S3W1 | S4W1 | S5W1, Red, Blue, Green
|
|
Fill Settings
|
Fill_Settings
|
|
Series Options
|
Series_Options;DataSeries, LabelSeries, Legend
|
| |
Axis Title properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the axis title properties.
The following table lists properties and syntax for the Axis Title object:
Property
|
Syntax
|
Description
|
Axis Title
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Text Font
|
Text_Font
|
|
Text Settings
|
Text_Settings
|
|
Title
|
Title;Title
|
|
Example
{SelectObject G$Y1Axis}
{SetProperty Text_Font;”Arial;18;Yes;No;No;No”}
Bar Series properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the bar series properties.
The following table lists properties and syntax for the Bar Series object:
Property
|
Syntax
|
Description
|
Bar Series
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Analyze
|
None | Aggregration | Moving Average | Linear Fit | Exponential Fit,…
|
Note: If Aggregration, other arguments are:…<Table>, Show in Legend?(0 | 1), Days | Weeks | Months | Quarters | Years, Weeks | Months | Quarters | Years, SUM | AVG | STD | STDS | MIN | MAX | VAR | VARS
|
|
|
Note: If Moving Average, other arguments are:…<Table>, Show in Legend?(0 | 1), Period, None|Standard
|
|
|
Note: If Linear Fit or Exponential Fit, other arguments are:…<Table>, Show in Legend?(0 | 1)
|
Bar Options
|
Width%, Margin%, No | Partial | Full
|
|
Border Settings
|
S0W1 | S0W2 | S0W3 | S0W4 | S1W1 | S2W1 | S3W1 | S4W1 | S5W1, Red, Blue, Green
|
|
Fill Settings
|
|
|
Riser Style
|
Style(1 | 2 | 3 | 4), NumberOfFaces(0 | 4 | 6 | 8)
|
Note: Riser Style is available only for 3D bar charts
|
Series Options
|
DataSeries, LabelSeries, Legend, Bar | Line | Area | Default, Primary | Secondary
|
|
Example
{SelectObject "G$Series[3,6]"}
{SetProperty Riser_Style;”3;4″}
Bullet Series properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the bullet series properties.
The following table lists properties and syntax for the Bullet Series object:
Property
|
Syntax
|
Description
|
Bullet Series
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Bullet Color
|
|
|
Bullet Indentation
|
BeforeBullet (0-500), AfterBullet (0-500), HangingIndent?(0|1)
|
|
Bullet Style
|
BulletStyle, BulletSize(0-32)
|
|
Line Spacing
|
SpaceBefore(0-500), SpaceAfter(0-500)
|
|
Text Font
|
|
|
Text Settings
|
|
|
Example
{SelectObject G$BulletSeries[1]} {SetProperty Bullet_Style;"8;22"}
Chart Background properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the chart background properties.
The following table lists properties and syntax for the Chart Background object:
Property
|
Syntax
|
Description
|
Chart Background
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Box Settings
|
No box | Single outline | Rounded corners | Double outline | Thick outline 1 | Thick rounded corners | Three dimensional | Thick outline 2 | Bevel out | Shadowed | Thick outline 3 | Bevel in, Red, Blue, Green
|
|
Chart Button
|
GotoSlide?, SlideName, Effect, Duration, Slow | Med | Fast, Overlay?, RunMacro?, MacroText
|
|
Fill Settings
|
|
|
Name (H)
|
Name
|
|
Example
{SelectObject} {SetProperty Chart_Button;"No;;Cut;0;Fast;No;Yes;No;Yes;{A:E1}"}
•
|
|
If a property name is followed by (H), it is a hidden property and does not a
ppear in the object’s Property dialog.
|
Chart Legend properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the chart legend properties.
The following table lists properties and syntax for the Chart Legend object:
Property
|
Syntax
|
Description
|
Legend
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Box Settings
|
No box | Single outline | Rounded corners | Double outline | Thick outline 1 | Thick rounded corners | Three dimensional | Thick outline 2 | Bevel out | Shadowed | Thick outline 3 | Bevel in, Red, Blue, Green
|
|
Dimension (H)
|
|
|
Fill Settings
|
|
|
Legend Position
|
None | Bottom | Right
|
|
Text Font
|
|
|
Text Settings
|
|
|
Example
{SelectObject G$Legend} {SetProperty Legend_Position;Bottom"}
•
|
|
If a property name is followed by (H), it is a hidden property and does not appear in the object’s Property dialog.
|
Chart Pane properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the chart pane properties.
The following table lists properties and syntax for the Chart Pane object:
Property
|
Syntax
|
Description
|
Chart Pane
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Border Options
|
Left, Top, Right, Bottom, Grids on Top
|
|
Border Style
|
S0W1 | S0W2 | S0W3 | S0W4 | S1W1 | S2W1 | S3W1 | S4W1 | S5W1, Red, Blue, Green
|
|
Dimension
|
|
|
Fill Settings
|
|
|
Example
{SelectObject G$Pane} {SetProperty Border_Position;"Yes;Yes;Yes;Yes;Yes"}
Chart Subtitle properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the chart subtitle propert
ies.
The following table lists properties and syntax for the Chart Subtitle object:
Property
|
Syntax
|
Description
|
Chart Subtitle
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Subtitle Font
|
|
|
Subtitle Text Settings
|
|
|
Example
{SelectObject G$Title} {SetProperty Subtitle_Font;"Arial;24;Yes;No;No;No"}
Chart Title Box properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the chart title box properties.
The following table lists properties and syntax for the Chart Title Box object:
Property
|
Syntax
|
Description
|
Chart Title Box
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Alignment
|
Left | Center | Right
|
|
Border Color
|
|
|
Box Settings
|
No box | Single outline | Rounded corners | Double outline | Thick outline 1 | Thick rounded corners | Three dimensional | Thick outline 2 | Bevel out | Shadowed | Thick outline 3 | Bevel in, Red, Blue, Green
|
|
Dimension
|
|
|
Fill Settings
|
|
|
Name (H)
|
Name
|
|
Text Font
|
|
|
Text Settings
|
|
|
Example
{SelectObject G$Title} {SetProperty Alignment;Left"}
•
|
|
If a property name is followed by (H), it is a hidden property and does not appear in the object’s Property dialog.
|
Chart Window properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the chart window properties.
The following table lists properties and syntax for the Chart Window object:
Property
|
Syntax
|
Description
|
Chart Window
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the char
t containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Aspect Ratio
|
Floating Chart | Screen Slide | 35mm Slide | Printer Preview | Full Extent
|
|
Grid
|
GridSize, DisplayGrid, SnapToGrid
|
|
Example
{SetProperty Aspect_Ratio;"35mm Slide"}
Column Chart properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the column chart properties.
The following table lists properties and syntax for the Column Chart object:
Property
|
Syntax
|
Description
|
Column Chart
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Border Settings
|
S0W1 | S0W2 | S0W3 | S0W4 | S1W1 | S2W1 | S3W1 | S4W1 | S5W1, Red, Blue, Green
|
|
Fill Settings
|
|
|
Label Options
|
LabelSeries, Currency | Value | Percent | None, ShowTick
|
|
Text Font
|
|
|
Text Settings
|
|
|
Example
{SelectObject "G$Series[1,4]"} {SetProperty Border_Settings;"S0W2;0;128;255"}
Float Series properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the float series properties.
The following table lists properties and syntax for the Float Series object:
Property
|
Syntax
|
Description
|
Float Series
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Analyze
|
None | Aggregration | Moving Average | Linear Fit | Exponential Fit,…
|
Note: If Aggregration, other arguments are:…<Table>, Show in Legend?(0 | 1), Days | Weeks | Months | Quarters | Years, Weeks | Months | Quarters | Years, SUM | AVG | STD | STDS | MIN | MAX | VAR | VARS
|
|
|
Note: If Moving Average, other arguments are:…<Table>, Show in Legend?(0 | 1), Period, None|Standard
|
|
|
Note: If Linear Fit or Exponential Fit, other arguments are:…<Table>, Show in Legend?(0 | 1)
|
Border Settings
|
S0W1 | S0W2 | S0W3 | S0W4 | S1W1 | S2W1 | S3W1 | S4W1 | S5W1, Red, Blue, Green
|
|
Fill Settings
|
|
|
Float Style
|
Style(0 | 1 | 2 | 3 | 4), NumberOfFaces(0 | 4 | 6 | 8), Size(8-32)
|
|
Series Options
|
DataBlock, LabelBlock, Legend, Bar | Line | Area | Default, Primary | Secondary
|
|
Example
{SelectObject "G$[1,3]"} {SetProperty Analyze;"Aggregation;;No;Days;Weeks;Sum"}
Line Series properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the line series properties.
The following table lists properties and syntax for the Line Series object:
Property
|
Syntax
|
Description
|
Line Series
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Analyze
|
Analyze;None | Aggregration | Moving Average | Linear Fit | Exponential Fit,…
|
Note: If Aggregration, other arguments are:…<Table>, Show in Legend?(0 | 1), Days | Weeks | Months | Quarters | Years, Weeks | Months | Quarters | Years, SUM | AVG | STD | STDS | MIN | MAX | VAR | VARS
|
|
|
Note: If Moving Average, other arguments are:…<Table>, Show in Legend?(0 | 1), Period, None|Standard
|
|
|
Note: If Linear Fit or Exponential Fit, other arguments are:…<Table>, Show in Legend?(0 | 1)
|
Fill Settings
|
Fill_Settings;
|
|
Line Settings
|
Line_Settings;S0W1 | S0W2 | S0W3 | S0W4 | S1W1 | S2W1 | S3W1 | S4W1 | S5W1, Red, Blue, Green
|
|
Marker Style
|
Marker_Style;M00 | M01 | M02 | M03 | M04 | M05 | M06 | M07 | M08 | M09 | M10 | M11 | M12 | M13 | M14 | M15, MarkerWeight, AutoSize?(0 | 1)
|
|
Series Options
|
Series_Options;DataBlock, LabelBlock, Legend, Bar | Line | Area | Default, Primary | Secondary
|
|
Example
{SelectObject "G$Series[1,1]"} {SetProperty Marker_Style;M02;5;1"}
Map properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the map properties.
The following table lists properties and syntax for the Map object:
Property
|
Syntax
|
Description
|
Map
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Font
|
|
|
Pin Symbol
|
Pin_Symbol;DisplayPinLabels? (Yes | No), DisplayPinSymbol? (Yes | No), Font (see “Font property”), Red, Blue, Green, Symbol (0-239)
|
|
Redraw Options
|
Redraw_Options;Automatic | Manual
|
|
Example
{SetProperty Redraw_Options;Manual}
Map Legend properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you spec
ify the map legend properties.
The following table lists properties and syntax for the Map Legend object:
Property
|
Syntax
|
Description
|
Map Legend
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Border Settings
|
Border_Settings;S0W1 | S0W2 | S0W3 | S0W4 | S1W1 | S2W1 | S3W1 | S4W1 | S5W1, Red, Blue, Green
|
|
Colors
|
Colors;Ranges (0-6), ShowLegend? (Yes | No), ExactMatch? (Yes | No), SetValuesManually? (Yes | No), MaxValue1, Red, Blue, Green, MaxValue2, Red, Blue, Green, MaxValue3, Red, Blue, Green, MaxValue4, Red, Blue, Green, MaxValue5, Red, Blue, Green, MaxValue6, Red, Blue, Green
|
|
Dimension (H)
|
Dimension
|
|
Fill Settings
|
Fill_Settings
|
|
Font
|
|
|
Legend Position
|
Legend_Position;None | Bottom | Right
|
|
Patterns
|
Patterns;Ranges (0-6), ShowLegend? (Yes | No), ExactMatch? (Yes | No), SetValuesManually? (Yes | No), Value1, Pattern (0-6), Value2, Pattern (0-6), Value3, Pattern (0-6), Value4, Pattern (0-6), Value5, Pattern (0-6), Value6, Pattern (0-6)
|
|
Title
|
Title;Title, DisplayTitle (Yes | No), Font (see “Font property”), Red, Blue, Green
|
|
Example
{SetProperty Title;"No;Arial;18;No;No;No;No;0;0;0"}
•
|
|
If a property name is followed by (H), it is a hidden property and does not appear in the object’s Property dialog.
|
Pie Chart properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the pie chart properties.
The following table lists properties and syntax for the Pie Chart object:
Property
|
Syntax
|
Description
|
Pie Chart
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Border Settings
|
S0W1 | S0W2 | S0W3 | S0W4 | S1W1 | S2W1 | S3W1 | S4W1 | S5W1, Red, Blue, Green
|
|
Explode Slice
|
Distance, Explode
|
|
Fill Settings
|
|
|
Label Options
|
Series, Currency | Value | Percent | None, ShowTick
|
|
Text Font
|
|
|
Text Settings
|
|
|
Example
{SelectObject "G$Series[1,1]"} {SetProperty Explode_Slice;"25"}
Series Label properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the series label properties.
The following table lists properties and syntax for the Series Label object.
Property
|
Syntax
|
Description
|
Series Label
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Format
|
Format, Precision | Type
|
|
Label Alignment
|
Above | Top | Middle | Below (for bar charts);Above | Center | Below | Left | Right (for area and line charts)
|
|
Text Font
|
|
|
Text Style
|
|
|
Example
{SelectObject G$SeriesLabel[2]} {SetProperty Label_Alignment;Middle}
X-Axis properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the X-Axis properties.
The following table lists properties and syntax for the X-Axis object:
Property
|
Syntax
|
Description
|
X-Axis
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Major Grid Style
|
S0W1 | S0W2 | S0W3 | S0W4 | S1W1 | S2W1 | S3W1 | S4W1 | S5W1, Red, Green, Blue
|
|
Minor Grid Style
|
S0W1 | S0W2 | S0W3 | S0W4 | S1W1 | S2W1 | S3W1 | S4W1 | S5W1, Red, Green, Blue
|
Note: This property only appears when inspecting an XY chart
|
Numeric Format
|
Format, Precision | Type
|
Note: This property only appears when inspecting an XY chart
|
Scale
|
Normal | Log, Automatic, High, Low, Increment, #Minors, ShowUnits
|
Note: This property only appears when inspecting an XY chart
|
Text Font
|
|
|
Text Settings
|
|
|
Tick Options
|
None | Below | Above | Across, DisplayLabels, NumRows, NoOverlap, #OfLabelsToSkip, Limit
|
|
X-Axis Series
|
SeriesBlock
|
|
Example
{SelectObject G$X1Axis {SetProperty X-Axis Series;"A:A8..A11"}
Y-Axis properties
| |
Syntax
[NBName]ChartName:ObjName.Property
Description
Lets you specify the Y-Axis properties.
The following table lists properties and syntax for the Y-Axis
object:
Property
|
Syntax
|
Description
|
Y-Axis
|
[NBName]Sheet:ObjName.Property
|
NBName is the name of the active notebook
ChartName is the name of the chart containing the object
ObjName is either the object ID number or the name of the object
Property is one of the strings listed in the Argument column of the dialog control property tables
|
Major Grid Style
|
S0W1 | S0W2 | S0W3 | S0W4 | S1W1 | S2W1 | S3W1 | S4W1 | S5W1, Red, Green, Blue
|
|
Minor Grid Style
|
S0W1 | S0W2 | S0W3 | S0W4 | S1W1 | S2W1 | S3W1 | S4W1 | S5W1, Red, Green, Blue
|
|
Numeric Format
|
Format, Precision | Type
|
|
Scale
|
Normal | Log, Automatic, High, Low, Increment, #Minors, ShowUnits
|
Note: An additional setting, ZeroLine, appears if the chart type is Variance.
|
Text Font
|
|
|
Text Settings
|
|
|
Tick Options
|
None | Left | Right | Across, DisplayLabels, LengthLimit, Limit
|
|
Example
{SelectObject G$Y1Axis} {SetProperty Tick_Options;"Right;Yes;No;3"}
Fixed Chart Object properties