Charts - axis settings
Last updated
Last updated
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.
You can choose to show or hide the x-axis labels. Disable the toggle to hide the x-axis labels.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
The x-axis is rendered at the bottom left by default. You can also display it at the top right.
Filter x-axis values and focus on specific data ranges by enabling the slider.
Click the reset button to revert all x-axis settings to the default configuration.
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.
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.
Enable this option if you want to apply the same color as the measure for the Y-axis title.
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.
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.
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.
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.
Customize the Y-axis labels using these options.
Set the font emphasis, size, and color of the y-axis labels.
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.
Specify the number of digits to display after the decimal point.
Set the spacing between the y-axis title and labels.
Specify a prefix or suffix for your y-axis labels.
You can customize the width of the y-axis labels.
Set the width and color of the axis line.
Enable or disable grid lines using the toggle. You can customize the Y-axis gridline style, thickness, and color.
Filter y-axis values and focus on specific data ranges by enabling the slider.
You can view your charts as well as the underlying data in a single window
Turn on this toggle to display the data table.
The measure names will be hidden when you disable the Legend Key toggle.
Display the measure names using IBCS notations or use the names from the dataset.
Customize the font and color of the data.
Enable and customize borders for the table.
Check the measures that you want to display in the data table. You can drag and re-order measures using the gripper .
