# Sort by date in a donut chart

**URL:** <https://community.glideapps.com/t/sort-by-date-in-a-donut-chart/6448>\
**Category:** Feature Requests\
**Created:** [April 5, 2020, 11:32am UTC](https://community.glideapps.com/t/sort-by-date-in-a-donut-chart/6448 "2020-04-05T11:32:54Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Arnauv\_Gilotra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arnauv_gilotra/32/5182_2.png) [@Arnauv\_Gilotra](https://community.glideapps.com/u/Arnauv_Gilotra)\
**Post date:** [April 5, 2020, 11:32am UTC](https://community.glideapps.com/t/sort-by-date-in-a-donut-chart/6448/1 "2020-04-05T11:32:54Z")

</div>

Either i am new or this feature doesn’t exist but, in a donut chart I’ve used to show total number of active coronavirus cases in my country. The legends aren’t sorted according to date but by value. And i want to sort by date. I am having trouble doing that. I have tried the filtering feature but i don’t find that to be working. If there is some way around which I am missing please tell me otherwise i request glide tam to add this very important and simple feature  
Thank you very much.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 8, 2020, 1:24am UTC](https://community.glideapps.com/t/sort-by-date-in-a-donut-chart/6448/2 "2020-04-08T01:24:58Z")

</div>

I’m not seeing a way to change the sorting in the chart legend for a donut or pie chart, but I also haven’t done much with charts. From what I can see, it doesn’t look possible, but a bar chart might be a better choice. It looks like you can control sorting of the bar chart.

---

<div class="post-metadata">

**Author:** ![Arnauv\_Gilotra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arnauv_gilotra/32/5182_2.png) [@Arnauv\_Gilotra](https://community.glideapps.com/u/Arnauv_Gilotra)\
**Post date:** [April 8, 2020, 5:57am UTC](https://community.glideapps.com/t/sort-by-date-in-a-donut-chart/6448/3 "2020-04-08T05:57:31Z")

</div>

Bar Graphs do not work as intended, for example i take date as x-axis and number of daily cases per day  
but no ‘bars’ appear and do not really understand why.  
app.thecorrectech.in ---------------\> This is my app

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [April 8, 2020, 2:37pm UTC](https://community.glideapps.com/t/sort-by-date-in-a-donut-chart/6448/4 "2020-04-08T14:37:40Z")

</div>

Hi @Arnauv_Gilotra

The problem with bar charts is caused by the amount of points to be showed. Currently Glide has a limit which will be increased soon (I hope so)

The trick so far is to use a filter, in my App I set it to Cases\> 20 and this improved my charts.

A rare curiosity is when you move your phone from vertical to a horizontal position: The lost bars and data suddenly appear in your screen so, the problem depends on screen resolution.

I hope it helps

Saludos  
Gavp

---

<div class="post-metadata">

**Author:** ![Josemarti\_Rodriguez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/josemarti_rodriguez/32/14136_2.png) [@Josemarti\_Rodriguez](https://community.glideapps.com/u/Josemarti_Rodriguez)\
**Post date:** [September 24, 2020, 9:53pm UTC](https://community.glideapps.com/t/sort-by-date-in-a-donut-chart/6448/5 "2020-09-24T21:53:28Z")

</div>

Looking the answer, it seems that this a topic to improve.

I have a chart, that estimate (forecast) the data of the month in an internet plan. So I have a free quota (40 GB for example), then I must consider the excess to project with the daily consumption the rest of the month. So I want a chart that always shows this items in the same order (free quota, excess and forecast) but this doesn’t happen.

Sorry my not good English!

---

<div class="post-metadata">

**Author:** ![piri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/piri/32/8657_2.png) [@piri](https://community.glideapps.com/u/piri)\
**Post date:** [November 25, 2020, 8:15pm UTC](https://community.glideapps.com/t/sort-by-date-in-a-donut-chart/6448/6 "2020-11-25T20:15:15Z")

</div>

Same here. I reported this specific case with more info in this thread, but unfortunately no development seems to happen on this area.

> [@Add "Sort" to all Chart styles](https://community.glideapps.com/t/add-sort-to-all-chart-styles/10364):
>
> Could you please add support for the Sort functionality in all chart layouts? It’s currently already possible to sort a Bar Chart (screenshot A), but somehow it’s not available when you switch to a Pie Chart or Donut Chart (screenshot B). A. Features tab – Chart (Layout Style: Bar) [Screenshot 2020-06-05 20.03.03] B. Features tab – Chart (Layout Style: Pie | Donut) [[image] ](https://dl.dropboxusercontent.com/s/ri0on8xf9154pcs/Screenshot%202020-06-05%2020.03.15.png?dl=0) Thanks in advance!

---

<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:** [November 25, 2020, 11:26pm UTC](https://community.glideapps.com/t/sort-by-date-in-a-donut-chart/6448/7 "2020-11-25T23:26:35Z")

</div>

You can consider using [quickchart.io](http://quickchart.io) while waiting for native support.

---

<div class="post-metadata">

**Author:** ![piri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/piri/32/8657_2.png) [@piri](https://community.glideapps.com/u/piri)\
**Post date:** [November 26, 2020, 1:07am UTC](https://community.glideapps.com/t/sort-by-date-in-a-donut-chart/6448/8 "2020-11-26T01:07:25Z")

</div>

hey man that’s a great suggestion! would you have an example of how to use this within glide though? gotta admit I never tried to use external api’s in glide before, only embedded in my sheets.  
thanks in advance 🙂

---

<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:** [November 26, 2020, 1:37am UTC](https://community.glideapps.com/t/sort-by-date-in-a-donut-chart/6448/9 "2020-11-26T01:37:32Z")

</div>

Probably you can find something useful in this thread here.

> [@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:

Personally I have done this for 2 apps and the most challenging thing is to how to format the data the right way so I can use them in template columns.

Quickchart has a sandbox environment for you to test out ideas, then generate the URL and replace your data. Good support via email as well.

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [November 27, 2020, 2:40am UTC](https://community.glideapps.com/t/sort-by-date-in-a-donut-chart/6448/10 "2020-11-27T02:40:07Z")

</div>

Hold on, everything can be solved within sheets if it is not already available in Glide. Create a separate column that uses the SORT function in Google sheets. The function supports multiple ways of sorting the data and you can use this column to provide the visual with its data. Also, you can build a chart directly onto your google sheets and publish it. Use the image link as the image in your app.

---

<div class="post-metadata">

**Author:** ![piri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/piri/32/8657_2.png) [@piri](https://community.glideapps.com/u/piri)\
**Post date:** [December 13, 2020, 3:02pm UTC](https://community.glideapps.com/t/sort-by-date-in-a-donut-chart/6448/11 "2020-12-13T15:02:38Z")

</div>

Thanks everyone for these workarounds, that helps me for the time being. Still hope glide will soon “fix” sorting of graph data by just adding it to all variants — should be easy enough since they do provide it for regular bar charts 🙂
