# Formatting

## Chart Formatting

Select a chart on the Vizpad, then click **Format** in the right rail to open the **Chart formatting panel**. The panel is organized into three groups: **Chart Style, Numbers and Labels**, and **Other**. Hovering over any option reveals a short description of what each option controls. At the bottom of the panel, **Apply** commits your changes to the chart and **Revert** undoes them. A search bar at the top of the panel lets you jump straight to a setting by name.

<figure><img src="/files/X3sxEsEteH2JOSmL0Tal" alt="" width="375"><figcaption></figcaption></figure>

{% hint style="warning" icon="eye" %}
The formatting options shown in the panel are context-sensitive. They change depending on the type of chart or table you have selected. For example, a table (standard, pivot, or detailed) will show table-specific options like **Text formatting, Column settings, Values alignment**, and **Pinned columns**. The sections below cover both chart formatting and table formatting.
{% endhint %}

### **Chart Style**

* **Title**: Edit the title text, font weight, font size, and color of your chart. Toggle **Display chart title** off to hide the title entirely.&#x20;

<figure><img src="/files/4xAK6qThGBzUQFYXnWyf" alt="" width="266"><figcaption></figcaption></figure>

* **Background**: Set the chart background color so it matches the surrounding theme/ your branding theme or improves contrast against the canvas.&#x20;

<figure><img src="/files/2WuTQCy1MDCSKoStIG4o" alt="" width="268"><figcaption></figcaption></figure>

* **Chart colours:** Control the color palette used to render your chart's data series. The Color style dropdown determines the type of palette, and each style surfaces a different set of named palettes to choose from under Select colour palette. The five color styles serve different analytical purposes:

<figure><img src="/files/3j2tN1sfMhOkX48xayOj" alt="" width="268"><figcaption></figcaption></figure>

* **Default**: A general-purpose multi-hue palette designed to work across most chart types. Use Default when your chart has unrelated categories that don't carry an inherent order or direction.
* **Sequential**: A single-hue gradient that progresses from light to dark. Sequential palettes are designed for data that has a natural low-to-high ordering, such as revenue bands, population density, or intensity scores.
* **Diverging**: A two-tone gradient that moves from one color through a neutral midpoint to a contrasting color. Sesigned for data that has a meaningful center point (such as profit vs. loss, above vs. below target, or positive vs. negative sentiment).
* **Categorical**: A high-contrast multi-hue palette optimized for charts with many distinct categories. Use **Categorical** when your chart has a large number of unrelated groups (such as product SKUs, department names, or region codes) and you need every group to stand out clearly.

{% hint style="info" %}
When you click on a palette to select it, the expanded view shows a **Reverse** button in the top-right corner. Clicking **Reverse** flips the order of colors in the palette (for example, a Sequential palette that normally runs light-to-dark will run dark-to-light instead).
{% endhint %}

* **Customized Diverging:** A continuous gradient rendered as a smooth color ramp. Works similarly to **Diverging** but produce smoother transitions, making them well suited for heatmaps, and any chart where values are distributed across a wide continuous range and you want the color transition to feel gradual rather than stepped.

{% hint style="info" icon="stairs" %}
When you select a **Customized Diverging** palette, the expanded view includes a **Stepped Color** toggle. When enabled, Tellius converts the smooth continuous gradient into a fixed number of discrete color steps, and a **number of steps** field appears below the toggle so you can specify exactly how many steps to use. Use stepped color when you want clear visual boundaries between value ranges (such as bins in a heatmap) rather than a smooth blend where differences between adjacent values can be hard to perceive.
{% endhint %}

<figure><img src="/files/Q3b9NJDvjpfZQ9X215YK" alt="" width="169"><figcaption></figcaption></figure>

After selecting a color style, scroll through the available palettes and select one to apply it on your chart.&#x20;

### **Numbers and Labels**

