Multicolor Filling Bars in Excel Cells Without using Chart

#DynamicDataBar #Visulaization
Hello Friends,
In this video you will learn how to create Multicolor Filling Bars in Excel Cells without using Chart. You can use such visualization to display the project completion status with red color for delayed and green color for on time. Or you can use this trick to show the service level or Quality score with Red, Amber, and Green color with filling bars.
Download the practice file from below given link:
www.pk-anexcel...
Download the Free Project Management Dashboard
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...

[@StephaneR0sa]

It's very smart to use backward white to have at the same time a progress bar and a value based color ! Thanks :-)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nsanch0181]

Thank you for the trick PK. Once again you showed me a new and better way of doing things. Thank you!

[@philipberesford2648]

Brilliant job. All the detail needed and still concise.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@saramurgia8367]

really a very good tutorial. well made, clear and not boring. bravo!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@LudwigSpiegel]

Thank you for Sharing! Just what I was looking for!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@wahidovich2021]

God bless you PK, I've been looking for this one exactly the one as in "Service Level" data sheet, I just didn't know how to phrase my question :( Thanks a lot man!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rossybink]

Any Service Level Manager would love this. Thanks, great work! 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@apn6824]

Very good info PK..But I have told you already that you have to zoom in while typing or selecting options so that viewers can see it clearly what you're doing. It will easy to understand & practiced clearly

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will take care of this in upcoming videos

[@rajsahu1029]

Nice. A good revision of conditional formate also done

[@snowwhite2146]

Thank you for this excellent video!

[@PKAnExcelExpert]

You're very welcome!

[@shilandatstewart]

Exceptional tutorial. Exactly what I needed

[@PKAnExcelExpert]

Thank you very much!

[@amal2503]

Nice and effective! Thanks Pk

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@qualityrelaxationmusic9284]

Great. Please start on python and pandas library.. to atomate the excel report. Really we need it. And your teaching skill is awsome. Please please please start your videos on python

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will try.

[@jackmonsel8987]

Good Job, I just wished there was a way to get rid of annoying colored border around the white bars.

[@dhanu502]

Great content and excellent explanation PK Sir. Thank you very much.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@albertozamora7099]

Thank you this was very helpful

[@PKAnExcelExpert]

Glad it was helpful!

[@mavado5046]

Wow you are very clever!

[@PKAnExcelExpert]

Thanks🙏

[@gov_laxvlogs3982]

Thanks 👍

[@PKAnExcelExpert]

Most welcome🙏

[@abdusshakur2878]

very nice helpful video Thank you

[@PKAnExcelExpert]

Most welcome

[@jaydeeplimbad90]

Thank you Sir... For conditional formatting process....

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@senthooranaccel9529]

You are a star !

[@PKAnExcelExpert]

Thanks a lot.

[@GeorgeAJululian]

thank you extremely helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@abdelhadia8712]

Thanks a lot Professor

[@excellearners7976]

thnx

[@PKAnExcelExpert]

Most welcome

[@rajeshchoudhary2520]

Thank You Sir....Very Nice Video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vanessabbrooks698]

Amazing Thank you

[@PKAnExcelExpert]

Most welcome🙏

[@pandharinathjoshi6565]

Wonderful sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Luciano_mp]

Awesome, good, thanks.👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@alializadeh8195]

Thanx

[@PKAnExcelExpert]

Welcome

[@Alibabachalise]

Sir thank you for the Lesson and permission to download practice file. Appreciated very much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ranarizwanahmed]

Very good tutorial

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@iwankurniawan9666]

Thank you so much my GURU ..

[@PKAnExcelExpert]

Most welcome

[@pawansharma-wo3xh]

Very good pk... Please also start tutorial on power BI and DAX

[@PKAnExcelExpert]

Thanks for your valuable feedback. Will upload soon

[@nitinsingh.2107]

Great work!

[@PKAnExcelExpert]

Thank you! Cheers!

[@mahirbadanagki]

Thank you

[@PKAnExcelExpert]

Most welcome

[@nonoobott8602]

