Charts - axis settings

The axis tab enables you to tailor the x-axis and the primary and secondary y-axis - show or hide the axis, set the padding between categories, and customize the title and labels.

1. X-axis

1.1. Show x-axis

You can choose to show or hide the x-axis labels. Disable the toggle to hide the x-axis labels.

1.2. Show title

You can choose to show or hide the x-axis title. Disable the toggle to hide the x-axis. Click on the gear icon to open the x-axis title settings.

1.3. Reverse x-axis

Analytics+ allows you to order the x-axis categories in reverse order as well. Notice how the months are displayed from December to January or the quarters are arranged from Q4 - Q1 when the Reverse x-axis toggle is enabled.

1.4. Ragged hierarchy

You can suppress blank category rows when you have unbalanced hierarchies where the number of levels is uneven. Enable the ‘Ragged hierarchy’ toggle to hide blank rows. Notice how blank categories are displayed when the ragged hierarchy toggle is disabled. Learn more about managing hierarchies with Analytics+.

Notice how blank categories are displayed when the ragged hierarchy toggle is disabled.

1.5. Category grouping

With Anlytics+, you can expand and collapse hierarchies on the x-axis. You can focus on specific sections of the hierarchy by expanding those sections alone. The scaling of the bars is adjusted according to the hierarchy level. Notice how the year and quarter bars are taller than the month bars when Category grouping is enabled. The months are grouped under the quarters and quarters are grouped under the years.

When category grouping is disabled, the hierarchy is fully expanded and the bars are scaled uniformly.

1.6. Axis type

You can select between Auto, Categorical, and Continuous axes.

This setting is enabled only when category grouping is turned off. Axis type is set to 'Categorical' when category grouping is turned on.

Categorical axis

Auto axis

Continuous axis

When your axis data contains a time series, you can plot it on a continuous axis. You will have additional options to select the date range and focus on a specific time period. In the example above, we have filtered the data between 2015 and 2017.

1.7. Single child

Analytics+ ships with multiple options to display single node hierarchies i.e. when a parent hierarchy has only one child. For single-child hierarchies, you have options to hide leaf nodes, hide all nodes if they are single children, or hide the parent node if it has only a single child. Learn more about working with hierarchies.

Notice how the day 1 children are removed when the 'Parent only' option is chosen.

1.8. Category width

You can set a custom width for each x-axis category by selecting 'Fixed' from the dropdown menu. The default setting is Auto.

The Min width (px) option is enabled when the category width is set to fixed. You can change this value to increase or decrease the size of each category on the x-axis.

1.9. Inner padding

You can adjust the space between consecutive categories on the x-axis. In this example, we have increased the padding from the default values of 30 to 70px.

1.10 Enable scroll

You can choose whether to allow report viewers to scroll along the x-axis if all the categories do not fit into the canvas.

When scrolling is disabled, only the categories that fit in the canvas will be displayed. Users will not be able to view the other categories.

1.11. Label settings

The customization settings for x-axis labels have been listed below:

Display:

Responsive: The label orientation will be adjusted according to the canvas and data configuration.

Rotated: The labels are rotated 90 degrees.

Stepped: Consecutive labels are displayed in separate rows.

Hidden: X-axis labels are hidden.

Font: You can set the font style, size, and color of the x-axis labels.
Word wrap: When the labels are too long, part of the label may get hidden. Enable word wrap to display the hidden portion in the next line.
Padding: Adjust the space between the x-axis title and category labels.

Axis line width: Set the thickness of the axis line.

1.12. Grid line

You can display grid lines representing each x-axis category. Grid line customizations have been listed below.

Position

The 'Middle' position renders grid lines at the center of the label.

The 'Extreme' option renders grid lines at the starting point of the label.

Style

You can render the grid lines as solid, dotted, or dashed lines.

Format

You can customize the thickness and color of the gridlines.

1.13. Axis position

The x-axis is rendered at the bottom left by default. You can also display it at the top right.

1.14. Show slider

Filter x-axis values and focus on specific data ranges by enabling the slider.

1.15. Reset X-axis

Click the reset button to revert all x-axis settings to the default configuration.

2. X-axis title settings

From the title settings window, you can apply the customizations listed below:

Font style: set bold/italics and a custom color
Set a custom size in pixels
Assign the font family
Set a custom x-axis title. By default, Analytics+ uses the dimension name in the dataset as the title but you can override it.

Click on the gear icon to open the x-axis settings side pane.

3. Y-axis settings

Some of the Y-axis options are the same as what we have for the X-axis. We'll discuss the options that are unique to the Y-axis.

3.1. Apply measure color

Enable this option if you want to apply the same color as the measure for the Y-axis title.

3.2. Reverse axis

Enable the Reverse y-axis toggle to change the order in which y-axis labels are displayed. When it comes to financial charts, reversing the Y-axis can emphasize losses more clearly, making it easier to analyse profits and losses.

3.3. Display

You can choose how to display the intervals on the Y-axis with the Display option. The interval values are hidden when 'Off' is selected.

When working with IBCS templates with uniform scaling, certain data points may be in millions, while others can be in thousands, hundreds, or even tens. Scale bands can be enabled in such scenarios.

In the sample IBCS template, the total bar contains values in thousands whereas the variance values are less than 30. Scale bands have been plotted to bridge the disparity in scaling.

3.4. Axis break icon

Axis breaks are used in charts to emphasize certain parts of the data while compressing or omitting less relevant parts. Axis breaks cannot be applied if this option is disabled.

3.5. Axis break gradient

Analytics+ adds a gradient to identify the section of the chart for which an axis break has been applied. Disable this option to suppress the gradient.

3.6. Auto axis min/max

When this option is enabled, Analytics+ will detect the y-axis values from your dataset and automatically set the minimum and maximum values.

You can also set custom values by disabling the option.

3.7. Label

Customize the Y-axis labels using these options.

3.7.1. Font

Set the font emphasis, size, and color of the y-axis labels.

3.7.2. Scaling

Set the scaling factor for the y-axis.

When 'Flexible' scaling is selected, Analytics+ assigns the appropriate scaling factor based on the data. You can also choose a custom scaling factor of thousands, millions, or billions.