* **Number Formatting:** Control how numeric values are displayed. Toggle **Custom formatting** to override the default for one or more measure columns, then configure the
  * Separator (for example, (XXX,XXX) for thousands separators)
  * Decimals (number of decimal places)
  * Abbreviation (Default, K, M, B)
  * Prefix (for example, $ for currency)
  * Suffix (for example, % for percentages).
  * **Force trailing zeros** toggle ensures values like 4.5 display as 4.50 when your decimal setting is 2.
  * Click **Reset to default** to clear all custom formatting and fall back to the chart's native behavior.

<figure><img src="/files/g3pNrvowSlhJtlQHYOCB" alt="" width="273"><figcaption></figcaption></figure>

* **Data Labels:** Customize the inline labels that appear on each data point. Toggle **Display data labels** to show or hide them, then configure font weight, size, and color, and choose an **Orientation** (Horizontal, Vertical) and **Placement** (Inside, Outside) so labels stay readable on dense charts.

<figure><img src="/files/KzEYUlvl2NM0yLlH6ikU" alt="" width="269"><figcaption></figcaption></figure>

* **Axis Labels:** Control how the chart's axes are titled and labeled. Below the titles, the **Axis Labels** section controls the per-tick labels along each axis with their own font and color settings
  * Toggle **X-axis Title** to show or hide the horizontal axis title, and **Y-axis Title** to show or hide the vertical axis title.
  * For each, you can edit the title text directly in the input field, and set the font weight, font size, and color.&#x20;
  * Toggle **X Axis Label** to show or hide the tick labels on the horizontal axis, then set the font weight, font size, and color.
  * The **X-axis label width** toggle, when enabled, lets you cap how much horizontal space each tick label is allowed to occupy. This is useful when your X axis has long category names that would otherwise overlap each other or push into neighboring labels.
  * **Y Axis Label** works the same way for the vertical axis, with its own font weight, font size, color controls and Y-axis label width.

<figure><img src="/files/EC97M8L1k1we5eiCkCuf" alt="" width="276"><figcaption></figcaption></figure>

* **Grid:** Control the appearance of grid lines and the scale of the chart's axes.
  * Toggle **X-axis grid** and **Y-axis grid** independently, and pick a line style (Solid line, Dashed) for each.
  * **Y-axis Ticks** sets the number of tick marks on the Y axis (auto-clamped to 2-100), and **Y-axis Max / Y-axis Min** let you fix the upper and lower bounds of the axis instead of letting Tellius auto-scale. Useful when you want a consistent scale across multiple charts.

<figure><img src="/files/WqT2WwGxg3VU7aJpJ85C" alt="" width="271"><figcaption></figcaption></figure>

* **Legends:** Show or hide the chart legend and control how it looks and where it sits. Toggle **Display legend** to turn the legend on or off.

<figure><img src="/files/ltf7k0CmLHt0xEdUGRz1" alt="" width="268"><figcaption></figcaption></figure>

* Set the font weight (normal, bold), font size, and text color of the legend labels.
* **Position:** Choose where the legend is placed relative to the chart: *Top*, *Bottom*, *Left*, or *Right*.
* **Layout:** Choose *Horizontal* to arrange legend items side by side in a row, or *Vertical* to stack them one per line.
* **Sorting:** Control the order in which legend items appear. *Default* preserves the order determined by the data. You can also sort legend items ascending/descending so the legend matches the visual hierarchy of the chart.

**Text formatting&#x20;**<mark style="color:red;">**(only for tables and detailed tables)**</mark>**:** Controls the typography of all text displayed inside the table. Two separate sets of controls let you style **headers** and **values** independently. For each, set the font weight (normal, bold), font size, and text color.

<figure><img src="/files/WjJzmTcHKskjiBVAmLsS" alt="" width="268"><figcaption></figcaption></figure>

### **Other**

#### Conditional Formatting

<figure><img src="/files/3fd7GHfR1YjkzZwQKR20" alt="" width="268"><figcaption></figcaption></figure>

Apply rules that highlight data based on conditions (for example, color any bar where Registration Total Completed is greater than or equal to 100). Click **Add formatting** button to open the following rule builder:

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

