Iโm been using AppSheet for a while but am still pretty much of a novice in regard to charts so I need some help.
Iโm interested in doing something like this:
I know I can do it horizontally but, because people normally hold their phones vertically and also because it would be great if the user could scroll to take in a long image like this, Iโd like to do it vertically.
Iโve looked but, as far as I can tell, vertical orientation isnโt possible in AppSheet. Am I correct about that? Could I make a horizontal chart like this that could be scrolled so that the whole thing didnโt have to fit in the narrow screen of a phone?
Iโm think that Iโd like to display charts like this in a dashboard view, which seems to be quite flexible in regard to scrolling. However, if the charts can only be horizontal or can only be of certain dimensions, that may not help much.
Any thoughts will be greatly appreciated.
As Iโve been thinking some more about this it occurred to me that I might want to utilize a text solution that I can prepare on my Google spreadsheet. Itโs taken me some time to get this ready but from now on the spreadsheet should do all of the work for me. What you see will be contained in a single cell and displayed as such, probably in the โdetailโ part of a deck or table view:
ใใก โ
ใใข โโโโ
ใใฃ โโ
ใใค โ
ใใฅ
ใใฆ
ใใง โโ
ใใจ
ใใฉ โโ
ใใช โ
ใใซ โ
ใใฌ โ
ใใญ โโโ
ใใฎ โ
ใใฏ โ
ใใฐ โโ
ใใฑ โ
ใใฒ โ
ใใณ
ใใด
ใใต
ใใถ
ใใท
ใใธ
ใใน
ใใบ
ใใป
ใใผ
ใใฝ
ใใพ
ใใ
ใใก
ใใข
ใใฃ
ใใค
ใใฅ
ใใฆ
ใใง
ใใจ
ใใฉ
ใใช
ใใซ
ใใฌ
ใใญ
ใใฎ โ
ใใฏ โโ
ใใฐ โโโโโโ
ใใฑ โโโโ
ใใฒ โโโโโ
ใใณ โโโโโโโ
ใใด โโโโโโโโ
ใใต โโโโโโโ
ใใถ โโโโโโโโโโโโ
ใใท โโโโโโโโโโโโโ
ใใธ โโโโโโโโโโโโ
ใใน โ
ใใบ โโโโโโ
ใใป โโ
ใใผ โโโโโโโโโโโโ
I see now that the tips of the bars look jagged in a way they did not in my spreadsheet. I hope they donโt look this way in my app but, even if they do, I still may go with this.
On my Android phone the bars look nice and clean, more-or-less like this
but on my iOS device the tips are jagged, as they appear to me on this web page and in the following image:
To get more definition in the lengths of the bars Iโm using full blocks with end pieces that are 1/8 to 7/8 of a block in length:
That seems to be the problem. Oh well, I may go with this anyway. My first I idea was to make approximate illustrations with simple ascii characters. This is probably better than that. Or, I might just give up on the detail that the smaller blocks bring.
As far as I can tell, this is a font issue. It would be nice if AppSheet could have one compatible font.
Hi @Kirk_Masden I made one with an In cell Bar Chart just using I,
Thanks @Lynnn! Looks very good! I forgot about what color could do for this.
Iโve been experimenting with the following three:
Unicode Character โโซฟโ (U+2AFF)
Unicode Character โโซพโ (U+2AFE)
Unicode Character โ๐โ (U+1D100)
Hereโs what the last one looks like:
ใใฌ
ใใญ
ใใฎ ๐๐๐๐๐๐๐๐๐๐
ใใฏ ๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐
ใใฐ ๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐
ใใฑ ๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐
ใใฒ ๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐
ใใณ ๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐
ใใด ๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐
ใใต ๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐
ใใถ ๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐
ใใท ๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐
ใใธ ๐๐๐๐
ใใน ๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐
ใใบ ๐๐๐๐๐๐๐๐๐๐๐๐๐๐
ใใป ๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐
ใใผ ๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐
The first one looks like this:
ใใฌ
ใใญ
ใใฎ โซฟโซฟโซฟโซฟโซฟ
ใใฏ โซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟ
ใใฐ โซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟ
ใใฑ โซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟ
ใใฒ โซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟ
ใใณ โซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟ
ใใด โซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟ
ใใต โซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟ
ใใถ โซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟ
ใใท โซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟ
ใใธ โซฟโซฟ
ใใน โซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟ
ใใบ โซฟโซฟโซฟโซฟโซฟโซฟโซฟ
ใใป โซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟ
ใใผ โซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟโซฟ
Not quite as fine (narrow) as the other one but it has a fairly nice appearance.
I guess my question about horizontal bar graphs has been answered: AppSheet doesnโt do it at this point, right?
Also, @Lynn, Iโd like to ask if you have done what you need to do to put the bar graphs together all in AppSheet. I know how to do it in Google Sheets (I use REPT() with some other calculations). Is it done the same way in AppSheet? Thanks again!
@Lynn Sometimes there are lot of different options
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |