---
metadata:
  - name: generator
    content: Diplodoc Platform v5.63.0
alternate:
  - en/visualization-ref/normalized-bar-chart
  - ru/visualization-ref/normalized-bar-chart
  - href: en/visualization-ref/normalized-bar-chart.md
    type: text/markdown
    title: Markdown version
csp:
  - script-src:
      - https://mc.yandex.ru
    img-src:
      - https://mc.yandex.ru
    connect-src:
      - https://mc.yandex.ru
      - wss://mc.yandex.ru
    child-src:
      - 'blob:'
      - https://mc.yandex.ru
    frame-src:
      - 'blob:'
      - https://mc.yandex.ru
    frame-ancestors:
      - 'blob:'
      - https://mc.yandex.ru
canonical: en/visualization-ref/normalized-bar-chart.html
title: Normalized bar chart in DataLens On-premises
description: >-
  In this tutorial, you will learn how to create and customize the normalized
  bar chart visualization type in DataLens On-premises.
vcsPath: en/visualization-ref/normalized-bar-chart.md
---

# Normalized bar chart <!-- diplodoc:svg ![](../_assets/datalens/normalized-horizontal-bar.svg) --><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"><g fill="none" fill-rule="evenodd" transform="rotate(90 16.5 12.5)"><rect width="4" height="5.5" x="8" y="18.5" fill="#1A82E3" rx="1"/><rect width="4" height="7.5" x="8" y="10" fill="#FC4F51" rx="1"/><rect width="4" height="9.5" x="14" y="14.5" fill="#1A82E3" rx="1"/><rect width="4" height="3.5" x="14" y="10" fill="#FC4F51" rx="1"/><rect width="4" height="14" x="20" y="10" fill="#1A82E3" rx="1"/></g></svg> in DataLens On-premises

A normalized bar chart shows the contribution, as a percentage, of multiple measures in the total amount by period or category.

