Multi-color Data bar with REPT function in Excel
ฝัง
- เผยแพร่เมื่อ 7 ก.ย. 2024
- #MulicolorDatabar #ConditionalFormatting
Hello Friends,
In this video, you will learn how to create a multi-color Data bar with REPT function in Microsoft Excel. We have used the conditional formatting to change the color on the basis of certain criteria.
Download the practice file from the below link:
www.pk-anexcel...
See our Power BI videos:
• Power BI Tutorial
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Free Project Management Dashboard
www.pk-anexcel...
Download the Calendar Control in VBA from below link
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
LinkedIn:
/ pk-anexcelexpert
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...
I love how you do excel Man. Thank you for the content
Most welcome
No comments as beauty of data is the speciality of you. ❤️❤️
Thanks for your valuable feedback🙏
Very very intersting, your every videos, thank you so much.
Thanks for your valuable feedback🙏
Thanks for your knowledge
for file sample is very good to practice learn
is very good
thanks
Most welcome
You don't need to enter formulas, but in cell C2 enter =B2 drag up to C12, then select the range C2:C12, then Home --> Conditional Formatting --> Data Bars --> Solid Color and the chart is done.
PK than you for the great video? I was familiar with the Rept, but never really got creative with the fonts. I tried Font Snap ITC and it made a nice looking ball type symbol. You have shown me some really cool tricks PK thank you.
Most welcome🙏
Wow! Ingenious hack there. Solved my problem
Thanks
So many thanks for this good presentation without using chart techniques 👍
I’m waiting for this type of interactive tutorials
Thanks for your valuable feedback🙏
This is brilliant, Thank you very much 🙏
You're very welcome!
Very helpful! Thank you!!
Most welcome
Thanks for your knowledge💟💟💟
Very use full method to make chart, Amzed me
Thanks🙏
Very helpful video PK. Thanks
Most welcome
Nice video and very informative 👍 Thank u PK
Most welcome
Wow, an incredible trick. Thanks
Thanks for your valuable feedback🙏
great ideas, keep it up PK, thanks for sharing
Most welcome
This was very useful - thank you!
Most welcome🙏
Beautiful, thank you PK
Most welcome
Great video PK...thanks for uploading. In the future, can you please consider making a leave management system using SharePoint List, Power Apps, and Power Automate? Many thanks
We will try
Thank you so much for this!
You're so welcome!
Thanks for the share.
Most welcome
Thank you so much 😊
Most welcome
Awesome 👍😎
Thanks🙏
Yep
Awosome
Thanks🙏
How to separate data bar and datapoint in same cell
How did you put that pipeline symbol in excel
To insert the pipeline symbol in Excel, simply press the Shift key and the backslash () key simultaneously. This will result in the appearance of the pipeline symbol (|) in the desired cell. Give it a try!
why I don't find this font in microsoft excel online?
Instead of PIPPING OR Zero can we keep image..ex: bottle
How to copy this chart to powerpoint?
What pipe line?
حلووووو
شكرًا
Which font is this
Playbull
👊
Thanks🙏
You go way too fast thru your step by step even if I replay the video multiple times. It would help if you had text on the side