Setting Value Axis in the Chart

  • Last update:  2024-01-16
  • Overview

    Version

    FineBI Version

    Functional Change

    6.0-

    Application Scenario

    In most cases,  the value axis is set on the vertical axis. This document introduces how to configure the parameters of the horizontal axis, such as scale and title.

    Function Description

    You can set the value axis for indicator fields. The Set Value Axis function can help you set the parameters of Shared Axis, Axis Label, Axis Scale, Axis Reverse Order, Logarithmic Axis, and Axis Title, as shown in the following figure.

     1.jpg

    Shared Axis Setting

    The value axis is set to the left-value axis by default. If there are multiple indicator fields, they can be displayed on a shared axis or separate axes.

    For details, see Setting Dual Y-axes of Graphs.

     

    Axis Scale Setting

    You can select Custom to set the maximum, minimum, and interval values of the axis label. The input value can be the maximum, minimum, or average of the current indicator field. You can also directly enter a number or add a formula with operators.

    The following table introduces these settings.

     

    Display Range  Description
     DefaultAutomatically calculates the minimum and maximum values based on the currently displayed data range.
    Dynamic Calculation by Each Dimension   

    Function description: If this function is selected, the axis range of partition values in each dimension is displayed based on the actual values, ensuring that the trend changes in the graph can be clearly observed.

    Effective conditions: When dimension fields are dragged into the vertical axis, the indicator field on the vertical axis will take effect. If this condition is not met, this function will not take effect even if it is selected.

    Custom

    This function allows you to set the minimum, maximum, and interval values of the axis scale.

    Minimum and maximum values refer to the minimum and maximum values within the range displayed on the value axis. It allows you to set the value by formulas. When the minimum value is set greater than the maximum value, the corresponding maximum value is invalid.

    Interval values refer to customized intervals between major scales. For example, you can set the interval value to two million, as shown in the following figure.

    3.jpg


     

    iconNote:
    If you set Value Format in the chart to ten thousand or a hundred million, you still need to enter the value without units when setting the value axis. For example, you must enter 300000000 rather than 3 to represent 300 million.


     

    Axis Label Setting

    You can tick Display Axis Label to decide whether to hide it and set Text Direction and Font Style.

     4.jpg

    Axis Reverse Order Setting

    Tick Axis Reverse Order to display the values of axis labels in reverse order in the chart.

     5.jpg

    Logarithmic Axis Setting

    Tick Logarithmic Axis to use a logarithmic scale. Once you tick the function, axis labels will be displayed in powers of 10.

     6.jpg

    Axis Title Setting

    You can tick Display Axis Title to decide whether to hide it and set Title Name and Font Style.

     7.jpg

    Notes

    If there are multiple indicator fields in the chart, when you click some indicator names to hide them, the values on the vertical axis cannot change dynamically.

    动2.gif

    How can the vertical axis change dynamically as shown in the following figure?

    动1.gif

    You can click the icon xxx, select Set Value Axis from the drop-down list, and delete the maximum value you have set for the vertical axis, as shown in the following figure.

     缺3.jpg

    附件列表


    主题: Visual Components
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy