> For the complete documentation index, see [llms.txt](https://endash-guidance-docs.gitbook.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://endash-guidance-docs.gitbook.io/docs/dashboard/more-customizations-of-tables-and-charts.md).

# More customizations of Tables and Charts

## Conditional format rules for Table and Pivot table

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FVQBKk7tYVtVcCMlUoLJR%2Fimage.png?alt=media&amp;token=c77d3ecc-a232-486f-b27a-ca299f651af6" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FnUDiyohMr07c8h5txAa3%2Fimage.png?alt=media&amp;token=1bf9b6f1-7bc6-4c32-8b0c-d710dfc61246" 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="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2F3v0ZE6loX3bdRzfyQb60%2Fimage.png?alt=media&amp;token=56501766-b821-4892-9c07-47d4a29ade3f" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FmDKL3etrEkQQVE6Qm60l%2Fimage.png?alt=media&amp;token=84962b7c-affb-4e6c-8bad-7744af377144" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2F9gwPKDotL2ETxbaZAN9b%2Fimage.png?alt=media&amp;token=be16693e-01a8-4a70-8c41-bdc44481c4b1" 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="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FJGFeuQlKzGvqYVxTcLIq%2Fimage.png?alt=media&amp;token=969a6822-f81b-4e5c-9c1b-e30ae585ae18" 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="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2Finu3CSKQh8mBTAIBOxox%2Fimage.png?alt=media&amp;token=7aa14f0d-af6f-45e8-ae06-d13dbc4b6c89" 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="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FDJWmjRTlHQ8O4qeiAM7L%2Fimage.png?alt=media&amp;token=059bbee7-a91e-48b4-9850-b5c2de4d628b" 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="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FPpH3PXZdsuuyp1FPctvr%2Fimage.png?alt=media&amp;token=05ecb4fa-37fc-466e-b44f-0db4d70f8075" alt=""><figcaption></figcaption></figure>

* Click on the Color option on the Properties.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FLsjEvUY5pvpTQAVnQWQR%2Fimage.png?alt=media&amp;token=d735e7e3-4998-4c15-84c5-e1bea1a5fd6b" alt="" width="563"><figcaption></figcaption></figure>

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

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FoFUPhtS4SQSynZiVIdwj%2Fimage.png?alt=media&amp;token=49e825b3-a116-4c14-af1e-005008de9e2c" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FILmkFoVshHxbD9d218ea%2Fimage.png?alt=media&amp;token=a42cfb69-1c22-4607-9189-731cd61ecbf0" 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="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FtJcCb4CINnxV5yYY82ZZ%2Fimage.png?alt=media&amp;token=db506213-31c3-456d-8a31-571352b0e06b" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FN80OtOplEmuaqKxZ4D8H%2Fimage.png?alt=media&amp;token=a3b26b95-04b2-4a47-830c-bf4cdac3b7c0" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FleQBFXAayV1d3DML8FRH%2Fimage.png?alt=media&amp;token=21edad21-8633-4490-83b3-c9e9f4e17ffe" alt=""><figcaption></figcaption></figure>

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