More customizations of Tables and Charts

Conditional format rules for Table and Pivot table

• To highlight your data cell with color, click on the Conditional format rules button in Settings.

• Click on the Add rule button then the + Add variant dropdown to choose the type you want to make the format rule.

• Fill the input and select the color for each variant.

• You can choose the Except option, except from the selected column, the format rules shall apply to all other columns

• You can choose the Only option, only from the selected column will be bound to the format rule.

• You can edit the format rules by clicking on the 🖊️ icon.

• You can delete the format rules by clicking on the 🗑️icon.

• You can create multiple format rules.

• Drop and darg the rules to prioritize them.

Remember to Save changes if you have finished your customization.

Color palette

• Click on the Color option on the Properties.

• Click on the Palette dropdown to see the available palette.

• Click on the palette to change the chart color palette.

• You can change the specific color by clicking directly on a Bar, Line, or Pie chart.

Other options in Bar and Pie charts

• You can show the value, rotate the label, or change the label size.

• The same action is used to show value on the Line or Pie chart.