# Trouble creating bar charts on Canvas

**URL:** <https://discuss.elastic.co/t/trouble-creating-bar-charts-on-canvas/188257>\
**Category:** Kibana\
**Created:** [July 1, 2019, 8:03am UTC](https://discuss.elastic.co/t/trouble-creating-bar-charts-on-canvas/188257 "2019-07-01T08:03:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![TsuWeiQuan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsuweiquan/32/46252_2.png) [@TsuWeiQuan](https://discuss.elastic.co/u/TsuWeiQuan)\
**Post date:** [July 1, 2019, 8:03am UTC](https://discuss.elastic.co/t/trouble-creating-bar-charts-on-canvas/188257/1 "2019-07-01T08:03:13Z")

</div>

Hello,

I am exploring on Canvas and had some trouble creating the Vertical/Horizontal bar chart.  
I am trying to recreate a chart similar to the photo I uploaded below onto Canvas.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/3/034e74f14c9e54e2ea13e1588d2ea22a6e978876.png)

I am able to write the query to get the information out but unable to create into bars like this.  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/e/1eabd9d4d96d35e7c43b0676fcc51c12ea5d3ec8.png)

This is my query:  
`SELECT system.cpu.user.pct/system.cpu.cores as user, system.cpu.system.pct/system.cpu.cores as system, system.cpu.nice.pct/system.cpu.cores as nice, system.cpu.irq.pct/system.cpu.cores as irq, system.cpu.softirq.pct/system.cpu.cores as softirq, system.cpu.iowait.pct/system.cpu.cores as iowait FROM "metricbeat-*" where host.hostname='NUSSERVER' AND system.cpu.cores IS NOT NULL`

which gives me this:

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

**Where can I learn to edit the settings to output the desired chart? and What settings should I set on the dimensions & measure tab to produce my desired outcome.**

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/7/e732f99ebeb74ccfecfc3479f0de813d7c9fd6b7.png)

---

<div class="post-metadata">

**Author:** ![Larry\_Gregory](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/larry_gregory/32/34969_2.png) [@Larry\_Gregory](https://discuss.elastic.co/u/Larry_Gregory)\
**Post date:** [July 1, 2019, 2:59pm UTC](https://discuss.elastic.co/t/trouble-creating-bar-charts-on-canvas/188257/2 "2019-07-01T14:59:17Z")

</div>

Hey @TsuWeiQuan, you might find this discussion helpful: [Canvas: how to make stacked area chart?](https://discuss.elastic.co/t/canvas-how-to-make-stacked-area-chart/180399)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 29, 2019, 2:59pm UTC](https://discuss.elastic.co/t/trouble-creating-bar-charts-on-canvas/188257/3 "2019-07-29T14:59:23Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.