Change The Attributes of Lines or Markers in a Line Chart

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:

1.Prepare data

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

2. Insert chart

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

3.Binding data

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

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:

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:

2）Mobile

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:

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:

2）Effect preview

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

Click to download the template:

Change the line color according to conditions.cpt

Custom point attributes.cpt

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.