<< Click to Display Table of Contents >> Set Axis |
![]() ![]() ![]() |
With the chart selected, the chart axis option can be set in the right panel => Axis. Among the axis options are: Column axis/Row axis, Field, Axis Hiding, Position, Axis Line hidden, Grid Line, Axis-label, Scale, scale settings.
The properties of the axis page are as follows:
[Field] Select the axis for setting the attribute.
[Axis Hidden] Set whether the axis is hidden.
[Position] Sets the position of the chart where the axis is located. The Column axis includes Auto, Bottom, Middle, and Top, and the default is Bottom; the Row axis includes Auto, Left, Middle, and Right, and the default is Left.
[Axis Line hidden] Set whether the axis is visible or not. It is not displayed when the axis is hidden.
[Grid Line] There are three options here, which are Auto, Display Grid, Hide Grid, Default is Auto: When you bind a metric, it automatically displays the grid. When you bind a dimension, the grid is not displayed automatically.
[Label Hidden]Set whether the label is visible or not. The axis label will be hidden after setting hide.
[Label Position] Set the position of the axis label,which includes internal and external.
[Label Interval] The setting shows a label every several ticks.
[Scale Hidden] Set whether the scale is visible. It is not displayed when the scale is hidden.
[Scale Position] Set the scale display position.
[Scale Setting] Set the attribute of the axis scale. When binding the dimension, the item has scale type, reverse scale, ignore null value. when binding Measure, this item can set scale type, reversal scale, shared axis, Max, Min, Major Unit, Minor Unit, X-axis data start value, 0 as axis center, logarithmic scale, ignore null value; when binding DATE, this item can set scale type, forward, backward.
The properties of the scale settings are as follows:
[Tick Type] The scale type is divided into time scale, discrete scale and continuous scale. You can use this menu to set the type of axis.
[Reverse scale] The position of the start and end of the axis is changed, and the Mark value also changes. This item is automatic by default. If the binding is a dimension field, the Auto is equivalent to the inversion; if the binding is a measurement field, the Auto is equivalent to not inverting.
[Ignore Null] Whether to ignore null when calculating.
[Logarithmic Scale ]Takes the logarithm of the scale on the axis.
[Initial Value] Set the start value of the marker. The following figure shows that the start value of the Column axis data is set to 50000. At this time, the value less than 50000 is down from 50000, and the value greater than 50000 is always Up.
[Share group] You can set whether the different axes under the same chart share the same range. You need to manually enter the name of the shared group. Select the shared group name you have defined on other axes. The selected axis can be shared by default. Shared scope means that the scale on the axis is the same.
[Min] Set the minimum value of the axis.
[Max] Set the maximum value of the axis.
[0 as the axis center] When checked, the axis interval can be set to 0 symmetry.
[Main Unit] Set the main scale.
[Minor Unit] Sets the minor scale.