# Bar Gauge Panel with 0 in the middle, negative left

**URL:** <https://community.grafana.com/t/bar-gauge-panel-with-0-in-the-middle-negative-left/130285>\
**Category:** Bar Gauge Panel\
**Created:** [September 4, 2024, 7:00am UTC](https://community.grafana.com/t/bar-gauge-panel-with-0-in-the-middle-negative-left/130285 "2024-09-04T07:00:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![DominikReber](https://avatars.discourse-cdn.com/v4/letter/d/f14d63/32.png) [@DominikReber](https://community.grafana.com/u/DominikReber)\
**Post date:** [September 4, 2024, 7:00am UTC](https://community.grafana.com/t/bar-gauge-panel-with-0-in-the-middle-negative-left/130285/1 "2024-09-04T07:00:59Z")

</div>

Hello  
I want to create a bar gauge where 0 is in the middle (excess power in a PV), -10000 on the left and +10000 on the right.

But - when I have a value of 0, I want the bar to show nothing. When I have -5000, I want the bar starting in the middle and showing from 0 to the left to -5000.

Is it possible?

CoPilot tells me to do this:  
" \* **Bar orientation** : Adjust the bar orientation so that negative values extend to the left. You can do this in the **“Display”** section by setting the **“Orientation”** to **“Horizontal”** and ensuring the **“Reverse”** option is enabled for negative values."  
but I cannot find this reverse option

Thanks

---

<div class="post-metadata">

**Author:** ![orosolido](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/orosolido/32/48789_2.png) [@orosolido](https://community.grafana.com/u/orosolido)\
**Post date:** [September 4, 2024, 8:42am UTC](https://community.grafana.com/t/bar-gauge-panel-with-0-in-the-middle-negative-left/130285/2 "2024-09-04T08:42:54Z")

</div>

@DominikReber  
You mean something like this?? For this you can use the ‘Bar Chart’ Plugin

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

Its covers most of your criteria but not all.

---

<div class="post-metadata">

**Author:** ![cschlipf](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/cschlipf/32/49871_2.png) [@cschlipf](https://community.grafana.com/u/cschlipf)\
**Post date:** [October 26, 2024, 5:24pm UTC](https://community.grafana.com/t/bar-gauge-panel-with-0-in-the-middle-negative-left/130285/3 "2024-10-26T17:24:23Z")

</div>

I was able to get this with the bar chart plugin. Result:

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

What I have done:

- Created multiple queries for each data channel just like in a bar gauge. Important here is that the query selects just the last value from the resulting time series:  

- As a workaround, added another query that just returns any value. We need it later to get rid of the time dimension:  

- Add a ‘Reduce’ and a ‘Rows to fields’ transformation like this:  

- In the Bar Charts options:

Hope this helps.