# More customizations of Tables and Charts

## Conditional format rules for Table and Pivot table

<figure><img src="/files/Sk6R3uP1A5tbsmMSsGXM" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/lsVY0HLoYpTpo6iahdZt" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/iDgDTJ2MA3VA47STCL0B" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/p9K3Rw5I8tJigYcyfGtr" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/YqR57RhBZClMC6n5nHfV" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/QWWO416LOaridkbOzcDY" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/4JFtkaSJM752bz0aUi3l" alt=""><figcaption></figcaption></figure>

* You can edit the format rules by clicking on the :pen\_ballpoint: icon.
* You can delete the format rules by clicking on the :wastebasket:icon.

<figure><img src="/files/UYyNV0Cxl8a0rtAesiMP" alt=""><figcaption></figcaption></figure>

* You can create multiple format rules.
* Drop and darg the rules to prioritize them.

{% hint style="info" %}
Remember to Save changes if you have finished your customization.
{% endhint %}

## Color palette

<figure><img src="/files/0ba6XkF8MAroBfvc5XS5" alt=""><figcaption></figcaption></figure>

* Click on the Color option on the Properties.

<figure><img src="/files/BGwpZ5NmhkCDaPY2lJSf" alt="" width="563"><figcaption></figcaption></figure>

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

<figure><img src="/files/JmNEwxHtAYALJ4pImju2" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/cZsR4TzHA8Qp2c8PDW5m" alt=""><figcaption></figcaption></figure>

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

## Other options in Bar and Pie charts

<figure><img src="/files/zoEZc7eiax5dnX6nhgdK" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/AniNRD7GNhOASpqQQXjJ" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/vmLF9AyqIURriobHariY" alt=""><figcaption></figcaption></figure>

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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/docs/dashboard/more-customizations-of-tables-and-charts.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.