# How to change the data of a chart according to the selected date?

**URL:** https://community.glideapps.com/t/how-to-change-the-data-of-a-chart-according-to-the-selected-date/7789
**Category:** Ask for Help
**Created:** [April 25, 2020, 1:59am UTC](https://community.glideapps.com/t/how-to-change-the-data-of-a-chart-according-to-the-selected-date/7789 "2020-04-25T01:59:20Z")
**Posts on this page:** 1
**Showing post:** 2

<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: [April 25, 2020, 2:27am UTC](https://community.glideapps.com/t/how-to-change-the-data-of-a-chart-according-to-the-selected-date/7789/2 "2020-04-25T02:27:51Z")

</div>

I think you can use a QUERY to achieve that. Have not used a Date component in my apps, do that store a value in the sheet?

If yes, you can probably do something like: QUERY(your original full data, “SELECT \* WHERE DateCol = '”&(Insert Cell Where Date component value is stored)&"’,-1)

Then get the chart based on the newly queried value.

Hope it helps.

---

_[View the full topic](https://community.glideapps.com/t/how-to-change-the-data-of-a-chart-according-to-the-selected-date/7789)._