# How to create grafana multiple bar chart

**URL:** <https://community.grafana.com/t/how-to-create-grafana-multiple-bar-chart/87254>\
**Category:** Time Series Panel\
**Created:** [May 8, 2023, 4:08pm UTC](https://community.grafana.com/t/how-to-create-grafana-multiple-bar-chart/87254 "2023-05-08T16:08:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![eladbren](https://avatars.discourse-cdn.com/v4/letter/e/a4c791/32.png) [@eladbren](https://community.grafana.com/u/eladbren)\
**Post date:** [May 8, 2023, 4:08pm UTC](https://community.grafana.com/t/how-to-create-grafana-multiple-bar-chart/87254/1 "2023-05-08T16:08:59Z")

</div>

Hi,

im trying to create grafana with multiple bar chart and failed to do so.  
my goal is like that -  
X-Axis will present test name and Y-Axis the results for the test fir each version.  
something like that -  
 ![image](https://us1.discourse-cdn.com/grafana/original/3X/3/4/34ef7e9b45d4dad8d146e8320a8f718ada8a08b8.png)  
no mater which SQL i used, i failed to get this, any advise / guide will be appreciate.

---

<div class="post-metadata">

**Author:** ![davidallen5](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/davidallen5/32/32092_2.png) [@davidallen5](https://community.grafana.com/u/davidallen5)\
**Post date:** [May 8, 2023, 7:37pm UTC](https://community.grafana.com/t/how-to-create-grafana-multiple-bar-chart/87254/2 "2023-05-08T19:37:33Z")

</div>

Welcome @eladbren !

There’s a really great YouTube tutorial that goes over how to create a multi-series Grafana bar chart. In the video he shows you the original source data, what the panel expects, and how to wire things together. Hope this helps

[![](https://img.youtube.com/vi/ky78RZ2f7oc/hqdefault.jpg "Grafana - Bar Chart with Multiple Series | How To Tutorial Example") ](https://www.youtube.com/watch?v=ky78RZ2f7oc)

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [May 8, 2023, 7:49pm UTC](https://community.grafana.com/t/how-to-create-grafana-multiple-bar-chart/87254/3 "2023-05-08T19:49:39Z")

</div>

Welcome

What version of grafana are you using?  
What data source are you using?  
Please share your query?

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/c/c/cc2ecbac23fd16d1a1fea2f0035d27cde5948ee8.png)

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/b/d/bd18e95719e324f9c39ae4e7472004993c9dbb15.png)

---

<div class="post-metadata">

**Author:** ![eladbren](https://avatars.discourse-cdn.com/v4/letter/e/a4c791/32.png) [@eladbren](https://community.grafana.com/u/eladbren)\
**Post date:** [May 9, 2023, 6:27am UTC](https://community.grafana.com/t/how-to-create-grafana-multiple-bar-chart/87254/4 "2023-05-09T06:27:46Z")

</div>

Hi

Version 9.4.7

My data source code is PostgreSQL

And this is my query –

with elad as(

select throughput, version, test\_name, gw\_ip, gw\_name, gw\_model,

dense\_rank() over( partition by version order by throughput desc)

as “rank” from test\_results tr where test\_name= ‘waf\_krp\_https\_gen1’

)

select distinct version, throughput, test\_name, gw\_ip, gw\_name, gw\_model

from elad

where rank= 1 and gw\_model = ‘X8520’ order by version ASC

thanks,

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [May 9, 2023, 11:36am UTC](https://community.grafana.com/t/how-to-create-grafana-multiple-bar-chart/87254/5 "2023-05-09T11:36:36Z")

</div>

What does the result of that query look like in pgadmin?