# Stacking "Bar" and "Line" series with same x-value

**URL:** <https://community.grafana.com/t/stacking-bar-and-line-series-with-same-x-value/42469>\
**Category:** Grafana\
**Created:** [February 1, 2021, 8:48am UTC](https://community.grafana.com/t/stacking-bar-and-line-series-with-same-x-value/42469 "2021-02-01T08:48:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kevinlucich](https://avatars.discourse-cdn.com/v4/letter/k/eb9ed0/32.png) [@kevinlucich](https://community.grafana.com/u/kevinlucich)\
**Post date:** [February 1, 2021, 8:48am UTC](https://community.grafana.com/t/stacking-bar-and-line-series-with-same-x-value/42469/1 "2021-02-01T08:48:57Z")

</div>

Hi everyone,

I followed another topic in order to insert two data series in the same panel: one in **bar** and the other in **line**.

Below steps:

> **Custom query:**
> 
> SELECT  
> now() as time,  
> name,  
> AVG(average\_time),  
> MAX(average\_time)  
> FROM \_average\_time  
> WHERE average\_time \> 0  
> GROUP BY 1,2  
> ORDER BY 2

> **Using the “Series overrides”**
> 
> ![Schermata da 2021-02-01 09-42-31](https://us1.discourse-cdn.com/grafana/original/2X/3/336fcdf1ed994c2c1f2e42960b924868f3fb10e9.png)  
> ![Schermata da 2021-02-01 09-38-54](https://us1.discourse-cdn.com/grafana/original/2X/2/274669bdcb4e264b91a2076ba89357191b078b1d.png)

> **Result:**
> 
> ![Schermata da 2021-02-01 09-30-21](https://us1.discourse-cdn.com/grafana/original/2X/f/fea51ed64d940fa9cd0aa40cd970eb8c834f4860.png)

Points (_ **Line type after stacking options is enabled** _) are separated of bars, I would like them to be on top of the bars, so merge x axis with unique values.

I tried with “overrides” tab, but it remove only a part of the label: without merge data.

 ![Schermata da 2021-02-01 09-47-50](https://us1.discourse-cdn.com/grafana/original/2X/9/929b1f46c330d0347f18c526dd81ade5cb77f1a4.png)

Thanks to all,  
Kevin

---

<div class="post-metadata">

**Author:** ![kevinlucich](https://avatars.discourse-cdn.com/v4/letter/k/eb9ed0/32.png) [@kevinlucich](https://community.grafana.com/u/kevinlucich)\
**Post date:** [February 8, 2021, 2:02pm UTC](https://community.grafana.com/t/stacking-bar-and-line-series-with-same-x-value/42469/2 "2021-02-08T14:02:50Z")

</div>

Anyone have an idea?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/grafana/original/2X/e/ef5308cc58c9e5a13187b5012eb99f406928462f.png) [@system](https://community.grafana.com/u/system)\
**Post date:** [February 1, 2022, 8:49am UTC](https://community.grafana.com/t/stacking-bar-and-line-series-with-same-x-value/42469/3 "2022-02-01T08:49:21Z")

</div>

This topic was automatically closed after 365 days. New replies are no longer allowed.