How To - Progress Bars in Google Sheets
Learn how to make Progress Bars in Google Sheets with the Sparkline function. Make a bar chart in a single cell! These bar charts are a good addition to many spreadsheets like a budget planner. Stay tuned for more Google Sheets tutorials! Feel free to leave any questions or video requests below, I'm always willing to help!
Steini's Finance - Providing Easy Ways to Organize Your Finance
Пікірлер: 49
=sparkline(D2,{"charttype","bar";"max",E2}) the code
@AirdropDaily-pe7wz
17 күн бұрын
thanks man you saved my time
@Imranqureshi-fz8kh
7 күн бұрын
=sparkline(d2,{"charttype","bar";"max",e2})
Badass. I spent all morning looking for something like this. Everywhere else I looked was convoluted. Much appreciated.
@steinisfinance7979
2 жыл бұрын
Great to hear! Thanks for leaving a comment :)
@ryanlynch290
2 жыл бұрын
@@steinisfinance7979 Hey! Thanks for replying to my comment. I'm a contractor (design-build, I do everything, a lot of welding in particular). I'm actually building a sheet for project management functionality that I haven't seen anywhere else, and I've looked at all the different CRMs, all the contractor apps, Basecamp, everything. I'm going to create a startup to make the construction industry better. This will be part of it! I'm planning to convert my sheet to an app. I don't plan on being the best developer or engineer in the world, more the big picture person, but I love to get my hands dirty and need to know enough coding etc. to be able to work and talk shop with anyone that might work for me eventually. This is going to be exciting. I really appreciate people like you putting content out. Thanks so much for this video!
So as someone from germany I need to input it this way because with the comma it doesn't work (maybe because we use comma for decimal numbers instead of a point) =SPARKLINE(B2;{"charttype"\"bar"; "max"\C2})
@Caroline-fg6cl
6 ай бұрын
Thank you 🤩
@alexivanov3984
4 ай бұрын
real heroes don't wear capes
@victorb6367
4 ай бұрын
Thanks!!! 🤓
@nespppp
24 күн бұрын
Vielen vielen Dank!!! Du hast mein Leben gerettet!
that was pretty neat and i really loved it , thank you for this man it helped me a lot
Amazing tutorial, very didactic and straight to the point
@steinisfinance7979
3 жыл бұрын
Thanks a lot for the comment! Im glad you liked it 😊
Thanks!
Theoretically could you make a progress bar for potential employees? Filled out Resume>Potential Candidate>Call back>interview>hired ..? Depending on what step they were on, it would show 20%/40%/60% (or more/less depending on how many steps)
Hi, thank you for posting this video. I have thinking bout adding a progress bar for my budgeting portfolio to make it more exciting! :)
@steinisfinance7979
3 жыл бұрын
I hope it helps you out! For sure, visual presentation is always more fun to look at then just numbers haha! Thanks for stopping by and commenting, I appreciate it!
what if you wanna add multiple conditions? like progress 30% orange 70% yellow?
great video! is there a way to show a % progress on the bar?
Thanks for your video. Short Concise and very cool. 👊🏼💥
Thank you it works. However, how can i also display as text the actual value of the 'current' Note: am creating the progress bar on a diff tab, hence need to also show the value
Thank you - super helpful!
Hi Thanks for this,, can we have a copy of the whole formula,, I can barely see it in the video..Thanks
Amazing thank you! Any idea how to change the color of the bar by any chance??
Function SPARKLINE parameter 2 option max expects number values. But '' is a text and cannot be coerced to a number.
thank u
Thanks , how to make a progress bar vertical ?
Thank youuu
is it possible to fill the remaining side of the progress bar that is left empty with a different color bar as well?
@steinisfinance7979
3 жыл бұрын
Yes no problem! You use "color2" instead of "color1". So you would add to the formula ;"color2","yourcolorhere". Let me know if it works for you!
Google sheets says: :"Error: Circular dependency detected. To resolve with iterative calculation, see File > Settings." and then when I go to that Iterative calculation I don't know what to put..
Amazing video! Thanks! I'm still looking for a way to put the value (in your video "current") in de same cell... I know it is possible in Excel but in Google Sheets ??
@steinisfinance7979
3 жыл бұрын
Thank you for the comment! I haven't found a solution for that yet im afraid. I think the difference is that in Excel you use conditional formatting for the cell but in Google Sheets you have to use the formula bar to use the function. I will get back to you if I find a solution! 😀
Fantastic tutorial, the only one I could find that helped. But now I'm running into an error message where I haven't input my data yet. Is there a way to ignore if the cells are empty? I can't seem to wrap my head around it. I have =SPARKLINE(D2,{"charttype","bar";"max",E2;"color1",IF(D2
@yohanperera69
Жыл бұрын
Add "IFERROR(" after the = sign and hit enter
Sorry. I did =SPARKLINE(C5,{"charttype","Bar","Max",D5;"COLOR1";IF(C5
@samrangaful
Жыл бұрын
u have mistakes
@edwinej79
5 ай бұрын
Nope this did not work. My values are currency. Is that why?
4k uhd
Is not working.Can you put what you type in a coment please.Thank you
@kubus_puchatek
Жыл бұрын
use ; and \ instead of commas
Doesn't work
Doesn’t work for me.
@kubus_puchatek
Жыл бұрын
use ; and \ instead of commas
@Hgames_RBLX
Жыл бұрын
Still doesn’t