# Bar Charts change based on in app selection
**URL:** https://community.glideapps.com/t/bar-charts-change-based-on-in-app-selection/14616
**Category:** Ask for Help
**Created:** [August 25, 2020, 1:31am UTC](https://community.glideapps.com/t/bar-charts-change-based-on-in-app-selection/14616 "2020-08-25T01:31:51Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@DariusGiovanni](https://community.glideapps.com/u/DariusGiovanni)
#### Post date: [August 25, 2020, 1:31am UTC](https://community.glideapps.com/t/bar-charts-change-based-on-in-app-selection/14616/1 "2020-08-25T01:31:51Z")
I have made a bar chart on my app that compare my business market size and share monthly. I am trying to make the bar chart to show different data based on the month by choosing in app (something like salesforce).
My purpose is to give my team that use the app freedom to see the monthly data by choosing the month in the app. Is there any way to do this?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 25, 2020, 2:00am UTC](https://community.glideapps.com/t/bar-charts-change-based-on-in-app-selection/14616/2 "2020-08-25T02:00:33Z")
- Create a user specific basic column that will be used to hold a choice component value.
- Add a choice component to the screen and set it to pull a list of Months from a sheet or from your chart data sheet.
- Create a relation column that will link the user specific selected Month value and link it to the chart data.
- Add a chart component and point it to the relation column.
---
### Author:  [@DariusGiovanni](https://community.glideapps.com/u/DariusGiovanni)
#### Post date: [August 25, 2020, 4:03am UTC](https://community.glideapps.com/t/bar-charts-change-based-on-in-app-selection/14616/3 "2020-08-25T04:03:57Z")
Thank you for the quick reply @Jeff_Hager, on which sheet i should put the relation column, the user specific sheet or the chart data sheet?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 25, 2020, 4:12am UTC](https://community.glideapps.com/t/bar-charts-change-based-on-in-app-selection/14616/4 "2020-08-25T04:12:34Z")
Ideally you would have a separate sheet that you use for your tab. It could have a single column set in the google sheet so it’s recognized by glide. Maybe you could put a short text description in that column and display in in the app. In the glide data editor, you can then create a user specific column that will hold the choice component value. Then you can create the relation column that uses the user specific column value to link to the chart data. All of it on the user specific sheet.
---
### Author:  [@DariusGiovanni](https://community.glideapps.com/u/DariusGiovanni)
#### Post date: [August 25, 2020, 11:38am UTC](https://community.glideapps.com/t/bar-charts-change-based-on-in-app-selection/14616/5 "2020-08-25T11:38:20Z")
Thank you jeff for the help, really appreciate it!