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. 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.3. 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.4. 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.5. 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.6. Label
Customize the Y-axis labels using these options.
3.6.1. Font
Set the font emphasis, size, and color of the y-axis labels.
3.6.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.
3.6.3. Decimal place
Specify the number of digits to display after the decimal point.
3.6.4. Padding
Set the spacing between the y-axis title and labels.
3.6.5. Prefix/Suffix
Specify a prefix or suffix for your y-axis labels.
3.6.6. Width
You can customize the width of the y-axis labels.
3.7. Axis line
Set the width and color of the axis line.
3.8. Grid line
Enable or disable grid lines using the toggle. You can customize the Y-axis gridline style, thickness, and color.
3.9. Show slider
Filter y-axis values and focus on specific data ranges by enabling the slider.
4. Datatable settings
You can view your charts as well as the underlying data in a single window
4.1. Enable data table
Turn on this toggle to display the data table.
4.2. Show as
4.3. Legend key
The measure names will be hidden when you disable the Legend Key toggle.
4.4. Text format
Display the measure names using IBCS notations or use the names from the dataset.
4.5. Font
Customize the font and color of the data.
4.6. Grid line
Enable and customize borders for the table.
Last updated