# Charts with Dates in Glide **URL:** \ **Category:** Ask for Help\ **Created:** [August 15, 2021, 11:51am UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500 "2021-08-15T11:51:44Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![qb15](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/qb15/32/9973_2.png) [@qb15](https://community.glideapps.com/u/qb15)\ **Post date:** [August 15, 2021, 11:51am UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500/1 "2021-08-15T11:51:44Z")
I believe this is an ‘unworkaround’ scenario, but thought I’d post in case I’m missing something/ and someone has found a way around this. Situation: - Bar Charts in App with Date based values (i.e. LABEL/ X-axis is date) - Charts has quantity on Y-Axis Issue: - Dates don’t line up on x-axis (e.g. missed dates aren’t shown/ they aren’t displayed as dates/ more just a ‘category’) - Each bar is a different color because it treats each date as a different category ( unless it’s the same day) Need: - create a true time based chart ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [August 15, 2021, 12:14pm UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500/2 "2021-08-15T12:14:10Z")
Hola @qb15 Have you tried using [Quickchart.io](http://Quickchart.io)? > [@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: ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [August 15, 2021, 4:16pm UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500/3 "2021-08-15T16:16:57Z")
You can also embed charts from Google sheets… ---
**Author:** ![qb15](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/qb15/32/9973_2.png) [@qb15](https://community.glideapps.com/u/qb15)\ **Post date:** [August 17, 2021, 7:52am UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500/4 "2021-08-17T07:52:58Z")
We embed Google Data Studio charts to bypass the issue. From what I’ve seen better than google sheets. But it’s not ideal. In GDS, you can define the user/ parameters for the chart - in googlesheets I’m not sure you can. ---
**Author:** ![qb15](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/qb15/32/9973_2.png) [@qb15](https://community.glideapps.com/u/qb15)\ **Post date:** [August 17, 2021, 8:18am UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500/5 "2021-08-17T08:18:47Z")
Awesome - this looks like the hack I was looking for. Thanks! ---
**Author:** ![cnaull](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cnaull/32/44924_2.png) [@cnaull](https://community.glideapps.com/u/cnaull)\ **Post date:** [July 12, 2022, 9:48pm UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500/6 "2022-07-12T21:48:39Z")
Hello, I’m having a hard time understanding what I might be doing wrong. I have (almost) the same chart in two different pages. Chart 1 = weight monitoring of a group of athletes and Chart 2 = data from one athlete in their profile page. For Chart 1, the x-axis (date) appears, but for Chart 2, it just doesn’t - whatever I have tried (and yes x-axis is checked on the right) What can cause this? The only thing I can see is in one graph, the filter is selected to chose the athlete, where in the second chart, it is not. Any help would be appreciated, thanks! **Chart 1: (select from filter)** ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e60d6cbb6e47fa341d75f3426c1fdb6d3ce223a0.png) ---
**Author:** ![cnaull](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cnaull/32/44924_2.png) [@cnaull](https://community.glideapps.com/u/cnaull)\ **Post date:** [July 12, 2022, 9:49pm UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500/7 "2022-07-12T21:49:46Z")
\*\*Chart2: (user data) no x-axis appearing \*\* ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/ea433856ce21f8b3b02f144aae68782cf8b4d045.png) ---
**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:** [July 12, 2022, 11:48pm UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500/8 "2022-07-12T23:48:15Z")
Can you show us how your data is constructed for both these charts? ---
**Author:** ![cnaull](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cnaull/32/44924_2.png) [@cnaull](https://community.glideapps.com/u/cnaull)\ **Post date:** [July 13, 2022, 12:59pm UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500/9 "2022-07-13T12:59:18Z")
Hi, Chart 1 (with x-axis showing) is from and Excel spreadsheet sync in OneDrive (ISAK Men) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/e/bee725b3db7b7b17df78f059a39764a36ad3bbc2.png) ---
**Author:** ![cnaull](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cnaull/32/44924_2.png) [@cnaull](https://community.glideapps.com/u/cnaull)\ **Post date:** [July 13, 2022, 12:59pm UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500/10 "2022-07-13T12:59:58Z")
Chart 1: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/a/6a1d0eb2ece6ad035d27bf9e94b9d5c39ced1630.png) ---
**Author:** ![cnaull](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cnaull/32/44924_2.png) [@cnaull](https://community.glideapps.com/u/cnaull)\ **Post date:** [July 13, 2022, 1:00pm UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500/11 "2022-07-13T13:00:41Z")
and then Chart 2 is from the same data source (ISAK Men) but filtered to only the User profile same settings: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/841c220e7c6be9d644ba923ab48bd17cc00febd4.png) \*\*\*oops, because I am new, I cannot reply more or update more screenshots… ☹ ---
**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:** [July 13, 2022, 11:29pm UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500/12 "2022-07-13T23:29:38Z")
So they are from the same table, just differed by the filter for the signed-in user? Does it show the correct data time-wise? I mean does it work correctly in the second chart, just without the X-axis labels? ---
**Author:** ![cnaull](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cnaull/32/44924_2.png) [@cnaull](https://community.glideapps.com/u/cnaull)\ **Post date:** [July 14, 2022, 10:50am UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500/13 "2022-07-14T10:50:58Z")
Hi, yes there are from the exact same table. The graphs are both the exact same in terms of visual, but the x-axis needs to show for graph 2 (when it’s filtered for one athlete on their profile page) I also just tried adding the same Chart 1 to the Profile page - not filtered to the athlete (showing all data from the ISAK table) and the x-axis is still not showing. So there seems to be something about graphs on the User page/Profile page vs other pages. maybe I should report a bug?? thanks for your help ---
**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:** [July 16, 2022, 11:45pm UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500/14 "2022-07-16T23:45:40Z")
That’s weird. > [@Glide Pages Charts](https://community.glideapps.com/t/glide-pages-charts/44604/2): > > Yes, you can activate the filter on the chart, as I did here to exclude any readings not in the current year (current year here is a field I hard-coded as 12/31/2021): In your case, whatever field is your y-axis should be filtered to only include weights lower than what you want the maximum to be. Per this comment, it seems like the filter does work with David’s test. I would suggest contacting the support team. [https://glide-help.zendesk.com/hc/en-us/requests/new](https://glide-help.zendesk.com/hc/en-us/requests/new) ---
**Author:** ![cnaull](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cnaull/32/44924_2.png) [@cnaull](https://community.glideapps.com/u/cnaull)\ **Post date:** [July 18, 2022, 10:57am UTC](https://community.glideapps.com/t/charts-with-dates-in-glide/30500/15 "2022-07-18T10:57:23Z")
Thanks for your help, will do that!