Your videos are always very insightful. Thanks for sharing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@deepaknagar5697]

Wow, amazing , thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kyleparadise9821]

Great content; question. With the first example, can you make the remaining of the data bar a different color? For instance if it is 75% on time, it will be filled green 3/4 of the cell. Can you color the remaining 1/4 of the cell a different color?

[@shubhamverma2800]

Dear sir I requested to you that please make a video about the power bi. I want want to learn from your video.

[@pandharinathjoshi6565]

You are great sir., sir one question you can write comment sir... how you think to do excellent idea pls

[@kunio4143]

Thanks for sharing, very useful:)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sharvari.s.vichare]

Good pk

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@JeffersonAMontoya]

Excelente maestro

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@janezklun]

Nice approach, thank you for sharing, Best regards

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@drislam1231]

thank you very much really beneficial, could we remove the remaining borders of cell fill color because bar is slightly smaller than cell hieght making part of cell background appears

[@PKAnExcelExpert]

Yes we can

[@razzaqabdur1761]

fantastic sir, Thanks

[@Cristiano_Ronaldo_28_17_7]

Wow nice sir i understood i will use it but sire can you teach us forecasting manpower calculation scheduling WFM part please sir please

[@duikmans]

What would you do if you also have to include negative percentages in your data bar?

[@jewelmia2126]

Excellent, thank you.

[@PKAnExcelExpert]

You are welcome!

[@shivannahr780]

ms access form data entry tutorial Start sir very interested your teaching thanks sir

[@PKAnExcelExpert]

Please watch the below given videos- kzbin.info/www/bejne/aoi7q4OIhMidgqc kzbin.info/www/bejne/l4qtkqd6nrOmrbM

[@vogueasr2363]

❤

[@PKAnExcelExpert]

Thanks 🙏

[@effatmehmood6654]

I have taken single data and have highlighted with colors, but when i add data bars .. it disappears 100 percent and showing red bar bigger..

[@jazyhappy5018]

I want to show progress with status only. Like if I select completed then bar should show 100% if in progress then it should be 50% and pending should be 25% not started 0%

[@krissyb884]

This doesn’t work for me. The white bar fills the cell based off the %. For example, if the cell was 30%, the white bar would fill the cell up 30% of the way instead of 70%. Any fixes for this issue ?

[@meganharris8651]

Same for me i dont understand please help!

[@krishnaveni6384]

Can anyone help with a macro how to write formula based on column header and fill down till last used row.. Specially when formulas are written in separate sheet say sheet1 as all the formulas and sheet name( Col a = headers, col b= formula) Sheet 2 has headers in row 1, in horizontal, macro should look sheet1 and list the formula in sheet 2 once the headers matches and has to fill till last used row Unsure how to do that

[@pankaj3648]

Sir , insentive sheet excel की बनानी है ।

[@sanand222]

V nice video... V useful...can u create a dashboard sla scorecard based on the requirements like ABN rate, ASA, FCR, CSAT AND OTHER PARAMETERS

[@PKAnExcelExpert]

Please refer the below given playlist. kzbin.info/aero/PLbDvAYjpWJ7CpupRYMRkXSN0L92t7nUuF

[@sumank2190]

Sir...How to Use....Pk's Utility Version 1.0 & 2.0 in Win-7,MS Off-2010....am using MS Off 2010...am Add in version 1.0..still it is not working in my system...??? Same for 2.0 also....Pls....give me Solutions for those problems..???

[@hijodeGaladriel]

Si si teclado está en español y no les funciona con And, deben poner Y

[@agungrahmadiutama2178]

👍👍👍👍👍

[@PKAnExcelExpert]

Thanks

[@BMAA_off]

Hello

[@moskitowilliam4398]

PK, let me know if u need anything from Ghana God bless you

[@luckyverma2357]

Hello Sir i would like to get in touch with for an assignment, i have also mailed you and messaged you in telegram, waiting for your kind response

[@luckyverma2357]

?????

[@mohankumar-lc3pm]

Thank you

[@PKAnExcelExpert]

Welcome

[@luckyverma2357]

?????