| You will learn |
|---|
|
I. Condition Display Trend Line
1) The conditional display function of charts provides more possibilities for the final presentation of the charts, which makes the chart more personalized.
2) The conditional display of charts and the conditional formatting of cells are set in much the same way, requiring the defining of style of attributes and conditions that need to be met. Chart elements that meet the conditions will display the defined style of attributes under a preview mode.
3) You can set a trend line for a series using the conditional display.
II. Steps
1. Insert chart
1) Insert a floating chart, select [Column Chart], and select the first and most basic column chart.
2) Adjust the size of the chart.
2. Set the data
1) Create a dataset [ds1].
2) Refer to the figure below to set the dataset data.
3) Set Rotating for the label text on the X Axis so that the label text will be displayed in its entirety even if it is long.
3. View the Effect
The chart has 2 series, Beverages and Desserts, and the series are grouped according to corresponding salesperson.
4. New Conditional Display
Select [Special Effect] > [Conditional Display]. Click on [+] to add a new conditional formatting.
5. Set Attributes
1) Click on [+] to select [Trend Line].
2) You can delete the attribute by clicking .
3) You can set the name, style, width, color, available columns and others of trend lines.
6. Set Conditions
1) Select [Series Name] under the [Available Columns] and [Equal to] under the [Operator], and fill in the value: Desserts. Click on [+ Add] to complete the condition setting.
2) Under a preview mode, a trend line for the dessert series appears in the chart.
III. Conditional Display Chart Transparency
1) The conditional display function of charts provides more possibilities for the final presentation of the charts, which makes the chart more personalized.
2) The conditional display of charts and the conditional formatting of cells are set in much the same way, requiring the defining of style of attributes and conditions that need to be met. Chart elements that meet the conditions will display the defined style of attributes under a preview mode.
3) You can set a custom transparency for a series, category or value using the conditional display.
IV. Steps
1. Insert chart
1) Insert a floating chart, select [Column Chart], and select the first and most basic column chart.
2) Adjust the size of the chart.
2. Set the data
1) Create a dataset [ds1].
2) Refer to the figure below to set the dataset data.
3) Set Rotating for the label text on the X Axis so that the label text will be displayed in its entirety even if it is long.
3. View the Effect
The chart has 2 series, Beverages and Desserts, and the series are grouped according to corresponding salesperson.
4. New Conditional Display
Select [Special Effect] > [Conditional Display]. Click on [+] to add a new conditional formatting.
5. Set Attributes
1) Click [+] to select [Opacity].
2) You can delete the attribute by clicking .
3) You can set the opacity to 60%, i.e. 40% transparency.
6. Set Conditions
1) Select [Series Name] under the [Available Columns] and [Equal to] under the [Operator], and fill in the value: Desserts. Click on [+ Add] to complete the condition setting.
2) Under a preview mode, the columns of the dessert series become transparent and you can see the horizontal reference line through the columns.
V. Condition Display Floating Color
1) The conditional display function of charts provides more possibilities for the final presentation of the charts, which makes the chart more personalized.
2) The conditional display of charts and the conditional formatting of cells are set in much the same way, requiring the defining of style of attributes and conditions that need to be met. Chart elements that meet the conditions will display the defined style of attributes under a preview mode.
3) You can set the color to be displayed when the mouse hovers over a series, category or value using the conditional display.
VI. Steps
1. Insert chart
1) Insert a floating chart, select [Column Chart], and select the first and most basic column chart.
2) Adjust the size of the chart.
2. Set the data
1) Create a dataset [ds1].
2) Refer to the figure below to set the dataset data.
3) Set Rotating for the label text on the X Axis so that the label text will be displayed in its entirety even if it is long.
3. View the Effect
The chart has 2 series, Beverages and Desserts, and the series are grouped according to corresponding salesperson.
4. New Conditional Display
Select [Special Effect] > [Conditional Display]. Click on [+] to add a new conditional formatting.
5. Set Attributes
1) Click on [+] to select [Floating Color].
2) You can delete the attribute by clicking .
3) Customize the floating color.
6. Set Conditions
1) Select [Series Name] under the [Available Columns] and [Equal to] under the [Operator], and fill in the value: Desserts. Click on [+ Add] to complete the condition setting.
2) When the mouse hovers over the dessert series under the Preview mode, the column changes to the set floating color.
Previous：Chart Custom Flashing Animation
