# Bar charts **URL:** \ **Category:** Ask for Help\ **Created:** [March 8, 2021, 3:30pm UTC](https://community.glideapps.com/t/bar-charts/23956 "2021-03-08T15:30:41Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)\ **Post date:** [March 8, 2021, 3:30pm UTC](https://community.glideapps.com/t/bar-charts/23956/1 "2021-03-08T15:30:41Z")
Two questions about Bar (charts): 1. Is it possible to set only one specific color for all the bars? If you have all bars related to one specific variable / entity, it makes no sense to have them colored differently. Instead of a multicolor / rainbow choice it should be very useful (and correct from the mathematical point of view) to choose 1 Quantity = 1 Color. If we add another “Quantity” then Quantity #2 = Color #2, etc. 2. I plot quantities from 0 to 100% (so the scale is 0 to 100). Why the label shows (on y axe) 0 to 102, divided randomly in 6 steps (17, 34, 51, 68, 85, 102)? Quite strange to read. Also because in some situation 102% cannot be allowed! Please help!! Thanks. ---
**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:** [March 9, 2021, 12:04am UTC](https://community.glideapps.com/t/bar-charts/23956/2 "2021-03-09T00:04:03Z")
I think those are some limitations with the chart inside Glide. While I don’t have the exact same use case as yours, I would advise taking a look at [Quickchart.io](http://Quickchart.io) to see if you find the correct combination there to use in a Template/Construct URL column. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 9, 2021, 2:12am UTC](https://community.glideapps.com/t/bar-charts/23956/3 "2021-03-09T02:12:06Z")
+1 for [quickchart.io](http://quickchart.io) I find the Glide native charting feature extremely limited and generally don’t even bother with it - unless I need something quick and dirty. For everything else, I use quickchart. PS. I’m not complaining. I’d much rather see the Glide team spending their time on all the other awesome new features, instead of wasting time developing chart functionality that we can already get with quickchart. ---
**Author:** ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)\ **Post date:** [March 9, 2021, 8:02am UTC](https://community.glideapps.com/t/bar-charts/23956/4 "2021-03-09T08:02:14Z")
I followed your suggestion and checked Quickchart. There is also a video from Robert Petitto. But I find difficult to insert a bar graph where data are first filtered from a long rows of data. Until you use it as a single value (as Robert shows) it’s easy. But do you have an example on how to use it for bars? For example: I have a sheet with customers data. I would like to plot from one column one customer only, filtering and showing only the last 7 days. What do you suggest? Thanks! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 9, 2021, 8:27am UTC](https://community.glideapps.com/t/bar-charts/23956/5 "2021-03-09T08:27:58Z")
Not sure if this will help, but here is an example using a Stacked Bar chart… > [@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/125): > > So here is the one I did using the Construct URL column… Started off with a URL that looked like: https://quickchart.io/chart?bkg=white&c={.........} There are two query parameters in that URL: bkg=white c={ JSON structure } So I took the whole JSON structure, and put that in a template column: Then defined the Construct URL column as follows: The first query parameter was simple, so I “hard-coded” that, … There are also lots of other examples in that same thread. A good way to work with quickchart is to use their [sandbox](https://quickchart.io/sandbox/#%7B%0A%20%20%22type%22%3A%20%22bar%22%2C%0A%20%20%22data%22%3A%20%7B%0A%20%20%20%20%22labels%22%3A%20%5B%0A%20%20%20%20%20%20%22January%22%2C%0A%20%20%20%20%20%20%22February%22%2C%0A%20%20%20%20%20%20%22March%22%2C%0A%20%20%20%20%20%20%22April%22%2C%0A%20%20%20%20%20%20%22May%22%2C%0A%20%20%20%20%20%20%22June%22%2C%0A%20%20%20%20%20%20%22July%22%0A%20%20%20%20%5D%2C%0A%20%20%20%20%22datasets%22%3A%20%5B%0A%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%22label%22%3A%20%22Dataset%201%22%2C%0A%20%20%20%20%20%20%20%20%22backgroundColor%22%3A%20%22rgba(255%2C%2099%2C%20132%2C%200.5)%22%2C%0A%20%20%20%20%20%20%20%20%22borderColor%22%3A%20%22rgb(255%2C%2099%2C%20132)%22%2C%0A%20%20%20%20%20%20%20%20%22borderWidth%22%3A%201%2C%0A%20%20%20%20%20%20%20%20%22data%22%3A%20%5B%0A%20%20%20%20%20%20%20%20%20%20-31%2C%0A%20%20%20%20%20%20%20%20%20%20-70%2C%0A%20%20%20%20%20%20%20%20%20%20-30%2C%0A%20%20%20%20%20%20%20%20%20%20-33%2C%0A%20%20%20%20%20%20%20%20%20%20-9%2C%0A%20%20%20%20%20%20%20%20%20%2014%2C%0A%20%20%20%20%20%20%20%20%20%20-41%0A%20%20%20%20%20%20%20%20%5D%0A%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%22label%22%3A%20%22Dataset%202%22%2C%0A%20%20%20%20%20%20%20%20%22backgroundColor%22%3A%20%22rgba(54%2C%20162%2C%20235%2C%200.5)%22%2C%0A%20%20%20%20%20%20%20%20%22borderColor%22%3A%20%22rgb(54%2C%20162%2C%20235)%22%2C%0A%20%20%20%20%20%20%20%20%22borderWidth%22%3A%201%2C%0A%20%20%20%20%20%20%20%20%22data%22%3A%20%5B%0A%20%20%20%20%20%20%20%20%20%2073%2C%0A%20%20%20%20%20%20%20%20%20%2041%2C%0A%20%20%20%20%20%20%20%20%20%2029%2C%0A%20%20%20%20%20%20%20%20%20%2061%2C%0A%20%20%20%20%20%20%20%20%20%20-65%2C%0A%20%20%20%20%20%20%20%20%20%2059%2C%0A%20%20%20%20%20%20%20%20%20%2038%0A%20%20%20%20%20%20%20%20%5D%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%5D%0A%20%20%7D%2C%0A%20%20%22options%22%3A%20%7B%0A%20%20%20%20%22responsive%22%3A%20true%2C%0A%20%20%20%20%22legend%22%3A%20%7B%0A%20%20%20%20%20%20%22position%22%3A%20%22top%22%0A%20%20%20%20%7D%2C%0A%20%20%20%20%22title%22%3A%20%7B%0A%20%20%20%20%20%20%22display%22%3A%20true%2C%0A%20%20%20%20%20%20%22text%22%3A%20%22Chart.js%20Bar%20Chart%22%0A%20%20%20%20%7D%0A%20%20%7D%0A%7D) to try things out. Using that, you can fiddle with various settings to get the chart to look how you need it to, and then copy the Chart URL that’s auto-generated. ---
**Author:** ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)\ **Post date:** [March 9, 2021, 8:47am UTC](https://community.glideapps.com/t/bar-charts/23956/6 "2021-03-09T08:47:44Z")
Thanks for the input. I will play with it. Not still clear how to filer the required data from the table, but I will try! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 9, 2021, 8:54am UTC](https://community.glideapps.com/t/bar-charts/23956/7 "2021-03-09T08:54:40Z")
An approach that I often use to filter a list is with a combination of template and multi-relation columns. I described the approach here: > [@Array to array relation with AND condition](https://community.glideapps.com/t/array-to-array-relation-with-and-condition/23909/4): > > I generally use a combination of templates and multi-relations for this type of dynamic filtering. The basic idea is: In the table that contains your source data, create a template column that concatenates each of the values that you’ll be filtering on. In your example, it might look something like: House:5 BR:3 WC Apartment:1 BR:1 WC Condo:3 BR:2 WC etc.. Next create an identical template that concatenates the same values from your User Specific Columns Finally, create a multi-relation tha… ---
**Author:** ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)\ **Post date:** [March 9, 2021, 10:38am UTC](https://community.glideapps.com/t/bar-charts/23956/8 "2021-03-09T10:38:22Z")
Yes, the “select all” makes everything more difficult: every day the sheet adds one row per customer, and I need to plot the last 7 days to each of them… well, I will try to digest what you explained to me. Thanks, Darren!