I have been trying to figure this out all day , this video was super helpful and to the point! Well Done !

Thanks PK for the usual support and sharing your experience and knowledge.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Such a great video. Thank you! This was exactly what I was looking for and you explained it perfectly.

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Great video, I like that you go directly to the point, thank you!

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Short and effective. Thank you for such a great video

Thank you, excellent video short and to the point.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Excellent video, clear explanation, and to the point - thank you much PK !

@PKAnExcelExpert

4 ай бұрын

Most welcome

Thank you very much for this great video and for this extensive explanation, thank you very much.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Great explanation, thanks a lot PK!

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Me encanta pero lo que más me gusta de tu trabajo son las gráficas que realizas

Great tutorial. Short and very informative! Question if I have column with different values and I want to find max value of that column (it is simple), but how to implement that code in format there I need to right number, but I have the code? I hope that makes sense.

This was very helpful. Thank you 😊

Thank you, this was very helpful and straight to the point.

@PKAnExcelExpert

Жыл бұрын

Thanks for your valuable feedback.

Just what I was looking for, excellent!

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thanks for the video! Made my life so much easier! 5*****

Thanks! This is really helpful! :)

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

WOW!!! What a great feature! Thanks so much!

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Explained so simple way..Amazing Thanks

@PKAnExcelExpert

4 ай бұрын

Most welcome

Awesome tutorial! Thanks!

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thank's a lot. From Indonesia

@PKAnExcelExpert

5 ай бұрын

Most welcome

Thank you. I was looking for that.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Excellent Sir ! Thanks for the beauty.

@PKAnExcelExpert

4 жыл бұрын

Thanks for Thanks for your valuable

Super Thanks. Very useful.

Very informative tutorial PK. Thanks a lot

@PKAnExcelExpert

10 ай бұрын

Most welcome🙏

Thank you! this is exactly what I was looking for

@PKAnExcelExpert

Жыл бұрын

Glad it was helpful!

Thankyou so much.

Thankio to show us your Professional simple Methodes and i am really really impress to learns to behave my Currier in the work place. Jj

You're a blessing. Thank you

@PKAnExcelExpert

Жыл бұрын

Most welcome🙏

Thank You from Indonesia, it is very helpfull

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

SO SO helpful, thank you!

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thanks it helped a lot. How to change the colors based on percentage?

Yes brother it is useful for me.....Thank so much, I really appreciate.....👏

@PKAnExcelExpert

10 ай бұрын

Thanks for your valuable feedback🙏

thank you! this help me a lot on making my progress report love it

@PKAnExcelExpert

2 жыл бұрын

Glad it helped!

Amazing videos - I am a Analyst and I have learnt alot fro your videos eveytine

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

@tasneemrangwala9036

4 жыл бұрын

PK: An Excel Expert can u do a hr dashboard, productwise sales dashboard and attrition analysis

Thanks, that was useful for me

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Yes very helpful! Thanks! Now subscribed to your informativr channel. Thanks a mil!

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thank you so much! very well explained !! :)

@PKAnExcelExpert

2 жыл бұрын

You are welcome!

Thanks for the video Partner.

@PKAnExcelExpert

4 жыл бұрын

Thanks for watching

This is excellent, thank you

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

This was great! Thanks!

@PKAnExcelExpert

7 ай бұрын

Most welcome🙏

exactly what i needed, thanks man!

@PKAnExcelExpert

2 жыл бұрын

Glad I could help!

Nicely explained concept. Was very useful

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Perfect, thank you very much

@PKAnExcelExpert

9 ай бұрын

You are welcome!

Thanks for your perfect explanation

@PKAnExcelExpert

2 жыл бұрын

Glad it was helpful!

I just used your Daily Activities tracker and wanted to share it to my team. Now I’d like to have all their percentage finished for the day collected and use this progress bar so I can view all of my teams completion rate. How can I collect them all and show the team members individual progress bar?

Thanks ☺️

@PKAnExcelExpert

23 күн бұрын

Most welcome

thank you man, this is awesome!

@PKAnExcelExpert

11 ай бұрын

Most welcome🙏

EXcellent topic. Thanks .

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Simple n useful, thanks PK ji

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

brilliant and simple- thank you

@PKAnExcelExpert

Жыл бұрын

Most welcome🙏

I love this! How can I remove the dropdown arrow. It is visible when I printed it.

Beautiful and easy to follow… keep it up

@PKAnExcelExpert

Жыл бұрын

Thanks a lot 😊

Good Info, is there any way to mark border with color once its reverse from high, my point is suppose its Live number movement and one progress reach to 90 and return to 70 so in this case I need to know it was touch to 90 and now running at 70. So this reversal I can see through color image ?

Thank you so much. It was really helpful

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thank you, this is very helpful

@PKAnExcelExpert

Жыл бұрын

Thanks🙏