* **When**: Pick the column to evaluate and the condition (Greater than, Less than, Equal to etc.). For numeric columns, Tellius shows the current **Min** and **Max** as a hint so you can choose a relevant threshold.&#x20;
* **Type:** Choose how the comparison value is supplied. **Fixed value** lets you type a specific number. **Column** lets you compare against the values of another column in the chart, so the threshold is dynamic and moves with the data.
* The column picker has two tabs: **VIZ CONFIG** shows only the columns already used in the current chart's configuration (measures and dimensions you've dragged into the chart), while **BV COLUMNS** shows every column available in the underlying Business View.
* **Apply formatting to:** Pick the column whose visual representation should change when the rule triggers. By default this matches the column being evaluated.
* **Formatting**: Choose the Chart color that should be applied when the condition is met.
* Click **Apply** to save the rule. You can stack multiple rules on the same chart, and rules can apply to different columns independently.

#### Benchmark

Add reference lines to your chart so you can instantly compare actual values against a target, baseline, or aggregate. Toggle **Benchmark** on to enable the feature, then click **+ Add benchmark** to create a new reference line.

<figure><img src="/files/bIy9xCcMYVx9k1z49pr0" alt="" width="277"><figcaption></figcaption></figure>

* **Name:** Edit the label that appears on the chart next to the reference line.
* **Value:** Choose how the benchmark value is determined. *Relative* calculates the benchmark from the chart's own data (using the column and aggregation you specify below) and *Fixed* lets you to input the value. Use **Relative** when you want the line to move with the data.
* **Based on raw data:** When enabled, the benchmark is computed from the raw, unaggregated dataset rather than from the already-aggregated values visible in the chart. Enable this when the chart's aggregation (say, a grouped sum) would distort the benchmark.
* **Benchmark column:** Select the measure column the benchmark should be calculated from.
* **Benchmark aggregation:** Choose the aggregation function applied to the selected column.
* **Benchmark line color:** Pick the color of the reference line so it stands out against the chart's data series.

Click **Delete formatting** at the bottom of a benchmark card to remove it. You can add multiple benchmarks to a single chart and each can use a different column, aggregation, and color.

**Summary** <mark style="color:red;">**(only available in Edit mode formatting):**</mark> Displays a quick summary alongside the chart to surface key takeaways. Toggle **Show chart summary** to enable it, then configure:

<figure><img src="/files/flmK2OBH3rgegp71hMyS" alt="" width="268"><figcaption></figcaption></figure>

* **Show:** Choose what to display. *Chart and Summary* shows the table and the summary side by side. *Only the Summary* hides the table entirely and shows just the summary.
* **Summary placement:** Choose where the summary appears relative to the table: *Right*, *Left*, *Top*, or *Bottom*.&#x20;

## Table Formatting

<figure><img src="/files/hgl3lRq78aJ7ila26eV7" alt="" width="363"><figcaption></figcaption></figure>

* **Column:** Configure how column headers behave. The **Show aggregation as suffix** toggle, when enabled, appends the aggregation function to the column header (for example, *Revenue (sum)* instead of just *Revenue*). This is useful when a table contains the same column aggregated in multiple ways (sum and average of Revenue, for instance).
* **Values alignment:** Control the horizontal alignment of cell values by data type. Three alignment options (left, center, right) are available independently for each data type (numbers, text, date):

<figure><img src="/files/LBAFSOxEU5LdgWPmNaeG" alt="" width="269"><figcaption></figcaption></figure>

* **Pinned columns:** Freeze one or more columns to the left edge of the table so they remain visible while you scroll horizontally through the remaining columns. Toggle **Pin columns** to enable the feature, then set **How many columns to pin** (auto-clamped to a maximum of 10). The leftmost columns in the table will be pinned as per the given number.

<figure><img src="/files/c0JlGSmoSLfoYmwR2L2Z" alt="" width="268"><figcaption></figcaption></figure>


---

# 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://help.tellius.com/tellius-6.3/vizpads-explore/actions-in-view-mode/formatting.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.