Skip to main content

AXIS

Define axis settings of a chart axis.

Syntax

=AXIS(Min, Max, Step, TimeStep, ZoomMin, ZoomMax)

Arguments

NameDescription
MinMinumum axis Value.
MaxMaximum axis value
StepStep for axis ticks or grid lines. For time axis the step will increment the time step.
Time StepStep type for time units. Allow values are 'year', 'quarter', 'month', 'day', 'hour', 'minute', 'second' or 'millisecond'.
ZoomMinAxis minumum to use, if chart is zoomed. This value will be filled automatically, if axis is zoomed using the mouse.
ZoomMaxAxis maximum to use, if chart is zoomed. This value will be filled automatically, if axis is zoomed using the mouse.

Return Value

TRUE or an Error Code

Example

FunctionResultComment
=AXIS(0, 200, 50)TRUEScales the axis from 0 to 200 using a step of 50 units.