# How to create composite "Bar horizontal percentage" charts

**URL:** https://discuss.elastic.co/t/how-to-create-composite-bar-horizontal-percentage-charts/376580
**Category:** Kibana
**Created:** [March 31, 2025, 11:33am UTC](https://discuss.elastic.co/t/how-to-create-composite-bar-horizontal-percentage-charts/376580 "2025-03-31T11:33:50Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Michal714](https://avatars.discourse-cdn.com/v4/letter/m/85f322/32.png) [@Michal714](https://discuss.elastic.co/u/Michal714)
#### Post date: [March 31, 2025, 11:33am UTC](https://discuss.elastic.co/t/how-to-create-composite-bar-horizontal-percentage-charts/376580/1 "2025-03-31T11:33:50Z")

</div>

Hi,

I would like to generate a composite "Bar horizontal percentage" chart in Kibana. See PowerPoint version below:

 ![Goal output 2025-03-31](https://us1.discourse-cdn.com/elastic/original/3X/8/8/88376297542b5364f9d64e527bc152b687f347ee.png)

I have tried to reproduce this chart in Kibana by using three different methods. None of the methods have produced satisfactory outputs.

First, I tried to use "Filters" for each of the sub-questions. The problem is that there is only a single input for "horizontal axis", which simply reproduces the same output for each bar chart - i.e., the output for "Water".

Second, I tried to generate separate bar charts and only included a key at the bottom. Although it produced a technically correct result, it was extremely ugly.

Third, I used filters and added layers. Although this produced a technically correct output, Kibana identified the four possible responses as 8\*4 (=32) different responses. The subsequent output was one full iteration of the theme colour, as opposed to eight iterations.

Since there are only four possible responses ("Included in my rent", "Not offered", "I don't know" and "Charged separately"), I do not understand why Kibana identifies 32 possible responses.

I would like to reproduce a composite bar chart that resembles the PowerPoint representation (the first image in this query). Any help would be greatly appreciated.

---

<div class="post-metadata">

### Author: ![Michal714](https://avatars.discourse-cdn.com/v4/letter/m/85f322/32.png) [@Michal714](https://discuss.elastic.co/u/Michal714)
#### Post date: [March 31, 2025, 11:35am UTC](https://discuss.elastic.co/t/how-to-create-composite-bar-horizontal-percentage-charts/376580/2 "2025-03-31T11:35:06Z")

</div>

See first (incorrect) attempt below:

 ![Fail output 1 2025-03-31](https://us1.discourse-cdn.com/elastic/original/3X/0/3/03b6064cc3d2c9aadca050327b590fe877555de4.png)

---

<div class="post-metadata">

### Author: ![Michal714](https://avatars.discourse-cdn.com/v4/letter/m/85f322/32.png) [@Michal714](https://discuss.elastic.co/u/Michal714)
#### Post date: [March 31, 2025, 11:35am UTC](https://discuss.elastic.co/t/how-to-create-composite-bar-horizontal-percentage-charts/376580/3 "2025-03-31T11:35:45Z")

</div>

See second (incorrect) attempt below:

 ![Fail output 2 2025-03-31](https://us1.discourse-cdn.com/elastic/original/3X/9/a/9a4b345d6be4722819a18dbb870f7c6bffc13f97.png)

---

<div class="post-metadata">

### Author: ![Michal714](https://avatars.discourse-cdn.com/v4/letter/m/85f322/32.png) [@Michal714](https://discuss.elastic.co/u/Michal714)
#### Post date: [March 31, 2025, 11:36am UTC](https://discuss.elastic.co/t/how-to-create-composite-bar-horizontal-percentage-charts/376580/4 "2025-03-31T11:36:19Z")

</div>

See third (incorrect) attempt below:

 ![Fail output 3 2025-03-31](https://us1.discourse-cdn.com/elastic/original/3X/a/6/a698843352f529fa3f93018a95673c5e957e4a3a.png)

---

<div class="post-metadata">

### Author: ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)
#### Post date: [March 31, 2025, 1:54pm UTC](https://discuss.elastic.co/t/how-to-create-composite-bar-horizontal-percentage-charts/376580/5 "2025-03-31T13:54:01Z")

</div>

What is the version of the stack used?  
Can you share the mapping of the index?

---

<div class="post-metadata">

### Author: ![Michal714](https://avatars.discourse-cdn.com/v4/letter/m/85f322/32.png) [@Michal714](https://discuss.elastic.co/u/Michal714)
#### Post date: [March 31, 2025, 2:29pm UTC](https://discuss.elastic.co/t/how-to-create-composite-bar-horizontal-percentage-charts/376580/7 "2025-03-31T14:29:52Z")

</div>

Kibana v 8.7.1.

Hopefully, I'm sending the mapping of the index correctly (see below):

```auto
      "For each of these services, which were/are included in your rent or charged separately? \n[Cleaning service for your bedroom]": {
        "type": "text",
        "fields": {
          "keyword": {
            "type": "keyword",
            "ignore_above": 256
          }
        }
      },
      "For each of these services, which were/are included in your rent or charged separately? \n[Electricity]": {
        "type": "text",
        "fields": {
          "keyword": {
            "type": "keyword",
            "ignore_above": 256
          }
        }
      },
      "For each of these services, which were/are included in your rent or charged separately? \n[Laundry]": {
        "type": "text",
        "fields": {
          "keyword": {
            "type": "keyword",
            "ignore_above": 256
          }
        }
      },
      "For each of these services, which were/are included in your rent or charged separately? \n[Organised transport to campus (e": {
        "properties": {
          "g": {
            "properties": {
              " bus or shuttle)]": {
                "type": "text",
                "fields": {
                  "keyword": {
                    "type": "keyword",
                    "ignore_above": 256
                  }
                }
              }
            }
          }
        }
      },
      "For each of these services, which were/are included in your rent or charged separately? \n[Parking]": {
        "type": "text",
        "fields": {
          "keyword": {
            "type": "keyword",
            "ignore_above": 256
          }
        }
      },
      "For each of these services, which were/are included in your rent or charged separately? \n[Student Life Programme (Parties, events etc": {
        "properties": {
          ")]": {
            "type": "text",
            "fields": {
              "keyword": {
                "type": "keyword",
                "ignore_above": 256
              }
            }
          }
        }
      },
      "For each of these services, which were/are included in your rent or charged separately? \n[Water]": {
        "type": "text",
        "fields": {
          "keyword": {
            "type": "keyword",
            "ignore_above": 256
          }
        }
      },
      "For each of these services, which were/are included in your rent or charged separately? \n[Wi-Fi]": {
        "type": "text",
        "fields": {
          "keyword": {
            "type": "keyword",
            "ignore_above": 256
          }
        }
      }

```
