# Format Tab

## **Ranking**

<figure><img src="https://2952853741-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL502qSSR9Gd1FbZtxvCe%2Fuploads%2FVTZSMc690J5IOsQQfXla%2Fimage.png?alt=media&#x26;token=6393f68b-1b2a-4f7a-a343-b0a62385db2b" alt=""><figcaption></figcaption></figure>

* **Ranking Toggle**: Enable or disable ranking.
* **Ranking**: Specify whether to rank **Top** or **Bottom** values.
* **Ranking Count**: Define the number of ranked items.
* **Ranking By**: Select the field used for ranking.

## **Sort**

<figure><img src="https://2952853741-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL502qSSR9Gd1FbZtxvCe%2Fuploads%2FDNCmB7nBorLiCxRftBah%2Fimage.png?alt=media&#x26;token=8e282495-ba3f-422a-bb0f-7cdb7908071d" alt=""><figcaption></figcaption></figure>

* **Default**: Use the default sort order.
* **Ascending**: Sort in ascending order by the selected field.
* **Descending**: Sort in descending order by the selected field.

## **Legends**

<figure><img src="https://2952853741-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL502qSSR9Gd1FbZtxvCe%2Fuploads%2FDhagJw5eDVNdn1BTSdXf%2Fimage.png?alt=media&#x26;token=efc2469f-7017-4e50-9583-21c02a7e9dd0" alt=""><figcaption></figcaption></figure>

* **Legends Toggle**: Enable or disable legends.
* **Position**: Choose the legend position (e.g., Bottom Left, Top Center, etc.).
* **Size**: Adjust the legend size.
* **Color**: Set the legend text color.

## **Axis**

<figure><img src="https://2952853741-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL502qSSR9Gd1FbZtxvCe%2Fuploads%2FAojon0aNBxLzM6P4mzR2%2Fimage.png?alt=media&#x26;token=d655cf6c-c3e8-40bb-8821-e260943d6a90" alt=""><figcaption></figcaption></figure>

**Y-Axis**

* **Toggle On/Off**: Show or hide the Y-axis.
* **Title Checkbox**: Enable or disable the axis title.
* **Labels Toggle**: Show or hide Y-axis labels.
* **Size**: Adjust the font size for labels.
* **Color**: Define the label color.

**X-Axis**

* **Toggle On/Off**: Show or hide the X-axis.
* **Title Checkbox**: Enable or disable the axis title.
* **Labels Toggle**: Show or hide X-axis labels.
* **Size**: Adjust the font size for labels.
* **Color**: Set the label color.
* **Auto X-Axis Value**: Automatically adjust the axis scale.

## **Gridlines**

<figure><img src="https://2952853741-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL502qSSR9Gd1FbZtxvCe%2Fuploads%2FBjku5yRwkovjZrteOFDG%2FPBIDesktop_4y3DZpoDj5.png?alt=media&#x26;token=6f4fe986-322d-4ad6-aed2-637e6c52f023" alt=""><figcaption></figcaption></figure>

**Y-Axis**

* **Toggle On/Off**: Enable or disable Y-axis gridlines.
* **Line Style**: Choose from various line styles (e.g., Solid, Dash, Dot).
* **Width**: Adjust the gridline thickness.
* **Color**: Set the gridline color.

**X-Axis**

* **Toggle On/Off**: Enable or disable X-axis gridlines.
* **Line Style**: Choose from various line styles (e.g., Solid, Dash, Dot).
* **Width**: Adjust the gridline thickness.
* **Color**: Define the gridline color.

## Data Labels

<figure><img src="https://2952853741-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL502qSSR9Gd1FbZtxvCe%2Fuploads%2FczDWyjqHQR3b39WIKycE%2Fimage.png?alt=media&#x26;token=fef3e7cf-500e-400f-b812-ee3107e8cea5" alt=""><figcaption></figcaption></figure>

The **Data Labels** section provides customization options for displaying and styling data labels on the chart, ensuring clear and meaningful representation of data values. Below are the available settings:

***

**Size**

Adjust the size of the data labels to suit your chart design and improve readability.

***

**Position**

Determine where the data labels appear on the chart:

* **Auto**: Automatically decides the optimal position for labels.
* **Inside End**: Places the labels inside the bar at the end.
* **Outside End**: Positions the labels outside the bar at the end.
* **Inside Center**: Centers the labels inside the bar.

***

**Auto Color Toggle**

Enable this option to automatically adjust the label color for better visibility against varying bar colors.

***

**Styling**

Customize the appearance of the data labels with the following formatting options:

* **Bold**: Apply bold text formatting.
* **Italic**: Add italicized styling for a refined look.
* **Underline**: Underline the text for emphasis.

***

**Hide "0"/Null Values**

Hide data labels for values that are "0" or null to maintain a clean and uncluttered chart.

## **Number Formatting**

<figure><img src="https://2952853741-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL502qSSR9Gd1FbZtxvCe%2Fuploads%2FqGOy3F3ZdyiikTC0iaae%2Fimage.png?alt=media&#x26;token=4c9b4c6a-77b8-4030-841d-9730b63d7230" alt=""><figcaption></figcaption></figure>

* **Display Unit**: Select the unit for displaying values (e.g., Thousand, Million, etc.).
* **Prefix**: Add a prefix to the displayed values.
* **Suffix**: Add a suffix to the displayed values.
* **Decimals**: Set the number of decimal places.
* **+Format**: Choose between `123` or `+123` for positive values.
* **-Format**: Choose between `-123` or `(123)` for negative values.
* **Percentage Checkbox**: Display values as percentages.
* **Comma Checkbox**: Add commas to separate large numbers.
* **Hide Null Values Checkbox**: Enable or disable the display of null values.
* **Display Null Values As**: Choose to display null values as **Zero**, **Null**, or **Blank**.

## **Global Options**

<figure><img src="https://2952853741-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL502qSSR9Gd1FbZtxvCe%2Fuploads%2F9VXDbcHe0KCBNLyrF7UE%2Fimage.png?alt=media&#x26;token=1b9c1b41-8ebc-4f14-a114-15a1a0af27a5" alt=""><figcaption></figcaption></figure>

* **Font Family**: Select a font family for text elements.
* **Styling (B/I/U)**: Apply **Bold**, **Italic**, or **Underline** styling.
* **Show Tooltip**: Enable or disable tooltips on hover.