# Trends using the Charts component

**URL:** <https://community.glideapps.com/t/trends-using-the-charts-component/16121>\
**Category:** Ask for Help\
**Created:** [September 21, 2020, 4:22am UTC](https://community.glideapps.com/t/trends-using-the-charts-component/16121 "2020-09-21T04:22:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Carlos\_DeSilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos_desilva/32/19965_2.png) [@Carlos\_DeSilva](https://community.glideapps.com/u/Carlos_DeSilva)\
**Post date:** [September 21, 2020, 4:22am UTC](https://community.glideapps.com/t/trends-using-the-charts-component/16121/1 "2020-09-21T04:22:18Z")

</div>

Hi everyone! Got a funny one for you folks; not sure how to tackle this one.

I have a supplies sheet and I need to see trends on supplies, i.e., how often something is ordered, how much is ordered, things like that. And, I’d like to use the Charts component to show these trends as necessary.

I know there is a TREND function in Sheets, but I’m not sure exactly how to use it. Also, ordering new supplies is sporadic at best, since use of facilities always change.

If you need further explanation, feel free to ask.

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [September 21, 2020, 4:32am UTC](https://community.glideapps.com/t/trends-using-the-charts-component/16121/2 "2020-09-21T04:32:37Z")

</div>

Can you explain how trends you’d like to show?

---

<div class="post-metadata">

**Author:** ![Carlos\_DeSilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos_desilva/32/19965_2.png) [@Carlos\_DeSilva](https://community.glideapps.com/u/Carlos_DeSilva)\
**Post date:** [September 21, 2020, 4:53am UTC](https://community.glideapps.com/t/trends-using-the-charts-component/16121/3 "2020-09-21T04:53:27Z")

</div>

Supply and Demand mostly.

For example, if we ordered 6 boxes of paper towels, in August, and then we are out of stock, having to order 6 more again in September, then in October we only need to order 4 (because the demand was lower), then a trend on how much we need to order in November is my particular use case. A future cast, if you will.

This trend would have to work on all 22 different items in my sheet, separately.

---

<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:** [September 21, 2020, 9:38am UTC](https://community.glideapps.com/t/trends-using-the-charts-component/16121/4 "2020-09-21T09:38:10Z")

</div>

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

Probably this?