I've been using excel for complex budgets and forecast, and thought I was an advanced user, until I came across your videos, your work , the way you find those solutions, is just impressive , thank you very much for enlightening us :)
Just when you think you know enough about graphs, Leila comes and shows us more interesting stuff!! My takes on this video are the overlapping columns, the copy+paste of shapes and icons and the ctrl+shift+C and ctrl+shift+V. Thanks Leila :)
I've been working with Excel since 2.0 (1988) and I've never considered doing info-graphics before with Excel. This was a very enjoyable tutorial. I've subscribed and banged the bell. Thank you for creating.
Because it's useless. Nobody does this in excel. It takes too much time. There are better softwares that allow you to visualize your data more efficiently.
In case it gets overlap, you can fix the icon using IF condition on Icon value, say upto 15%. That way even though icon goes out of blue shade into grey , it's better than overlap as beyond 15%(15%-0%) the icon stops moving. Ex:=IF(A2-0.05
I LOVE THIS VIDEO!! I have seen other tutorials for similar subjects but never explained in this straight-forward manner, or in such a concise and helpful way. Thank you so much for sharing your knowledge and skills with us!
This is next level wizardry. How have I used Excel for 15 years of school and university and never known this :O RUclips really is the future of learning skills.
A lot of people came here claiming they were really good in Excel and then realised there is so much more going on thanks to Leila... I'm one of them, so happy I found this channel!
Bloody brilliant. Flat out the best how-to excel video I have seen. Those dialogue boxes are so complex I always shy away from messing around with them, but your instructions are so clear you blow away the barrier to getting effective results. A huge thank you..
first, I love this tutorial. I thought I was "pretty good" at excel but these videos show me there is so much more to learn. awesome! Second, I noticed that when I paste the icons on the scatter plot they come out blurry (low resolution). I'm on a mac using an updated version of office 365. has anyone else seen this?
I realize the video has been online for a while but I just wanted to say that your intelligence, perseverance and attention to details are fantastic. Wherever you are, those around you should consider themselves lucky as … vuck
Great, I don''t know what to say, I think all have been said. I am now addicted to videos from your channel! Thank you so much for helping me to get more from excel! I didn't know excel is so rich!
Her videos blow my mind. Excel is Leila's world and we're just living in it. Also, Microsoft take notes... this is great and should be way easier to do.
Wonderful indeed I'll draw some of these for my company. We all should ask MS for an improvement..... preservation of your hard work when you change data sources.
No, no, I do not mean a series of videos... In the video you said chart tricks are often solved with new series values!!! So in the video you created a new series for the people icons... Thus: New Series with People Icons : )
I use pictures and images in the bar, it is very useful for some information belong countries, the bars showing countries flags. , for example for showing population we can use flag picture in the bars
As a Graphic Designer starting the Managment world I have been ask to deliver charts and data that as a visual person can't find a way to present when copying from Excel to Power Point and then try and do some stylisation!! thank you for this video it has oppened my eyes to the "Excel can visualize it as well" onwards to buy your course!! thank you!!
FYI, the shapes only get updated if the new range doesn't overlap the original range - so if you expand it to cover both, and then shrink it, you should be able to keep the formatting.
I also thought I was an expert but I never fail to learn new things from watching her vedios - I also have taken many of her courses over the years. Very easy to follow!
Clear and simple instructions. Easy to follow examples. I also like the tone of your voice. It's not intimidating... it's calming... assuring me that it is simple encouraging that I can do it... Which I've realized, "I CAN!" Thanks.
@@LeilaGharani Whoah!... How nice to hear from you. It was very timely that I discovered your tutorial. Considering the "Stay-At-Home-'til-who-knows-when", your tutorial has made the time worth spending and has definitely brought some sanity in this trying time. Focusing on what I can do is more productive than ranting about the things I'm kept from doing. I've actually scheduled a tutorial a day to have some sense of routine. Through all of this, I"ll be more skilled long after this pandemic. Again, Thanks. Where ever on the side of the globe you may be, I wish you and your family to be safe. I wish all of us well. Cheers!
Hi Leila, im an old excel user, so I am so glad I found yr channel because a lot has changed in excel over the years, and now I really need to learn the new charting features properly and yr videos are a life saver, thanks heaps. 😊 cheers Kev
Question re icon and label overlap when values small: Firstly, thank you for this excellent tip; I tried it and it looks great. My question is, how can one factor in a change in the position of the labels and icons for when the values fall small, so that they don't overlap? For example at 10% the label and icon sit on top of each other. Can a , say, conditional formatting with IF() be used to change the label position to avoid this? Many thanks for all your tutorials, Z Addendum 1: On my sheet when the percentage for one of the chart data series falls below 26% the icon and series label start to overlap. So I changed the Icon's X axis position formula on the spreadsheet to: =IF(B4
You are a God of Excel! Thank you so much. Today I have learned how to make those "NOT your usual Bar Chart" that I was looking for. I have been developing an assessment tool for Operations and this is exactly what I needed to represent score in various elements in a visually appealing and informative manner. Thank you again.
This proves one point, or actually two: That you surely wrote the program code for MS Excel, or that you are actually MS Excel in Human form. Keep Rocking. Thanks.
I just came across this video when searching for help on a project that I am working on. Awesome! Thank you. Your explanations are very easy to follow.
Leila - THANK YOU!!! Your instructions in this video were great. You helped me change a boring bar graph into a cool infographic style chart that got the attention of my senior management.
I don't use Excel for infographics or anything like this, but this video taught me a lot about how graphs work which I'm sure I will find a use for at some point. Awesome video
Super smart use of charts for highly effective data presentation and a concise demo how to do it. Very helpful and highly viewable tutorial. Thank you !
I thought I was an excel God, as I've done some insanely crazy stuff with excel, but your videos show amazing solutions for both really advanced and really simple things. Great job! It goes to show that no matter how advanced someone thinks they are, or actually are, there is always some excel magic that makes things better.
I program in Visual Basic Application with every software in MS Office, but I do not know this awesome feature! Thanks for the video and thanks for give us such creative tips to improve my (for me) advanced use of MS Excel! Great channel!!
I especially rescheduled my routine to just take out some time to learn from your such amazing tutorials. Thumbs up 👍. Keep posting such knowledge base tutorials. Thanks 😊
Your videos are so good! I have learned so much about excel from your instructions. I have been trying to create a simulation basketball game in excel, and these videos have help out soooooo much! The only thing I cannot figure out is how to create a dynamic season schedule with all teams 30 teams.
Where have you been this whole time I was trying to improve my Excel skills?! Leila, thank you so much for helping me be a better professional! Your videos have given me more confidence and I’m always excited to go onto the next. Keep up the amazing work!
Hi Leila, when you adjust or customize the design, you can allways save it as a chart template, so you don't have to format everything again when you need to use it again ;)
![Lethal Company Music Video 🎵 "Follow The Orders" [VERSION A]](http://i.ytimg.com/vi/QeooZB4Z7RA/mqdefault.jpg)
Stay up to date with the latest by signing up to my FREE XelPlus Weekly newsletter: www.xelplus.com/newsletter/
I've been using excel for complex budgets and forecast, and thought I was an advanced user, until I came across your videos, your work , the way you find those solutions, is just impressive , thank you very much for enlightening us :)
Same. I felt so noob watching her videos
She is just too good. I watch her videos every day. I can't get enough
Same here, she is amazing.
Same as me lol
I do agree with you 😅
To avoid charts resetting, you can save the original chart as template and apply that template in the new chart using "change chart type > templates"
Great tip 👌
Just when you think you know enough about graphs, Leila comes and shows us more interesting stuff!! My takes on this video are the overlapping columns, the copy+paste of shapes and icons and the ctrl+shift+C and ctrl+shift+V. Thanks Leila :)
You might be the best tutor who ever existed. Your videos are amazing. Much respect.
Wow, thanks Mohammed!
I've been working with Excel since 2.0 (1988) and I've never considered doing info-graphics before with Excel. This was a very enjoyable tutorial. I've subscribed and banged the bell. Thank you for creating.
I'm glad you liked it. Welcome to the community!
Because it's useless. Nobody does this in excel. It takes too much time. There are better softwares that allow you to visualize your data more efficiently.
@@Thorin632 What other better software did you pay for? You see, the MS package is an affordable option.
The greatest excel tutor in the world
In case it gets overlap, you can fix the icon using IF condition on Icon value, say upto 15%. That way even though icon goes out of blue shade into grey , it's better than overlap as beyond 15%(15%-0%) the icon stops moving. Ex:=IF(A2-0.05
Wao...The more I watch, the more I learn
Thanks Leila
This is brilliant, I had no clue you could change shapes like that!
Impressive. Thanks for your efforts. The best 16.25 mins I spent in internet today
Glad you enjoyed it!
I LOVE THIS VIDEO!! I have seen other tutorials for similar subjects but never explained in this straight-forward manner, or in such a concise and helpful way. Thank you so much for sharing your knowledge and skills with us!
Glad it was helpful Khaled!
I have no words to express my gratitude Leila, Thank you very much!!!! You have no idea how your tutorials have helped me shine!
I love the tone of your voice as well as the content!
Right?? Excel can be super frustrating and unintuitive, but she's always so calm.
Stronger feelings are starting to emerge here.
This is next level wizardry. How have I used Excel for 15 years of school and university and never known this :O
RUclips really is the future of learning skills.
That solution is off the charts!! Just an amazing demonstration of skill.
A lot of people came here claiming they were really good in Excel and then realised there is so much more going on thanks to Leila... I'm one of them, so happy I found this channel!
Great to hear, Serge!
Wow I wish they taught me that kind of stuff in my mastering excel college course. Thank you so much. I will have to check you out on udemy
I am an IT teacher, but after seeing the way you work in Excel. I dont know what to say except that you are a pro
What is this black magic?!?
Awesome tips. I haven't used scatter charts yet. I tend to always use pivot charts but this looks fun.
Bloody brilliant. Flat out the best how-to excel video I have seen. Those dialogue boxes are so complex I always shy away from messing around with them, but your instructions are so clear you blow away the barrier to getting effective results. A huge thank you..
first, I love this tutorial. I thought I was "pretty good" at excel but these videos show me there is so much more to learn. awesome! Second, I noticed that when I paste the icons on the scatter plot they come out blurry (low resolution). I'm on a mac using an updated version of office 365. has anyone else seen this?
Wow! Super! Amazing! Genius! You are simply the best of the best!!!!!! Great work great Chanel!!!!
This is like ASMR to me. Immediately sub
Hahahaha :D this made me laugh so hard, nice
Your English is so clear, I never thought I would get excel lessons like this! Cause english is my third language. Great thank.
This is great and all, but how do I make a turkey in Excel? Thanksgiving is 2 days away and I'm at a loss.
Be careful with what you ask for! Leila might be able to do it using excel haha
😂
🤣🤣🤣
😂😂
67 is what I had in mind, in 2024 this is still relevant, thank you and well done!!
Very Nice Leila. Amazing to watch you construct this, very clever. Thanks for posting the video.
Thank you Monte & you're very welcome.
I realize the video has been online for a while but I just wanted to say that your intelligence, perseverance and attention to details are fantastic. Wherever you are, those around you should consider themselves lucky as … vuck
Wow! It was like watching a celebrity Chef prepare a delicacy! Yummy!
Great, I don''t know what to say, I think all have been said. I am now addicted to videos from your channel! Thank you so much for helping me to get more from excel! I didn't know excel is so rich!
Wow, thank you Charles!
Hi Leila! Congratullations, EXCEllent video!
Thank you! Glad you like it :)
This video is a revelation. I have been working in Excel for decades and had no idea this was possible.
Oh wow, I'm glad it's helpful for you.
This was so easy to follow and understand. Amazing tutorial.
Her videos blow my mind. Excel is Leila's world and we're just living in it. Also, Microsoft take notes... this is great and should be way easier to do.
This is amazing. Thanks for sharing and for making it look easy.
Great ideas and great explanation.
Thank you 🙂
True Sir
This woman RULES! Love her.
Wonderful indeed
I'll draw some of these for my company.
We all should ask MS for an improvement..... preservation of your hard work when you change data sources.
You can copy/paste chart formats. Helps sometimes.
No matter how old the video is...it's simple awesome!!! Good work!!! Thanks!!!
Nicely done Leila. Thanks for sharing
You're very welcome. Thanks for your support.
I thought I was good at Excel but you take it to a new level. 😍👌
I love your calm voice and the way you make it seem so simple. 😉
Thank you, Jan! 😃
So cool: New Series with people pictures : )
That's a good idea :)
No, no, I do not mean a series of videos... In the video you said chart tricks are often solved with new series values!!! So in the video you created a new series for the people icons... Thus: New Series with People Icons : )
Ohhhhhh yeah I see :)
I use pictures and images in the bar, it is very useful for some information belong countries, the bars showing countries flags. , for example for showing population we can use flag picture in the bars
You are amazing Leila, thankss a lot
As a Graphic Designer starting the Managment world I have been ask to deliver charts and data that as a visual person can't find a way to present when copying from Excel to Power Point and then try and do some stylisation!! thank you for this video it has oppened my eyes to the "Excel can visualize it as well" onwards to buy your course!! thank you!!
Thank you so much Leila. God bless you
I never thought that excel charts could look so impressive . Thanks for your hardwork.
FYI, the shapes only get updated if the new range doesn't overlap the original range - so if you expand it to cover both, and then shrink it, you should be able to keep the formatting.
do you know how to fix it? it happens to me when female bar is 90% or 100%
I also thought I was an expert but I never fail to learn new things from watching her vedios - I also have taken many of her courses over the years. Very easy to follow!
Thank you for the kind words and your support of my courses Paul.
I’m wondering how this is going to react when the percentage get around 10% seems like things will get messed up, right?
Had a full semester on Excel in B school but this is awesome. You make it sound so simple
this is so awesome!!
Thanks Joe. Glad you like it.
Leila Gharani actually, i watch basically all of your RUclips videos. It helps me alot
I never dremed excell could be this versatile. Its so much better than i thought.
Totally love your vids 👌
I'm very happy to hear that. Thank you for your support.
Clear and simple instructions. Easy to follow examples. I also like the tone of your voice. It's not intimidating... it's calming... assuring me that it is simple encouraging that I can do it... Which I've realized, "I CAN!" Thanks.
You definitely can! Glad the video is helpful.
@@LeilaGharani Whoah!... How nice to hear from you. It was very timely that I discovered your tutorial. Considering the "Stay-At-Home-'til-who-knows-when", your tutorial has made the time worth spending and has definitely brought some sanity in this trying time. Focusing on what I can do is more productive than ranting about the things I'm kept from doing. I've actually scheduled a tutorial a day to have some sense of routine. Through all of this, I"ll be more skilled long after this pandemic. Again, Thanks. Where ever on the side of the globe you may be, I wish you and your family to be safe. I wish all of us well. Cheers!
I thought I was high level excel user. After watching your videos I realized I am an amateur....🤦🏽♀️🤦🏽♀️🤦🏽♀️🤦🏽♀️🤦🏽♀️
Hi Leila, im an old excel user, so I am so glad I found yr channel because a lot has changed in excel over the years, and now I really need to learn the new charting features properly and yr videos are a life saver, thanks heaps. 😊 cheers Kev
Question re icon and label overlap when values small: Firstly, thank you for this excellent tip; I tried it and it looks great. My question is, how can one factor in a change in the position of the labels and icons for when the values fall small, so that they don't overlap? For example at 10% the label and icon sit on top of each other. Can a , say, conditional formatting with IF() be used to change the label position to avoid this? Many thanks for all your tutorials, Z
Addendum 1: On my sheet when the percentage for one of the chart data series falls below 26% the icon and series label start to overlap. So I changed the Icon's X axis position formula on the spreadsheet to: =IF(B4
Could you please link the additional video which you refer to in your addendum? I am quite curious about it.
Unbelievable what excel can do!! So complicated and u teach all this so easily!
The icon will overlap when the value goes below 10 percent, How to fix the same?
I was wondering the same
In your lessons everything is so neat and accurate ... I am impressed! Congrats.
Thank you, Matteo! 😃
Why there are Dislikes / Thumb downs!!!??? Must be from JEALOUS persons!!!
I was thinking the same thing. Some people just have no good intentions. Well done!
They thought it was the download button!
Always loved playing around data in excel but your videos are now turning love to addiction. Great tutorials. Highly recommended.
I'm happy to hear that :)
I love you
I will surely suggest everyone in my circle to learn excel from your videos. You are amazing
You are a God of Excel! Thank you so much. Today I have learned how to make those "NOT your usual Bar Chart" that I was looking for. I have been developing an assessment tool for Operations and this is exactly what I needed to represent score in various elements in a visually appealing and informative manner. Thank you again.
Amazing Excel skills. Simply following your videos would help learning the Excel skills and trouble shooting too. 100% likes speaks for itself.
This proves one point, or actually two: That you surely wrote the program code for MS Excel, or that you are actually MS Excel in Human form.
Keep Rocking. Thanks.
I'm actually part of a secret government program but don't tell anyone :)
@@LeilaGharani lol. Surely won't.
I just came across this video when searching for help on a project that I am working on. Awesome! Thank you. Your explanations are very easy to follow.
We do not like only this video, we like all your videos and we like all. Very impressive videos. Thank you
Thank you so much 😀
The copy and paste of a format for boxes is an eye opener
You are the goddess of Excel.
I'm going to cry with joy this is amazing
😁
excellent trick. That was very helpful I used to do such staffs in excel but not with dynamic icons. That was a cherry on top.
Thank you so much !
Glad you like it :)
You are the best excel teacher on the net… great , thx
Your excel knowledge is legendary! Thank you Leila!
Leila - THANK YOU!!! Your instructions in this video were great. You helped me change a boring bar graph into a cool infographic style chart that got the attention of my senior management.
That‘s great Brian!
Leila - I so appreciate your videos. You have reignited a lost passion I once had with excel. Thank you!
I'm glad to hear I was able to rekindle that passion :)
I followed this step-by-step. It worked, but it's a lot of steps. Either way, the end result looks terrific.
Great you stuck with it to the end. I think it is nice, different chart.
Wow, I never saw that coming! You're one piece of work lady. Keep on the great work.
I don't use Excel for infographics or anything like this, but this video taught me a lot about how graphs work which I'm sure I will find a use for at some point. Awesome video
Super smart use of charts for highly effective data presentation and a concise demo how to do it. Very helpful and highly viewable tutorial. Thank you !
You're very welcome Michael. Thank you for your support.
Extraordinary! dynamic infographics, and it can be done using Excel!
I'm a student and all I do is struggle with Ms Excel but you blessed me with this wonderful techniques to make study easy...
Thank you so much....❤️
My pleasure. I'm glad it's helpful.
Hi Leila, I love your content! ❤️I hope to become an excel guru like you one day. You inspire so many people and as a female I’m really motivated.
A truly fantastic tutorial. Taught in a way that’s beneficial to pros and folks that don’t know a thing. Thank you for your engaging videos.
Glad you enjoyed it, Jonathan!
Ms. Leila You are literally AWESOME🔥🔥🔥
It was too much fun watching it and practicing it... Thank you soo very much💓💓
So glad!
I have no idea, why the 188 people dislike this awesome video tutorial? 😥
Your videos are always a lifesaver! I'm so thankful you post them.
I'm happy the tutorials are helpful Alexei.
i almost never leave comments but this is super helpful and so well explained I just had to. Thank you so much, really appreciate your videos
You're very welcome Mike. Many thanks for the great feedback!
I thought I was an excel God, as I've done some insanely crazy stuff with excel, but your videos show amazing solutions for both really advanced and really simple things. Great job!
It goes to show that no matter how advanced someone thinks they are, or actually are, there is always some excel magic that makes things better.
Very true. I'm also constantly learning new things about Excel :)
I program in Visual Basic Application with every software in MS Office, but I do not know this awesome feature! Thanks for the video and thanks for give us such creative tips to improve my (for me) advanced use of MS Excel! Great channel!!
Wow, I'm really happy to hear that Daniele! You're very welcome. I'm glad the video is helpful.
I especially rescheduled my routine to just take out some time to learn from your such amazing tutorials. Thumbs up 👍. Keep posting such knowledge base tutorials. Thanks 😊
Wow, that's great. Thanks for the thumbs up.
Top notch teaching. Very useful for a begineer excel user
Your videos are so good! I have learned so much about excel from your instructions. I have been trying to create a simulation basketball game in excel, and these videos have help out soooooo much! The only thing I cannot figure out is how to create a dynamic season schedule with all teams 30 teams.
Great to hear!
Where have you been this whole time I was trying to improve my Excel skills?! Leila, thank you so much for helping me be a better professional! Your videos have given me more confidence and I’m always excited to go onto the next. Keep up the amazing work!
I'm glad the videos are helpful. Many thanks for your support.
Excellent! I loved the use of scatter chart to set the dynamic icon. Very impressed.
Very interesting to see how you copied and applied the shape form to the chart bars. That was an unexpected feature. Thanks for sharing!
You’re very welcome Johan.
I'm an instant subscriber. Your presentation is SO easy to follow. Thank you so much for sharing. You have a new fan.
Glad to hear that. Welcome aboard!
Hi Leila, when you adjust or customize the design, you can allways save it as a chart template, so you don't have to format everything again when you need to use it again ;)
Thanks Leila; always a pleasure learning from a pro....
You're welcome Rebecca. Thanks for watching!
not just easy to understand, but the tone of your voice make it the video so pleasant to watch, direct subs n like
Thank you so much 😀