Thanks, nice video. I was wondering, how did you get the green boxes to stick together? When I do it, there are tiny white spaces in between them. Yours hold on to one another, like a normal progress bar.
Thank you! Did you use the Unicode character 129001 to get the squares or something else? Alternatively, you could try the SPARKLINE function to achieve a similar progress bar chart: ua-cam.com/video/L2PiOCv65_o/v-deo.htmlsi=DfzmP79ujjp8fOVv
@@spreadsheetwise Yeah I used the same character. I don't know then. I thought you played with the spacing in the cells or something. It's ok i guess. I did try the sparkline as well yeah.
@mojsterr The only thing I think is that you are viewing the spreadsheet with more or less than 100% zoom. If this is set to more than 100% then you will see white spaces between the squares and it can also happen with a smaller zoom too. It's a bit odd, but other than that, it won't be the formula as this does not contain any text in double-quotes; it's only using the unicode characters. =REPT(CHAR(129001),C3)&REPT(CHAR(32),10-C3) Give that a go, but if it doesn't work, I would suggest going with the SPARKLINE instead.
@@spreadsheetwise Thank you for the help, but I guess it wont work. It's ok. Just to show you how it looks like and my code, here is the picture of it: i.imgur.com/E7vV6DK.png. I the end, I'm just looking for a way to recreate a progress bar like in this picture: i.imgur.com/FYQLfbq.png Positive values go to from the center to the right and negative from the center to the left. I know I could achieve it with a workaround with REPT, the same as you have two colors in a progress bar in your video, just the spaces bother me. And the SPARKLINE looks much nicer, so my final question would be if you know if that would be achievable with it somehow? I was playing around the last few days with it and trying to figure out, but I couldn't find a way. If it's not possible, I'll play around with both and see what suits me best in the end. Thank you.
Hiii.. Thank you for this. Can you help me, how can I insert that in my formula? SPARKLINE(E21,{"CHARTTYPE","BAR";"MAX",100%;"COLOR1","RED"}). I'm kinda confused :( and sorry I'm just strating to learned sparkline or progress bar in gogglesheet.
Hi @DadaiCafe, Does your cell E21 have a percentage value in it? If this E21 is formatted to a percentage value, then you should be fine leaving this part as 100% for the Max option (Example 1 below), but if this is just a normal number such as 20, rather than 20%, then you should adjust the "MAX",100; by removing the % sign (Example 2 below). If this is a decimal value, then it will most likely need to be set to 1, but 100% should also work. (Example 3 below). =SPARKLINE(E21,{"CHARTTYPE","BAR";"MAX",100%;"COLOR1","RED"}) =SPARKLINE(E21,{"CHARTTYPE","BAR";"MAX",100;"COLOR1","RED"}) =SPARKLINE(E21,{"CHARTTYPE","BAR";"MAX",1"COLOR1","RED"}) Hope that helps! 🙂
Is there any way to include this in the COUNTIF function for a progress bar that responds to checkboxes? I've made a sheet for my assignments and would like to use pink and gray hearts rather than a bar, (right now I just have a color progress bar). The hearts I want to use are 129655 and 129654
Sure, try something like this where the tick boxes are located in the range $F$3:$F$7. You would just need to adapt this range to suit your checkboxes =REPT(CHAR(129655),COUNTIF($F$3:$F$7,true))&REPT(CHAR(129654),10-COUNTIF($F$3:$F$7,true)) Hope that helps! 😉
Great tips and pretty in-line/straightforward means of getting that done!
Glad it was helpful!
Thanks, nice video. I was wondering, how did you get the green boxes to stick together? When I do it, there are tiny white spaces in between them. Yours hold on to one another, like a normal progress bar.
Thank you!
Did you use the Unicode character 129001 to get the squares or something else?
Alternatively, you could try the SPARKLINE function to achieve a similar progress bar chart: ua-cam.com/video/L2PiOCv65_o/v-deo.htmlsi=DfzmP79ujjp8fOVv
@@spreadsheetwise Yeah I used the same character. I don't know then. I thought you played with the spacing in the cells or something. It's ok i guess. I did try the sparkline as well yeah.
@mojsterr The only thing I think is that you are viewing the spreadsheet with more or less than 100% zoom. If this is set to more than 100% then you will see white spaces between the squares and it can also happen with a smaller zoom too. It's a bit odd, but other than that, it won't be the formula as this does not contain any text in double-quotes; it's only using the unicode characters.
=REPT(CHAR(129001),C3)&REPT(CHAR(32),10-C3)
Give that a go, but if it doesn't work, I would suggest going with the SPARKLINE instead.
@@spreadsheetwise Thank you for the help, but I guess it wont work. It's ok. Just to show you how it looks like and my code, here is the picture of it: i.imgur.com/E7vV6DK.png.
I the end, I'm just looking for a way to recreate a progress bar like in this picture: i.imgur.com/FYQLfbq.png
Positive values go to from the center to the right and negative from the center to the left.
I know I could achieve it with a workaround with REPT, the same as you have two colors in a progress bar in your video, just the spaces bother me. And the SPARKLINE looks much nicer, so my final question would be if you know if that would be achievable with it somehow? I was playing around the last few days with it and trying to figure out, but I couldn't find a way. If it's not possible, I'll play around with both and see what suits me best in the end. Thank you.
You could always try the winloss SPARKLINE charttype 😉
Hiii.. Thank you for this. Can you help me, how can I insert that in my formula? SPARKLINE(E21,{"CHARTTYPE","BAR";"MAX",100%;"COLOR1","RED"}). I'm kinda confused :( and sorry I'm just strating to learned sparkline or progress bar in gogglesheet.
Hi @DadaiCafe, Does your cell E21 have a percentage value in it?
If this E21 is formatted to a percentage value, then you should be fine leaving this part as 100% for the Max option (Example 1 below), but if this is just a normal number such as 20, rather than 20%, then you should adjust the "MAX",100; by removing the % sign (Example 2 below). If this is a decimal value, then it will most likely need to be set to 1, but 100% should also work. (Example 3 below).
=SPARKLINE(E21,{"CHARTTYPE","BAR";"MAX",100%;"COLOR1","RED"})
=SPARKLINE(E21,{"CHARTTYPE","BAR";"MAX",100;"COLOR1","RED"})
=SPARKLINE(E21,{"CHARTTYPE","BAR";"MAX",1"COLOR1","RED"})
Hope that helps! 🙂
Wooooooow nice man!
Thanks, you might like this video on SPARKLINE progress charts too ua-cam.com/video/L2PiOCv65_o/v-deo.html
@@spreadsheetwise Woow thanks 🤩
Is there any way to include this in the COUNTIF function for a progress bar that responds to checkboxes? I've made a sheet for my assignments and would like to use pink and gray hearts rather than a bar, (right now I just have a color progress bar). The hearts I want to use are 129655 and 129654
Sure, try something like this where the tick boxes are located in the range $F$3:$F$7. You would just need to adapt this range to suit your checkboxes
=REPT(CHAR(129655),COUNTIF($F$3:$F$7,true))&REPT(CHAR(129654),10-COUNTIF($F$3:$F$7,true))
Hope that helps! 😉
what are the codes for red hearts and black hearts?
You can try here: symbl.cc/en/collections/heart-symbols/
These seems to work ok:
128148
128420