I. Overview
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, flashing animation can be set for a certain series, category or value.
| You will learn |
|---|
|
II. Operation steps
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 [Flashing Animation]
2) You can click to delete the label attribute
3) Only the cycle need to be set, the default is 2.8 seconds
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 flashing animation will appear in dessert series