* Unlike a [stacked bar chart](bar-chart.md##stacked), the proportion of segment ratios and not the total bar length is important for this type of chart.

* Segments are highlighted in different colors and located one after the other. The length of a segment indicates its ratio to the total amount represented as 100%.


    {% cut "Percentage of expenses in the annual budget" %}

    {% list tabs %}

    - Visualization

        ![normalized-horizontal-bar-chart](../_assets/datalens/visualization-ref/normalized-horizontal-bar-chart/normalized-horizontal-bar-chart.png =800x)

    - Source table

        Month |	Gasoline | Rent  | Food | Utility bills
        ----- | ---------| ---------- | ---------- | ---------- 
        January 2019	| 100	| 600	| 300	| 500
        February 2019	| 150	| 600	| 250	| 700
        March 2019	| 100	| 600	| 450	| 400
        April 2019	| 120	| 600	| 370	| 510
        May 2019	| 100	| 600	| 300	| 530
        June 2019	| 130	| 600	| 310	| 600
        July 2019	| 150	| 600	| 330	| 510
        August 2019	| 120	| 600	| 250	| 550
        September 2019	| 110	| 650	| 380	| 500
        October 2019	| 120	| 650	| 300	| 550
        November 2019	| 130	| 650	| 310	| 540
        December 2019	| 100	| 650	| 400	| 550

    {% endlist %}

    {% endcut %}


    {% cut "Percentage of payment types across product subcategories." %}

    {% list tabs %}

    - Visualization

        ![normalized-horizontal-bar-chart-categories](../_assets/datalens/visualization-ref/normalized-horizontal-bar-chart/normalized-horizontal-bar-chart-categories.png =800x)

    - Source table

        Subcategory |	Delivery |	Pickup
        -------------|---------| ----------|
        Beauty and health products |	615K |	373K
        Kitchenware |	1,929K |	1,005K
        Kitchen products |	1,217K |	759K
        Detergents |	1,210K |	803K
        Health and beauty equipment |	2,046K |	1,380K
        Non-essential goods |	1,368K |	894K
        Cleaners |	1,237K |	673K

    {% endlist %}

    {% endcut %}

* A normalized bar chart shows the contribution, as a percentage, of each category in the total measure value over a time interval. 

    {% cut "Sales percentage for different product categories" %}

    {% list tabs %}

    - Visualization

        ![normalized-horizontal-bar-chart-2](../_assets/datalens/visualization-ref/normalized-horizontal-bar-chart/normalized-horizontal-bar-chart-2.png =800x)

    - Source table

        Month |	Home appliances |	Household goods  | Household cleaners
        ----- | ---------| ---------- | ---------- 
        January 2019|	128K |	55K | 26K
        February 2019|	97K |	79K | 18K
        March 2019|	187K |	105K | 41K
        April 2019|	188K | 137K | 34K
        May 2019|	230K |	121K | 43K
        June 2019|	256K |	162K | 59K
        July 2019|	284K |	206K | 67K
        August 2019|	409K |	204K | 72K
        September 2019|	314K |	209K | 86K
        October 2019|	324K |	262K | 79K
        November 2019|	385K |	238K | 101K
        December 2019|	451K |	307K | 111K

    {% endlist %}

    {% endcut %}


## Wizard sections {#wizard-sections}

Wizard<br/> section| Description
----- | ----
Y | Dimensions. You can specify one or two dimensions. For the `Date` and `Date and time` types, you can set grouping by time: minutes, hours, weeks, and so on.
X | Measure. You can specify multiple measures. If you add more than one measure to a section, the **Colors** section will contain a dimension named [Measure Names](../concepts/chart/measure-values.md). You can move [Measure Names](../concepts/chart/measure-values.md) to the Y axis.
Colors | [Measure Names](../concepts/chart/measure-values.md) dimension or field. Affects the color of lines. To remove [Measure Names](../concepts/chart/measure-values.md), delete measures from the Y axis.
Sorting | Dimension or measure. Affects the column sorting. The sorting direction is marked with an icon next to the field: <!-- diplodoc:svg ![image](../_assets/console-icons/bars-ascending-align-left.svg) --><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="none" viewBox="0 0 16 16"><path fill="currentColor" fill-rule="evenodd" d="M1 12.75c0 .414.336.75.75.75h12.5a.75.75 0 0 0 0-1.5H1.75a.75.75 0 0 0-.75.75M1 8c0 .414.336.75.75.75h8.5a.75.75 0 0 0 0-1.5h-8.5A.75.75 0 0 0 1 8m.75-4a.75.75 0 0 1 0-1.5h2.5a.75.75 0 0 1 0 1.5z" clip-rule="evenodd"/></svg> for ascending or <!-- diplodoc:svg ![image](../_assets/console-icons/bars-descending-align-left.svg) --><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="none" viewBox="0 0 16 16"><path fill="currentColor" fill-rule="evenodd" d="M1 3.25a.75.75 0 0 1 .75-.75h12.5a.75.75 0 0 1 0 1.5H1.75A.75.75 0 0 1 1 3.25M1 8a.75.75 0 0 1 .75-.75h8.5a.75.75 0 0 1 0 1.5h-8.5A.75.75 0 0 1 1 8m.75 4a.75.75 0 0 0 0 1.5h2.5a.75.75 0 0 0 0-1.5z" clip-rule="evenodd"/></svg> for descending. To change the sorting direction, click the icon.
Labels | Measure. Displays measure values on the chart. If multiple measures are added to the **Y** section, drag [Measure Values](../concepts/chart/measure-values.md) to this section. [Markup functions](../function-ref/markup-functions.md) are supported. For `String` type fields, you can configure using basic [Markdown in DataLens On-premises](../dashboard/markdown.md) syntax: click the icon before the field name and enable **Markdown**.
Filters | Dimension or measure. Used as a filter.

## Creating a normalized bar chart {#create-diagram}

To create a normalized bar chart:


<!-- source: en/_includes/datalens/operations/datalens-workbooks-collections-note-step4.md -->
{% note warning %}

If you use the new DataLens object model with [workbooks and collections](../workbooks-collections/index.md):


1. Go to the DataLens home page.


1. Open the workbook, click **Create** in the top-right corner, and select the object you need.

Follow the guide from step 4.

{% endnote %}
<!-- endsource: en/_includes/datalens/operations/datalens-workbooks-collections-note-step4.md -->


1. <!-- source: en/_includes/datalens/visualization-ref/create-1.md -->
   Go to the DataLens home page.
   <!-- endsource: en/_includes/datalens/visualization-ref/create-1.md -->
1. <!-- source: en/_includes/datalens/visualization-ref/create-2.md -->
   In the left-hand panel, select <!-- diplodoc:svg ![chart](../_assets/console-icons/chart-column.svg) --><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="none" viewBox="0 0 16 16"><g clip-path="url(#svg-vsf75jdc__a)"><path fill="currentColor" fill-rule="evenodd" d="M11.5 3.5h2a.5.5 0 0 1 .5.5v8a.5.5 0 0 1-.5.5h-2a.5.5 0 0 1-.5-.5V4a.5.5 0 0 1 .5-.5m-2.5 9a.5.5 0 0 0 .5-.5V7a.5.5 0 0 0-.5-.5H7a.5.5 0 0 0-.5.5v5a.5.5 0 0 0 .5.5zm-4.5 0A.5.5 0 0 0 5 12v-2a.5.5 0 0 0-.5-.5h-2a.5.5 0 0 0-.5.5v2a.5.5 0 0 0 .5.5zm-1 1.5h-1a2 2 0 0 1-2-2v-2a2 2 0 0 1 2-2h2q.26 0 .5.063V7a2 2 0 0 1 2-2h2q.26 0 .5.063V4a2 2 0 0 1 2-2h2a2 2 0 0 1 2 2v8a2 2 0 0 1-2 2z" clip-rule="evenodd"/></g><defs><clipPath id="svg-vsf75jdc__a"><path fill="currentColor" d="M0 0h16v16H0z"/></clipPath></defs></svg> **Charts**.
   <!-- endsource: en/_includes/datalens/visualization-ref/create-2.md -->
1. <!-- source: en/_includes/datalens/visualization-ref/create-3.md -->
   Click **Create chart** → **Chart**.
   <!-- endsource: en/_includes/datalens/visualization-ref/create-3.md -->
1. <!-- source: en/_includes/datalens/visualization-ref/create-4.md -->
   At the top left, click <!-- diplodoc:svg ![image](../_assets/console-icons/circles-intersection.svg) --><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="none" viewBox="0 0 16 16"><path fill="currentColor" fill-rule="evenodd" d="M6.576 11.854a4 4 0 1 1 0-7.707A5.48 5.48 0 0 0 5 8c0 1.5.601 2.861 1.576 3.854M8 12.9a5.5 5.5 0 1 1 0-9.8 5.5 5.5 0 1 1 0 9.8m1.424-8.754A4.003 4.003 0 0 1 14.5 8a4 4 0 0 1-5.076 3.854A5.48 5.48 0 0 0 11 8c0-1.5-.601-2.861-1.576-3.854M8 4.877C8.914 5.61 9.5 6.737 9.5 8s-.586 2.39-1.5 3.123A4 4 0 0 1 6.5 8c0-1.263.586-2.39 1.5-3.123" clip-rule="evenodd"/></svg> **Select dataset** and specify the dataset to visualize. If you do not have a dataset, [create one](../dataset/create-dataset.md#create).
   <!-- endsource: en/_includes/datalens/visualization-ref/create-4.md -->
1. Select **Normalized bar chart** as the chart type.
1. Drag one or more dimensions from the dataset to the **Y** section. The values will be displayed on the Y axis.
1. Drag one or more measures from the dataset to the **X** section.
1. Drag a dimension from the dataset or the [Measure Names](../concepts/chart/measure-values.md) field to the **Color** section.

## Recommendations {#recomendations}

* <!-- source: en/_includes/datalens/datalens-category-text.md -->
  **Labels.** If the category values are too verbose, make them shorter so that the chart labels look neater.

  You can use string functions in calculated fields or the [CASE](../function-ref/CASE.md) conditional statements.
  <!-- endsource: en/_includes/datalens/datalens-category-text.md -->
* **Segments.** Do not display more than three to five segments on the chart.
* <!-- source: en/_includes/datalens/visualization-ref/colors.md -->
  Dimension or measure. It affects the intensity of point fill.
  <!-- endsource: en/_includes/datalens/visualization-ref/colors.md -->

<!-- source: en/_includes/datalens/visualization-ref/see-also-sub.md -->
#### Useful links {#see-also}

* [Creating a dashboard in DataLens On-premises](../operations/dashboard/create.md)
* [Adding a chart to a dashboard in DataLens On-premises](../operations/dashboard/add-chart.md)
* [Adding a selector to a dashboard in DataLens On-premises](../operations/dashboard/add-selector.md)
<!-- endsource: en/_includes/datalens/visualization-ref/see-also-sub.md -->