Show Progress Using an Image in Excel Chart (WordArt Infochart with % completion)
HTML-код
- Опубликовано: 15 июл 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
This video showcases a creative approach to using Excel for visually impactful presentations. The tutorial demonstrates how to conditionally format WordArt to display project completion percentages in a dynamic and visually appealing way. This technique involves manipulating WordArt and Excel features like clustered column charts and linked pictures, without any need for VBA scripting.
⬇️ Download the workbook here: pages.xelplus.com/wordart-exc...
The process starts by setting up a WordArt text box linked to a cell displaying the project's completion percentage. A clustered column chart is then created, representing the percentage completed and the remaining portion. Adjustments are made to overlap the chart bars and to alter the appearance, ensuring the filled part of the bar reflects the completion percentage.
To seamlessly integrate this chart with the WordArt, the tutorial guides you through creating a linked picture of the chart and cropping and rotating it to fit within the WordArt. This results in an innovative presentation element where the percentage completion visually fills up the WordArt, dynamically changing with the project's progress.
The video emphasizes that no advanced programming skills are required, making this technique accessible for regular Excel users. This approach is suitable for enhancing project presentations, making them more engaging and informative. The tutorial concludes by highlighting the ease of grouping and manipulating these elements as a single object within Excel, linked directly to the data source for real-time updates.
This video covers two topics that lets you get creative with Excel:
1. How to have dynamic word art that is controlled with a formula
2. How to create bar in bar Excel charts
As a bonus we put them together to create an info-chart that shows percentage completed of a specific task.
Links to related videos:
Info-charts in Excel: • This Excel Chart will ...
Professional data visualization playlist: bit.ly/2nTDrPx
★ My Online Excel Courses ► www.xelplus.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Grab the file I used in the video from here 👉 pages.xelplus.com/wordart-excel-file
Unbelievable trick and Wow... Thanks for sharing this tips
Love it ,thank you for your explanation
The guys at work are gonna LOVE this! Thanx so much!
Awesome, i loved this brilliant idea & the way you explain. Keep going....
I love your innovative and CREATIVE ideas!! I'm always striving to be different so that the message is noticed!!
That's creativeness!! Superb 👌👌
You make great job that lift up our Excel level to sky. Thankds
Amazing 💕 amazing 💕 👌💜
Thank you so much
I just discovered your channel and love it! Just the level of information I am looking for and explained very clearly. Thanks
I'm very happy to hear you find the content useful! Thanks for your comment.
Thank you so much. I've learned a lot from you generous and amazing tutorials.
You're very welcome Yulin! Very happy to hear you like the videos.
Absolutely fantastic video!! I'm going to use this for a work project
Amazing Trick. Loved it.
Your creativity is amazing, thanks.
I love that Leila, thank you.
Brilliantly done! ❤️❤️
Wow - never knew you could go things like this. Thanks.
excellent explanation, was never aware of such wonderful tricks, thank you LG
Maa shaa Allaah, this is soooooo great
Dear Leila, thank you so much for all tutorials. I'm advanced user in Excel, and your videos help me to use more sophisticated data visualization, to combine several graphs in one image
I'm really glad it is helpful Ninel!
You have the coolest ideas!! I am working on a project for my work and using a ton of your ideas :) Happy Holidays!!
Excelente exemplo, Leila!
Parabéns pela explicação tão bem detalhada e precisa!!!!
You are one of the best
Leila, You are an Excellent Teacher with Brilliant knowledge. Great.....
I'm glad you like the tutorials shaju.
amazing....you are a genius !!! thank you very much
This is the coolest trick I've ever seen about excel.
10 out 10 you make look so easy thank
Wow!
Beautiful idea
Thank you
Thanks. The idea was actually sparkled by a question on the Excel Forum here: www.excelforum.com/excel-charting-and-pivots/1193412-percentage-number-to-have-a-fill-up-to-its-value.html
Awesome, thanks.
Thanks Leila. Excellent!
You're very welcome Jimmy.
I am going to try at work thanks Leila
Way cool % Trick : ) : ) Love it!!
Thank Mike :)
Knew you'd love Leila's work Mike.
I do!!! : ) Leila is awesome! We have such an amazing Online Excel Team!
Thanks Kerry for your support :)
Thank you Mike! I'm very happy to be a part of a great team :)
Really nice videos!
Mind blowing, #hatsoff #respect
Thats Great.... Thanks
Amazing! A very good icon for dashboards, really an eye catcher.
Agree - this will look good on a dashboard.
Besides being very talented you teach incredibly well!. Thanks for sharing it
Thank you for this very nice comment Carlos! Glad to hear it's easy to follow.
That's amazing... Thank you for this video
Sure! Glad you like it.
That is fantastic, well done!!
Thanks Cobus! Glad you like it.
Love it. Thank you very much
You're very welcome!
Great Video Leila as always. Thanks for posting. The picture/camera function is great to resize and probably one of the most under rated functions of excel. Thanks again.
Monte
You're welcome Monte. Yes - very true. They can come in really handy!
It works fine till I put a number in over 83% it then drops visually to around 15% . Please assist
😊 great idea Leila 😊🤗👌👍🌡
Mind blowing actually i believe you are so smart in excel so i'm not surprised by this because excel is your stage and you can do whatever on it thanks again for giving us a new great idea waiting the next video.
Thank you Ismail for the very kind words! I still have a lot to learn in Excel. The fun doesn't end :) Thank you for your support!
U R AMAZING
VERY PROFESSIONAL
VERY TALENTED
I KEEP FOLLOWING U EVERY VIDEO
LEARNING AWESOME TRICKS FROM U
THANK U
I MEAN IT
Thank you for the very kind words and also for the consistent support! Glad you like the content.
very nice video like the others, I love them
Thank you, Really fantastic 👍🏻
You're very welcome.
Thanks Leila for your video sharing.
You're very welcome Jose.
Brilliant
Brilliant Trick !!! I never thought that graph to link with picture - Lovely 🤠🆒️🤙🏻
Glad you find it useful!
Thanks.
a very "handy" work and idea of making presentation eye catching..... Thanks for uploading ......
You're very welcome saad.
Unbelievable. You keep amazing me. You appear to eat and drink Excel. What a blast!!!!! You are an inspiration....
Glad you like the videos! Yeah - me and Excel spend a lot of time together :) ... and I still learn a lot of new things.....
Super...mam..
Nice technique. Definitely adds coolness to a dashboard.
Thanks Sal & for dropping by.
thank you your video so helpful and Thank you ma'am
You're very welcome Parveen. Glad to hear that!
Awesome!
Thanks Malina.
you are genius. thanks
You're welcome! Glad you like it! The credit goes to Excel though :)
Really fantastic
Thanks. Glad you like it.
Super trick !! Love it. Do you have something more than 2 series? tks
awesome
Thanks, very impressive
Glad you like it Ninel!
amazing image linked! i dont know if its useful in the real life but really interesting!!!!!!!
Beautiful Mind
I never though about this before.....what a great tutorial
Glad you like it Reza.
Love you
Thank you! It's absolutely amazing . After your videos I always think "I know that I've known nothing. But now I know!")
Happy to help :)
Beautiful creativity LG🌹
Thanks for dropping by Dev :)
Leila Gharani hey LG plz share yur e-mail.. i have a query I want your help
It's very unique..
Thanks - glad you like it Ritesh.
Incredibleeeeeeeeeeeeee
Superb!!!!!!!!!!!!!!!!!!!. What a great idea!!!!!!!!!!!!!. big salute to my beloved and beautiful teacher. Everday/every week/every video is bringing the innovative ideas & challenging tricks. We are proud of your talent, Madam. May God bless you with good health and some more great ideas.
Thank you so much Gopala for your very kind words and consistent support. You support motivates me to make more videos.
it is awesome... thank you leila
You're very welcome Yasir.
can i have email address to discuss about excel
Coolll trick... Nice one
Glad you like it.
thanks thanks thanks
Hey! I'm the one who email you regard this. U say it will make a good video and i been waiting for it. Cant believe u really make it a video! Cant wait for ur part 2. Thanks for making it a video so that i can know its being done. =)
Hi JP. Yes - I finally did it. Sorry it took this long. Actually, I have to thank you for forwarding me your question - without your question, there would be have been no video on this topic :)
Waw it's a very nice and innovative video ur imagination is too good now I am waiting for your next video what u present in that.
Thanks. The imagination was only triggered from a question on the Excel Forum :)
Awesome
Glad you like it!
Copy linked picture is so cool
What a magic Laila!
Thanks Zahid. Yes - all the magic that can be done with Excel :)
wow amazing thx leila please learn dynamic filter in dashboard thank you
Thanks Ali. Glad you like it. Ok. Will add filter to list.
Thanks for sharing such a great technique.
As usual I will ask if possible to keep the conditionally formatted by the value of the percentage?
Waiting for the next video with full percentage number filling!
You're very welcome. Yes - to keep the conditional formatting for the value as well, we can use VBA - coming up in next week's video.
First, Thanks a lot for your teaching vidéos.
I have the honor to Ask you if it possible to make a drop down liste in Excel that the number of choice (in list) reduces After each selection. Thanks a lot.
Wow
Wow again
Awesome tutorial as usual...thank you so much...I have just couple of queries though...what if % exceeds 100%? And can we have some color effect? What I meant by color effect is...incase % is very low..let's say 12%...it shows in red...and in case it touches 90% it turns green... something like standard conditional formatting....m sure you'll find out some solution for above said queries...
PLZ MAKE VIDEOS ON EXCEL DASHBOARDS
Cool
:)
wow
great idea - could also be used as a progress bar rather than the technique that uses frame and label controls in a user form. I'm guessing this would be less overhead and faster update
That's a good idea actually!
when I rotate the graph, the XLS lines are still present and inclinate, how to make them disappear ?
Hi Leila,
Bravo, encore!!
You should add this to your chart course, it fits right into it! Where did you get the idea for this, this is totally amazing. You're definitely thinking outside the box. I wonder how these techniques can be applied to a pie chart where the pieces of the pie increase as the percentage goes up. In other words, you start showing only a portion of the piece (not the whole pie as it typical) and as you increase or decrease its value only this portion of the piece is being shown. If you have 35% of the total, only 35% is shown and the other 75% is invisible. Do you think this would be possible? I'll add this to the file.
Hi Michael - the idea actually came from a question from JP on the Excel Forum. Here is the link: www.excelforum.com/excel-charting-and-pivots/1193412-percentage-number-to-have-a-fill-up-to-its-value.html
I think the pie chart one can work, by adding a series for the other half (so 1 minus the % of piece) and then making the other half white.... maybe with just a thin black border...
thanks for adding this to the file too :)
This is absolutely brilliant! You are absolutely brilliant! Thank you for this great idea
Hi,
I want to know how to copy range from excel and paste as image format(bitmap) in outlook body of email using VBA
Please help me
You can first export the image and then attach it to an outlook email. I cover this actually in my VBA course with a PDF document. You can do early binding here and activate the outlook reference library. An alternative option is to use the send email option from Excel directly (which uses your default email) - this way you can send a worksheet as an attachment. You could copy the range to a separate tab first - paste as values and attach the Excel sheet if that's an option...
Very clever, but too involved. I'd never use this. Do like to see what can be done with the linked objects.
Can you explain effect like at 0:54 of video?
This is done with VBA. Video that explains this will be out on Thursday.
Thank you :-)
HOW TO DOWNLOAD ALL VIEDOS AT ONCE
You are an Ms office hacker
suberb
Glad you like it Saman.
I cant do 90% .why plz
It might be because your axis is not fixed? Make sure that min for the axis has been put to 0 and that max is 1.
Something happened for me and it didn't work right after 84%
Make sure your min and max axis values is set as shown at 4:30.
I watch these just for fun. Is that weird?
No way. I have fun making these videos. I think that's weird :)