I. Overview
a) 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.
b) 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.
c) With Conditional Display, Fill with Image can be set for a series, category or value of the column chart.
II. Operation steps
1. Insert Chart
a) Insert a floating chart, select [Column Chart], select the first most basic column chart
b) Adjust the chart size
2. Set chart data
a) create a new dataset [ds1]
b) Refer to the figure below to set chart data
c) 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 attributes
a) Click [+] and select [Fill with Image].
b) You can click to delete the attribute.
c) You can select which image is to be filled.
6. Set conditions
a) Select [Series Name] for [Optional Column] and [Equal] for [Operator], and fill “Desserts” in the value. Click [+Add] to complete the condition setting
b) The columns of Deserts are filled with images in preview.