# 3.7.5.27 Layer.Axis

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

(2021b)

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.

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)

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.

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);

numeric

Set the number of decimal places displayed in the tick labels.

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.inc Read/write numeric Major tick increment. 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.

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 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. This property is NOT supported in 3D graph. layer.axis.link.from$

(2015 SR0)

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.

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.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.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.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.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);