Chart Custom Single Series Label

1) The conditional display function of the chart provides more possibilities for the final display effect of the chart, and makes the chart have more personalized display forms.

2) The setting method of conditional display of charts is basically the same as that of conditional formatting of cells. It is necessary to define attribute styles and conditions to be met. The chart elements that meet the conditions will display the defined attribute styles in preview.

3) Through conditional display, custom label effect can be set for a certain series, category and value.

1. Insert Chart

1) Insert a floating chart, select [Column Chart], select the first most basic column chart

2) Adjust the chart size

2. Set chart data

1) create a new dataset [ds1]

2) Refer to the figure below to set chart data

3) Set the rotation angle for the label text on the X-axis, so that even if the label text is long, it can be displayed completely

3. Preview

The chart has two series, drinks and desserts, which are displayed in groups according to the corresponding salesperson

4. New conditional display

Select [Special effect]> [Conditional display]. Click [+] to add a condition attribute

5. Set the label attributes

1) Click [+] and select [Label]

2) You can click to delete the label attribute

3) You can set the content, layout and style of the label

6. Set conditions

1) Select [Series Name] for [Optional Column] and [Equal] for [Operator], and fill “Desserts” in the value. Click [+Add] to complete the condition setting

2) Preview, and all the dessert series show labels

7. Modify the label style

1) Drag down the bottom of the scroll bar in the label attribute setting area and set the color of the label text to red

2) Preview, and the dessert series all show red labels