# Pie chart using data from two columns

**URL:** <https://community.glideapps.com/t/pie-chart-using-data-from-two-columns/78371>\
**Category:** Ask for Help\
**Created:** [December 4, 2024, 9:15pm UTC](https://community.glideapps.com/t/pie-chart-using-data-from-two-columns/78371 "2024-12-04T21:15:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dias](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dias/32/75988_2.png) [@dias](https://community.glideapps.com/u/dias)\
**Post date:** [December 4, 2024, 9:15pm UTC](https://community.glideapps.com/t/pie-chart-using-data-from-two-columns/78371/1 "2024-12-04T21:15:15Z")

</div>

Hey there,

I was looking to make a pie chart using data from two columns on the same table, more specifically Upvotes and Downvotes to make it easier for posters to visualize such things.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/d/8dc85a4e0aeded7d99867d84fdae54ca1810eaba.png)

Is there a way to display these two columns in the pie chart? I can’t add more than one value source, as is pictured below.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/985a24d36994596101552bde454c108f1d68c6cc.png)

I’ve tried arrays, split text and joined lists but to no avail.

Thanks,  
— Dias

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 5, 2024, 2:00am UTC](https://community.glideapps.com/t/pie-chart-using-data-from-two-columns/78371/2 "2024-12-05T02:00:54Z")

</div>

The pie chart reads data vertically (row-by-row), whilst you are trying to read it horizontally (column-by-column).

> [@heart\_eyes Quickchart.io: the Cloudinary of Charts —on the fly charts!](https://community.glideapps.com/t/quickchart-io-the-cloudinary-of-charts-on-the-fly-charts/15946):
>
> GAME CHANGER! Stumbled upon this site today—a way to create on the fly charts using data from your Glide tables. Images render instantly and you can select one of 14 different charts, customize colors, styles etc all through URL parameters! The video below shows my first attempt to create a chart from scratch and implement it in Glide. Took me less than 5 minutes. End result: [Direct Loom link](https://www.loom.com/share/8a4a2fffcef946a288b5ad53560bc469?sid=9b1e0895-9489-43bb-bab6-97a6e6de45c4)

I would suggest looking into Quickchart.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 5, 2024, 2:34am UTC](https://community.glideapps.com/t/pie-chart-using-data-from-two-columns/78371/3 "2024-12-05T02:34:43Z")

</div>

What is the context in which the chart is displayed?  
Is it on a details screen, ie. for just a single row of data?  
If that’s the case, what you could do is use a 2 row helper table to transpose the data and use that as the source of the native chart component.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 6, 2024, 12:32am UTC](https://community.glideapps.com/t/pie-chart-using-data-from-two-columns/78371/4 "2024-12-06T00:32:21Z")

</div>

> [@fishbaguette\_breadbasket Transpose Columns to an Inline List: The Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766):
>
> I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [[Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD] ](https://www.youtube.com/watch?v=t-sh_Q3WbQc)

Here’s an approach to transpose data.
