Successfully!

Error!

Change The Attributes of Lines or Markers in a Line Chart

  • Last update:  2021-03-04
  • I. Overview

    By setting condition attributes, you can change the attributes of the line or marker point of the line graph. If you change the color of the line in a certain interval, the effect is as shown in the figure below:

    1614853221743507.png

    II. Change the color of the interval line

    1.Prepare data


    Create a new built-in data set Embedded1, as shown in the figure below:

    1614853520797120.jpg

    2. Insert chart


    Merge a range of cells and insert a line chart, as shown in the figure below:

    1614853595704277.jpg

    3.Binding data


    Bind the line chart data, as shown in the following figure:

    4.jpg

    4. Setting condition attribute


    Added the color matching condition attribute to realize that when the sales volume is greater than 0, the line is set to red, as shown in the following figure:

    1614853764731774.jpg

    Note 1: The line corresponds to the interval. You cannot use equal to in the condition setting of the condition attribute. Only interval symbols, such as greater than or equal to, are supported.

    Note 2: The above implementation is that when the sales volume is greater than 0, the line is set to red. The normal condition is that the value is greater than or equal to 1. If it is greater than 0, there will be bugs, so currently only the closed interval setting conditions are supported.


    5. Effect preview


    1)PC terminal

    Save the report, click the pagination preview, the interval line where the sales volume is greater than 0 turns red, as shown in the following figure:

    1614854250651705.png

    2)Mobile

    1614854511808436.jpg

    III.Customize point attributes

    Except for the condition attribute, the other settings are the same as the example above for changing the color of the interval line. The following only introduces the setting of the condition attribute.

    1. Set condition attributes


    The condition attribute of the marker point is added, and the shape of the marker point whose sales is equal to 0 is diamond, the color is red, and the radius is 4.5, as shown in the following figure:

    1614854825819043.jpg

    2.Effect preview


    1)PC terminal

    Save the report, click the page to preview, the custom style of the marker point is as shown in the figure below:

    1614854927404928.jpg

    2)Effect preview

    1614854979375560.jpg

    Note: There is no symbol restriction when setting conditions for marker points.

    IV.Template download

    V.Matters needing attention

    The line type in the condition attribute corresponds to a whole series of connections, and does not support setting the interval or the line type of a certain value.

    Attachment List


    Theme: Chart
    • Helpful
    • Not helpful
    • Only read

    Doc Feedback