Layer.AxisLayer-Axis-obj
The Axis object is a sub-object of the layer object. The axis object also contains sub-objects: Breaks, Grid, and Label. You can use range notation to define a layer object:
- range layerObject = [pageName]layerName!
And then access the axis object by:
- layerObject.Axis.property
Where Axis is the axis specification: X is the bottom X axis, X2 is the top X axis, Y is the left Y axis, Y2 is the right Y axis, Z is the front Z axis, Z2 is the back Z axis, Zh is the ZhX axis, Zh2 is the back ZhY axis, and Zh3 is the back ZhZ axis.
In Radar Chart, YN is the Nth radar axis, for instance, Y3 is the third radar axis counted clockwisely from the default labeled axis (Y1).
Properties
Here, axis is a placeholder for x, y or z and axis2 is a placeholder for x2, y2 or z2.
Property
|
Access
|
Description
|
layer.axis.adj
(2021b)
|
Read/write numeric
|
For 2D ternary coordinate, show the opposite axis on the parallel axis or adjacent axis : 1 = show on adjacent axis; 0 = show on parallel axis of current axis.
Note: This property is equal to Opposite Axis Show at option in the Scale tab of Axis dialog for Ternary graphs.
|
layer.axis.arrow
|
|
For more sub-object of the axis arrow object, please see this page.
|
layer.axis.arrow.show
|
Read/write numeric
|
Show the arrow at end/begin/both of axis
0=not show arrow;
1= show at the end of axis;
2= show at the begin of axis;
3= show at the both of the axis
|
layer.axis.atZero
|
Read/write numeric
|
Display a straight line at Y = 0 for an X axis, X = 0 for a Y axis: 1 = show, 0 = hide.
Note: This property is NOT supported in 3D graph.
|
layer.axis.BarBreakBorder
(2020b)
|
Read/write numeric
|
For column and bar chart, if layer.ais.PlotBreakSymbol is turned on, layer.axis.BarBreakBorder can further determine whether the break marker is plotted at both borders of the bar. 0 = the break marker is plotted across the entire bar, 1 = the marker is plotted at both borders.
|
layer.axis.breaks
|
|
For more sub-object of the breaks object, please see this page.
|
layer.axis.color
|
Read/write numeric
|
Axis color. Numbers from the color list, or transparent (0). The color function can be used, as in: layer.x.color = color(blue); or layer.y2.color = color(240,208,0);
|
layer.axis.decPlaces
|
Read/write numeric
|
Set the number of decimal places displayed in the tick labels.
|
layer.axis.firstTick
|
Read/write numeric
|
First tick value.
|
layer.axis.formula$
|
Read/write string
|
Set custom direct formula when scale type is "Custom Formula".
|
layer.axis.from
|
Read/write numeric
|
First axis scale value. If the data is date format, you have to use the corresponding Julian days instead. To convert to Julian days, refer to Date.
|
layer.axis.grid
|
|
For more sub-object of the grid object, please see this page.
|
layer.axis.grid.show
|
Read/write numeric
|
Show the grid lines
0=not show grid lines;
1= show the major grid lines;
2= show the minor grid lines;
3= show both major and minor grid lines;
|
layer.axis.inc
|
Read/write numeric
|
Major tick increment.
|
layer.axis.IndivScale
(2023)
|
Read/write numeric
|
Only support for Y axis.
When there are two Y axes shows, specfify whether alllow to rescale each Y independently:
layer.y.IndivScale = 1;
//1 = Turn on to rescale left Y and right Y independently; 0=Right Y and left Y share same axis scale.
|
layer.axis.invformula$
|
Read/write string
|
Set custom inverse formula when scale type is "Custom Formula".
|
layer.axis.label
|
|
For more sub-object of the label object, please see this page.
|
layer.axis.labelSubtype
|
Read/write numeric
|
Tick label format: 1 = decimal, 2 = scientific, 3 = engineering (1K), and 4 = decimal (1,000).
|
layer.axis.labelText$
|
Read/write string
|
Dataset name if the tick label is text from dataset. To read, assign the value to a string variable.
|
layer.axis.labelType
|
Read/write numeric
|
Tick label type: 1 = numeric, 2 = text from dataset, etc.
|
layer.axis.link
(2023b)
|
Read/write numeric
|
Link type for the specified axis residing in a layer that is linked with the layer.link property.
0 = no link;
1 = one-to-one link;
3 = Align mode
This property is NOT supported in 3D graph.
|
layer.axis.link.from$
(2015 SR0)
|
Read/write string
|
Custom linking From value formula for child layer X/Y scale in terms of the parent layer scale value(s). The parent layer From and To scale values syntax for X and Y axis are X1, X2, Y1, Y2 respectively.
When layer.axis.link=3, the specified axis will align to another axis of same direction at specified axis position; this axis postion for alignment can be specified by layer.axis.link.from$. For Example
//Align right Y to left Y at Y = 0
layer.y2.link = 3; // mode=align
layer.y2.link.from$ = 0; // axis position value=0
|
layer.axis.link.to$
(2015 SR0)
|
Read/write string
|
Custom linking To value formula for child layer X/Y scale in terms of the parent layer scale value(s). The parent layer From and To scale values syntax for X and Y axis are X1, X2, Y1, Y2 respectively.
|
layer.axis.majorTicks
|
Read/write numeric
|
Number of major ticks. The default value of 0 is ignored. Setting this to a positive number will result in approximately that number of major ticks.
|
layer.axis.minorTicks
|
Read/write numeric
|
Number of minor ticks.
|
layer.axis.mticklength
|
Read/write numeric
|
Minor tick length.
|
layer.axis.mtickthickness
|
Read/write numeric
|
Minor tick thickness.
|
layer.axis.opposite
|
Read/write numeric
|
Line opposite the axis: 1 = enable, 0 = disable.
This property is NOT supported in 3D graph.
|
layer.axis.PlotBreakSymbol
(2020b)
|
Read/write numeric
|
Add break marker to plot 0 = do not show break marker on the plot, only a gap at the axis break region, 1 = show break marker on the plot, the marker shape follows the shape of axis break
|
layer.axis.postype
|
Read/write numeric
|
Axis position: 0 = "Default position", 1 = "% from left", 2 = "At position ="
Note: When layer.axis.postype is set to 1 or 2, please work with layer.axis.position to specify the percent/value
Example:
//Offset the y axis to be 20% of the axis length left from its default position
layer.y.postype=1;
layer.y.position=20;
|
layer.axis.position
|
Read/write numeric
|
Specify the axis position value. It is only available when layer.axis.postype = 1 or = 2.
|
layer.axis.rescale
|
Read/write numeric
|
Rescale type: 1 = manual, 2 = normal, 3 = auto, 4 = fixed from, and 5 = fixed to.
|
layer.axis.rescaleMargin
|
Read/write numeric
|
% of data range used to produce a margin around data. Select Plot:Rescale to Show All to view the change.
|
layer.axis.rescaleperiod
|
Read/write numeric
|
Specify whether rescale the angular axis when Unit=Custom for a polar graph.
If there are points outside of original custom unit range, setting this object to 1, the angular axis range will be updated when you rescale the axis.
Default value is 0, which means the angular axis range won't rescale for custom unit.
|
layer.axis.reverse
|
Read/write numeric
|
Reverse axis direction: 1 = enable, 0 = disable.
Note:This property is supported in 3D OpenGL graph, but it can NOT work when close OpenGL (@ogl=0).
|
layer.axis.showAxes
|
Read/write numeric
|
Axis and tick display: 0 = hide both axes, 1 = show left, bottom or front axis, 2 = show right, top or back axis, 3 = show both axes. axis and axis2 are the same.
|
layer.axis.showGrids
|
Read/write numeric
|
Grid display: 0 = hide grids, 1 = show major grids, 2 = show minor grids, and 3 = show both grids. axis and axis2 are the same.
|
layer.axis.showlabel
(2020)
|
Read/write numeric
|
Show tick labels on sepcified axis: 0 = hide labels, 1 = show labels.
|
layer.axis.showLabels
|
Read/write numeric
|
Show tick labels on axes: 0 = hide both labels, 1 = show left or bottom axis, 2 = show right or top labels, 3 = show both labels. axis and axis2 are the same.
|
layer.axis.showopposite
(2020)
|
Read/write numeric
|
Show opposite axis line of the specified axis: 0 = hide opposite axis, 1 = show opposite axis.
|
layer.axis.space
|
Read/write numeric
|
Same as layer.axis.type.
|
layer.axis.thickness
|
Read/write numeric
|
Width of axis line in points.
|
layer.axis.ticklength
|
Read/write numeric
|
Major tick length.
|
layer.axis.ticks
|
Read/write numeric
|
Controls the major and minor ticks as follows: 0 = no ticks, 1 = major in, 2 = major out, 4 = minor in, and 8 = minor out. Numbers can be combined, so 1 + 2 + 8 = 11 (major ticks in and out, minor ticks out).
|
layer.axis.TicksByData$
|
Read/write numeric
|
Specifies a dataset to control major ticks mark position and labels.
Note: You can use an existing dataset or type a series of numbers separated by Space.
|
layer.axis.mticksbydata$
|
Read/write numeric
|
Specifies a dataset to control minor ticks mark position and labels.
Note: You can use an existing dataset or type a series of numbers separated by Space.
|
layer.axis.tickthickness
|
Read/write numeric
|
Major tick thickness.
|
layer.axis.to
|
Read/write numeric
|
Last axis scale value. If the data is date format, you have to use the corresponding Julian days instead. To convert to Julian days, refer to Date.
|
layer.axis.type
|
Read/write numeric
|
Axis scale type: 0 or 1 = linear, 2 = log10, 3 = probability, 4 = probit, 5 = reciprocal, 6 = offset reciprocal, 7 = logit, 8 = ln, 9 = log2, 10 = Double Log Reciprocal and 11 = Custom Formula.
|
layer.axis.whiteout
|
Read/write numeric
|
White out around tick labels: 1 = enable, 0 = disable.
|
Examples
This script is used to set the first value of bottom X axis for date data:
layer.x.from = date(1/7/2014 04:46:06, 2);
This script types the first value of the left Y axis to the Script window in the second layer of the graph1 window:
range ll = [graph1]2!;
ll.y.from= ;
This script sets the major ticks out and minor ticks in for the top X axis in the active layer:
range ll = !;
ll.x2.ticks = 6;
This script specifies the custom linking formulae for linked layers:
layer.x.link.from$ = "X1-X2";
layer.x.link.to$ = "X1+X2";
This script specifies a dataset to control X axis major tick mark positions and labels:
//Control major ticks show mark 1, 4, 9 and 17 position, and show labels.
layer.x.ticksbydata$="1 4 9 17";
//If want to use a defined dataset/range as the ticks mark position,
//use $(vector,format) to convert the dataset/range into space separated list.
dataset aa={1,4,9,17};
layer.x.ticksbydata$=$(aa);
range bb=[Book1]1!3 ; //Declared Book1 sheet1 column3 as a range
layer.y.ticksbydata$=$(bb);
This script specifies a column dataset to control the Tick Labels:
//Set the text column C in Book1 as the X axis tick labels
layer.x.labeltext$=book1_C;
This script will individually change the scale and color of third radar axis in Radar Chart counted from the default labeled radar axis for current active graph window:
layer.y3.from = 10;
layer.y3.color = color(red);
|