Thank you 🙏

@PKAnExcelExpert

4 ай бұрын

Most welcome

Thanks for the help!

@PKAnExcelExpert

3 жыл бұрын

Most welcome

Very helpful thanks.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Thanks, that was helpful

@PKAnExcelExpert

2 жыл бұрын

Glad to hear it!

Thanks sir , Could you please make video on speed up excel calculation

Thank for nice video. Btw, could you tell me what app are you using to creat such videos?

Thanks for this tip. Can we have an additional conditional formatting on the bar, e.g., if below 25% then color is red, between 26% and 75% color yellow and above 75% color is green?

@antnfs

4 жыл бұрын

Maybe try combining the data bar option with the ‘formatting based on formula’ option if excel allows it. That way you could use IF functions to apply different colours to different data ranges, but I have a suspicion data bars can’t be applied to formulae.

@cricketkajunoon

4 жыл бұрын

Yes, you can probably do that by adding additional conditions. I’ve done it with numbers not the bars. You can change the color of the text based on the percentage you’ve selected

Is it possible to fill the cell from another cell? ie. I have data and would like for it to automatically update the percentage across the year. Great video.

@nickdelaney2470

3 жыл бұрын

Yes, you can conditional format cells using data from a separate cell

Dude great video, you have a subscriber now :)

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

@brolysmash9333

4 жыл бұрын

Totally dude this can keep you motivated.

Thank you!!!!!!!!!!!!!!!!!!!!

@PKAnExcelExpert

6 ай бұрын

Most welcome

Thanks for sharing sir.God bless😇

@PKAnExcelExpert

Жыл бұрын

Most welcome🙏

I REALLY NEED YOUR HELP! can you suggest an easy project based on concatenate?

Thank you!!

@PKAnExcelExpert

Жыл бұрын

You're welcome!

Thank you so much

@PKAnExcelExpert

3 ай бұрын

You're most welcome

Superb video, thank you so much

@PKAnExcelExpert

Жыл бұрын

Most welcome

Great video. Thank you.

@PKAnExcelExpert

Жыл бұрын

Glad you liked it!

You are legendary

@PKAnExcelExpert

11 ай бұрын

Thanks a lot🙏

thanks, you saved me!

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thank you for showing progress chart in excel Can you show creating Progress Bar in Google Spreadsheet ?

Thank You soo much!

@PKAnExcelExpert

Жыл бұрын

Most welcome🙏

Thanks homie!

@PKAnExcelExpert

3 жыл бұрын

Most welcome

Thank you!!!!!!!!

@PKAnExcelExpert

3 жыл бұрын

Welcome

thank you it was very helpful

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

1:49 how did you create these tools and put them in the Ribbon. Is it done using VBA or how. I am just curious. Thank you

Thanks

@PKAnExcelExpert

4 ай бұрын

Most welcome

Many thanks for sharing

@PKAnExcelExpert

2 жыл бұрын

My pleasure

thank you

@PKAnExcelExpert

2 жыл бұрын

Most welcome

EXCELENTE, GRACIAS POR SU ENSEÑANZA

@PKAnExcelExpert

4 жыл бұрын

Gracias por sus valiosos comentarios

Is this also possible in google spreadsheets? Thanks!

Excellent thanks

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

@Tahirabbas-hj2gs

4 жыл бұрын

Very useful. Can we make vertical bars?

thank you bro

@PKAnExcelExpert

Жыл бұрын

Most welcome🙏

Very useful video thanks sir

@PKAnExcelExpert

2 жыл бұрын

Most welcome

Hi can we have different color based on different status, if I change the status to progress color should be blue fill, if status is complete should be green

Sir nice,, make one video for icons with different examples sir

thnx sir

@PKAnExcelExpert

3 ай бұрын

Most welcome

Hey, thanks for the vid! is there a way to have different color bars? for example, anything under 25% is red. Anything 26 - 99% is yellow, and 100% = green? Thanks!

@PKAnExcelExpert

4 жыл бұрын

Let me check

@jonvmurphy

4 жыл бұрын

@@PKAnExcelExpert thanks, I tried layering multiple data bar rules and "stopping if true" but it doesn't seem to run through all the rules: Rule 1: green data bar if min/max = 100. Stop if true. Rule 2: yellow data if value is 1-99.

Well done

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thanks a lot. how can we copy this into Microsoft word ? I copied it as a picture into Microsoft Word. Can we copy it as an editable table in word?

Very nice sir

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

It really works. However, the bar is not coming as dynamic. is there a specific reason?

genio.-

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

2:45 for adding Data Bars

How to make this in google sheet?

Is there a way to plot only between percentages? For example, I need to plot only between 10%-90% leaving white spaces at both ends

@PKAnExcelExpert

Жыл бұрын

Great suggestion! I will try to create a video on this topic.

can you please tell this format in Mac OS??