Great Lecture- if you need to put two color in one Cell (Green for completed and red for the incomplete task, max is 5) you can do it: =IF(B4/C4=1,(sparkline(B4,{"Charttype","bar";"Color1","green";"max",C4})),sparkline(B4,{"Charttype","bar";"Color1","red";"max",C4}))
What if the projects that I wanna track completion are different file names? For example this is for coaching, another file auditing, another file is huddles. How can I get those values from different files?
Hi! Great vid! But I had a lot of problems making it work. It seems that, right now, the correct syntax that works is =SPARKLINE(A5 ;{"charttype"\"bar";"max"\100}) with a semicolon instead of a colon and a backslash instead of colon between the options
I am still trying to learn google sheet and I plan to make a project similar to this. The task is for the Supervisors to complete their coaching within the week. The numbers of agents to be coached vary. 1 supervisor may have 18, 1 may have 20 but if they were able to complete the coaching per agent to the max number of agents within the Team then the report should show 100%. Subscribed! I hope you all can help me with this. They use form by the way to enter the data.
what if you wanted the progress bar to increase as a value decreases, such as a debt going down as you pay it, the bar will increase to show how close you are to paying it off?
Thank you for teaching this!! It makes so much sense how you explained it and I'm excited to get going. My question is because I've seen this done in excel and I'm unsure if it can be done in google sheets... is there a way to show the total on the progress bar as well? For my purposes I need a total running sum of the dollar amounts. Thank you for your help!
This is awesome - thankyou. Is there any way to have this effect in conditional formatting like you can do in excel? so the bar chart is in the background of the data?
How would you do this for a sales number goal? Goal vs actual in $ amounts, and the goal would be different each month. BTW love your videos, awesome work!
Those popup windows with the command's instructions don't show for me, is there a way to turn it on? Also, is there a way to change the color of the bar based on the progress rating number? For example 5 green and 1 red?
Great video! Is there a way to also sort all the tasks by status in a way that all the completed (green ones) appear on top, then have the "Submitted" ones etc.? I really need this! Thanks!
Hi thank you so much for the tutorial! Really helpful and eye opening - had no idea you could use progress bars inside of a cell till watching this vid. Question - is there a way to make the progress work towards financial goals? For example say I wanted to save $300. Would there be a formula that would be applicable to be able to log amounts to then change the bar based on how close you are to that goal? A slow way of doing this would I found from watching this tutorial would be to enter every single number in a series in the data validation list of items criteria, however it's extremely slow and I feel like there must be a better way using a formula. Also is there a way to add a data label to show a percentage on the bar itself? Thank you so much! Appreciate this vid a lot!!
Answered one of my questions - for anyone curious you can simply remove the data validation from the cell and enter any number into the original 1-5 cell in the tutorial and enter the max value as well and the progress bar will still work the same. So for example you remove the data validation from the first cell and just type in 50 and set the max value in the second cell / column and it will work based on the percentage. Still not sure how to actually display the percentage yet but I'm sure it's just an addition to the sparkline formula
***FOR EVERYONE WONDERING ABOUT DISPLAYING PERCENTAGES*** I didn't find a direct way to do it on the bar itself however you can add a percentage to any cell alongside the bar. For this example let's say your original number is in cell C2 and the max value is in D2. In the cell where you want to display the percentage, you put =(C2/D2). It will then give you the percentage in decimal form. In Google Sheets there's actually a percent button in the main toolbar underneath where the menu is. You can click that and it will convert the decimal number into a percentage. You can also get rid of decimal places WITHOUT using a TRUNC function by just using the buttons alongside the percentage button to move the decimal point so it's just a whole number percentage being displayed. Hope this helps anyone that was curious on a way to do this. Not perfect but it works!
Hello, I was wondering if you could make a spreadsheet for Amazon FBA sellers on how to narrow down the best keywords for product research or PPC Thank you so much for all the amazing content!!!
@@lukewilko3844 Thank you this was very helpful :) I am making checkboxes' progress via a single-cell bar graph. Looked like this for me =SPARKLINE(countif(J16:J19,true),{"Charttype","Bar";"color1","pink";"Max",4})
Great Lecture- if you need to put two color in one Cell (Green for completed and red for the incomplete task, max is 5) you can do it: =IF(B4/C4=1,(sparkline(B4,{"Charttype","bar";"Color1","green";"max",C4})),sparkline(B4,{"Charttype","bar";"Color1","red";"max",C4}))
What if the projects that I wanna track completion are different file names? For example this is for coaching, another file auditing, another file is huddles. How can I get those values from different files?
Big big thank you! After a bit of trial and error, I understood how the formula worked. ^^
Is there a way to make the bar change colors base on the amount of progress? like Red for 1 and 2, Yellow for 3 and 4 and then Green at 5?
This is the best video I've found that simply explains progress bars for a Gantt chart!
Glad this works for you! Let me know if you have any issues/questions with creating your Gantt chart!
Despite my poor searching skills, I managed to learn what I exactly needed, thanks for sharing ✌🏻
People are too lazy to comment, but sometimes a good video like yours forces lazy people like myself to SHOUT: * THANK YOU!!* 😄🌸🌸🌸🌸🌸
Hi! Great vid! But I had a lot of problems making it work. It seems that, right now, the correct syntax that works is =SPARKLINE(A5 ;{"charttype"\"bar";"max"\100}) with a semicolon instead of a colon and a backslash instead of colon between the options
Thanks so much dude
Thank you, your comment helped me.
My hero
nope. This doesnt work
Awesome, I spent the whole day looking for something like this and finally found something that helps me, thanks
I've spent DAYS and then finally came across this.
I am still trying to learn google sheet and I plan to make a project similar to this.
The task is for the Supervisors to complete their coaching within the week. The numbers of agents to be coached vary. 1 supervisor may have 18, 1 may have 20 but if they were able to complete the coaching per agent to the max number of agents within the Team then the report should show 100%.
Subscribed! I hope you all can help me with this. They use form by the way to enter the data.
Thanks!
0:27 How do you make a status section with a drop down list?
This is really helpful, thank you!!
Dear sir, Really it's a good lecture of you. If I want to create a progress bar with a percentage how can I do this?
Is there away a Sparkline can be created to update according to status? Eg: Not Started, In Progress, Complete?
This was very helpful. Thank you very much for sharing.
is there a way to change the color of the bar? I would like to distinguish the different tasks by color as well. Thank you:)
Awesome video! Thank you!
Thank you! Can we create this bar chart within the cell having data?
what if you wanted the progress bar to increase as a value decreases, such as a debt going down as you pay it, the bar will increase to show how close you are to paying it off?
Excellent lecture. Concise and informative video, just what I wanted to learn.
Great Tutorial!
Super helpful, thank you!! ♥
How to color B3 in black automaticaly whenever a predefined word be typed in B4?
This is fantastic. Thank you a lot!
Thank you for teaching this!! It makes so much sense how you explained it and I'm excited to get going. My question is because I've seen this done in excel and I'm unsure if it can be done in google sheets... is there a way to show the total on the progress bar as well? For my purposes I need a total running sum of the dollar amounts. Thank you for your help!
In Excel you just select the cells with numbers and click Condition formatting -> Data bars...
But then you're also stuck using excel :(
If the dropdown menu instead of numbers contains text, what should I do?
Were you ever able to find the answer for this?
Wow! You are amazing! This is really helpful! Thank uuu. :)
thanks! how to change the bar color?
This is awesome - thankyou. Is there any way to have this effect in conditional formatting like you can do in excel? so the bar chart is in the background of the data?
how to put the percentage of progress bar inside the cell?
Hello. Please I want to know how he was able to do k41 to be able to get those data
Great Stuff, thanks
Learn a lot!
Thank you!
Super easy to understand, I already created my Progress bar. Is there a way to Change the color??? Thank you so much, this was extremely helpful!
Yep, you can try this: =IFERROR(SPARKLINE(C2,{“charttype”,”bar”;”max”,D2;"color1","purple"})) -- hex values also work in place of "purple"
thanks alot
Very helpful, thank you.
I get an error everytime, even when copieng the code directly from your sheets.
How to change the color of data bar?
How would you do this for a sales number goal? Goal vs actual in $ amounts, and the goal would be different each month. BTW love your videos, awesome work!
Those popup windows with the command's instructions don't show for me, is there a way to turn it on? Also, is there a way to change the color of the bar based on the progress rating number? For example 5 green and 1 red?
Great video! Is there a way to also sort all the tasks by status in a way that all the completed (green ones) appear on top, then have the "Submitted" ones etc.?
I really need this! Thanks!
Were you ever able to figure out a way to have the bar update according to status?
Thanks a lot
This was really easy to follow, thank you. Is there a way to change the color of the bar chart?
Yes! I'll make a video on this today
Can you link the video for conditional formatting for changing the colors of the bars?
Hi thank you so much for the tutorial! Really helpful and eye opening - had no idea you could use progress bars inside of a cell till watching this vid. Question - is there a way to make the progress work towards financial goals? For example say I wanted to save $300. Would there be a formula that would be applicable to be able to log amounts to then change the bar based on how close you are to that goal? A slow way of doing this would I found from watching this tutorial would be to enter every single number in a series in the data validation list of items criteria, however it's extremely slow and I feel like there must be a better way using a formula. Also is there a way to add a data label to show a percentage on the bar itself? Thank you so much! Appreciate this vid a lot!!
Answered one of my questions - for anyone curious you can simply remove the data validation from the cell and enter any number into the original 1-5 cell in the tutorial and enter the max value as well and the progress bar will still work the same. So for example you remove the data validation from the first cell and just type in 50 and set the max value in the second cell / column and it will work based on the percentage. Still not sure how to actually display the percentage yet but I'm sure it's just an addition to the sparkline formula
***FOR EVERYONE WONDERING ABOUT DISPLAYING PERCENTAGES***
I didn't find a direct way to do it on the bar itself however you can add a percentage to any cell alongside the bar. For this example let's say your original number is in cell C2 and the max value is in D2. In the cell where you want to display the percentage, you put =(C2/D2). It will then give you the percentage in decimal form. In Google Sheets there's actually a percent button in the main toolbar underneath where the menu is. You can click that and it will convert the decimal number into a percentage. You can also get rid of decimal places WITHOUT using a TRUNC function by just using the buttons alongside the percentage button to move the decimal point so it's just a whole number percentage being displayed. Hope this helps anyone that was curious on a way to do this. Not perfect but it works!
@@giovannipiris5285 I saw an Excel tutorial where the percentage can be in the same cell as the sparkline, but I haven't been able to do so in sheets.
Thank you sir
My bars are so faint. Is there a way to adjust the size?
can we change the color of the progress bar?
Hello, I was wondering if you could make a spreadsheet for Amazon FBA sellers on how to narrow down the best keywords for product research or PPC
Thank you so much for all the amazing content!!!
Can you customize the progress bar column ?
=SPARKLINE(I7,{"Charttype","bar";"color1","green";"max",J12})
Just change the "green" to whatever color you want & Don't forget the 1 in "Color1"
@@lukewilko3844 Thank you this was very helpful :) I am making checkboxes' progress via a single-cell bar graph. Looked like this for me =SPARKLINE(countif(J16:J19,true),{"Charttype","Bar";"color1","pink";"Max",4})
good
Thanksss
I just cannot keep spark lines to auto-populate, any help please?
auto-populate?
Friendly advice, next time zoom in. I could not see anything.
Can I get some project work for spreadsheets?
I follow step by step but it becomes NA or error
there may be typo. you need to type exactly like this:
=SPARKLINE(C2,{"charttype","bar";"max",5})
Thank you so much for this. Really helpful!
Thanks a lot