Build Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Unlock the power of info charts in Excel with our comprehensive guide! Whether you're a beginner or a seasoned Excel user, this tutorial is packed with insights to help you create dynamic and visually appealing info charts. From basic setups to incorporating symbols and ensuring dynamic updates, we've got you covered.
📊 What You'll Discover:
▪️ Creating Clustered Bar Charts: Learn how to set up and manipulate clustered bar charts for the foundation of your info chart.
▪️ Incorporating Rounded Edges: Add a touch of style with rounded edges for a sleek and modern look.
▪️ Dynamic Symbol Integration: Seamlessly integrate symbols into your chart and make them dynamic with real-time data updates.
▪️ Customizing Data Labels: Enhance readability with customized data labels, tailored to your chart's needs.
Create better Excel reports by improving your existing charts with the smart use of Icons.
In this video you learn how to create a bar chart that includes the male/female icon in a dynamic way (I will also show you how you can add shapes inside charts - this way, you can change your series to look like any shape of your choice) - you can of course replace these icons with any icon of your choice. You could for example use images of your products.
This is an example of how you can use some chart tricks that allow you to create infographics or infocharts in Excel. You don't need to stick to the default chart types, you can improve on these to fit your corporate reporting style.
00:00 Info Charts in Excel
00:43 Prepare Clustered Bar Chart
04:09 Created Rounded Edges for Bar Chart
05:50 Add Data Label to Bar Chart
06:54 Insert Icons to Bar Chart
08:06 Dynamic Placement of Icon
★ Links to related videos: ★
Special Excel Charts: • This Excel Chart will ...
➡️ Join this channel to get access to perks: / @leilagharani
🎓 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
Пікірлер: 1 000
Stay up to date with the latest by signing up to my FREE XelPlus Weekly newsletter: www.xelplus.com/newsletter/
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"
@janskov9309
3 жыл бұрын
Great tip 👌
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 :)
@markevinlagsac3252
5 жыл бұрын
Same. I felt so noob watching her videos
@Sakhilemtimande
5 жыл бұрын
She is just too good. I watch her videos every day. I can't get enough
@gagandeepsaini9736
4 жыл бұрын
Same here, she is amazing.
@ruzaqir354
4 жыл бұрын
Same as me lol
@gcorbalan
4 жыл бұрын
I do agree with you 😅
This is brilliant, I had no clue you could change shapes like that!
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
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 :)
That solution is off the charts!! Just an amazing demonstration of skill.
This is amazing. Thank you for sharing with us.
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..
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!
@LeilaGharani
4 жыл бұрын
Glad it was helpful Khaled!
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
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?
Thank you so much Leila. God bless you
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.
@NietzscheanMan
4 жыл бұрын
You can copy/paste chart formats. Helps sometimes.
This is amazing. Thanks for sharing and for making it look easy. Great ideas and great explanation. Thank you 🙂
@usefullguide8634
Жыл бұрын
True Sir
Thanks. Again, a great example with a much simpler process than I thought.
I have no words to express my gratitude Leila, Thank you very much!!!! You have no idea how your tutorials have helped me shine!
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.
I love the tone of your voice as well as the content!
@baphnie
5 жыл бұрын
Right?? Excel can be super frustrating and unintuitive, but she's always so calm.
@ranevc
5 жыл бұрын
Stronger feelings are starting to emerge here.
Ultimate impressiveness as always! Taken one of your courses on Macros and will definitely be adventuring to complete some more of them. Keep it up you are helping us all!
This is like ASMR to me. Immediately sub
@nickedwards8132
4 жыл бұрын
Hahahaha :D this made me laugh so hard, nice
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.
@LeilaGharani
5 жыл бұрын
I'm glad you liked it. Welcome to the community!
@Thorin632
2 жыл бұрын
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.
@jameslucas5590
2 жыл бұрын
@@Thorin632 What other better software did you pay for? You see, the MS package is an affordable option.
Very Nice Leila. Amazing to watch you construct this, very clever. Thanks for posting the video.
@LeilaGharani
6 жыл бұрын
Thank you Monte & you're very welcome.
Excellent! Very pleasant to listen to your tutorials. You make it easy for us! Thank you!
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.
Hi Leila! Congratullations, EXCEllent video!
@LeilaGharani
6 жыл бұрын
Thank you! Glad you like it :)
Nicely done Leila. Thanks for sharing
@LeilaGharani
6 жыл бұрын
You're very welcome. Thanks for your support.
Fantastic! Thank you for this tutorial. Definitely going to use this idea at my workplace.
I knew this is going to be handy for me someday. I will be using this chart is in my current project. I just tweaked the source data so it would be dynamic as well (i.e. excel table, pivot) and so I could use slicers. Thank you so much Leila! 😉
So cool: New Series with people pictures : )
@LeilaGharani
6 жыл бұрын
That's a good idea :)
@excelisfun
6 жыл бұрын
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 : )
@LeilaGharani
6 жыл бұрын
Ohhhhhh yeah I see :)
@azarshir1
6 жыл бұрын
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
@azarshir1
6 жыл бұрын
You are amazing Leila, thankss a lot
Wow! It was like watching a celebrity Chef prepare a delicacy! Yummy!
Hi Leila, thank you so much for your videos. It helps me to achieve my goals in office. I am learning a lot from your videos. Keep it up 😊
Another great video, thank you, I now know that ctl+shift+ c & v copies and paste formatting only, Awesome tip, thanks Leila!
This was so easy to follow and understand. Amazing tutorial.
Totally love your vids 👌
@LeilaGharani
6 жыл бұрын
I'm very happy to hear that. Thank you for your support.
Thanks so much for your very helpful tricks and clear explanation. Just discovered your videos this morning, I tried the bar shaping tips, and now the male and female ones, definitely will use them in my next presentations, and share your videos .
You might be the best tutor who ever existed. Your videos are amazing. Much respect.
@LeilaGharani
3 жыл бұрын
Wow, thanks Mohammed!
this is so awesome!!
@LeilaGharani
6 жыл бұрын
Thanks Joe. Glad you like it.
@_pr0xy
6 жыл бұрын
Leila Gharani actually, i watch basically all of your KZread videos. It helps me alot
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.
@ejimenezc
Жыл бұрын
do you know how to fix it? it happens to me when female bar is 90% or 100%
BTW - the way you explain things is next level... Stay blessed.
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
I’m wondering how this is going to react when the percentage get around 10% seems like things will get messed up, right?
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.
@luissamaniego2690
3 жыл бұрын
Be careful with what you ask for! Leila might be able to do it using excel haha
@SpeakingAmericanTruth
2 жыл бұрын
😂
@josephohiani6164
Жыл бұрын
🤣🤣🤣
@henrytibiita6170
Жыл бұрын
😂😂
Great knowledge you share with the public. Thank you so much for making us know the unknown things in excel. Knowledge with beauty 👍
This is so inventive. Thanks very much for that insight Leila.
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
@sebastians5691
4 жыл бұрын
Could you please link the additional video which you refer to in your addendum? I am quite curious about it.
I love you
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.
Very good! You never cease to amaze me with your Excel knowledge!
The icon will overlap when the value goes below 10 percent, How to fix the same?
@tristenstaas7138
4 жыл бұрын
I was wondering the same
I thought I was high level excel user. After watching your videos I realized I am an amateur....🤦🏽♀️🤦🏽♀️🤦🏽♀️🤦🏽♀️🤦🏽♀️
This tutorial is really impressive and informative. I love it! 🥰 Thank you for sharing your knowledge👏❤️
@LeilaGharani
4 жыл бұрын
Glad you enjoyed it, Emma!
I have learned so much from you! Thank you!
Why there are Dislikes / Thumb downs!!!??? Must be from JEALOUS persons!!!
@VAMikeJr
4 жыл бұрын
I was thinking the same thing. Some people just have no good intentions. Well done!
@clearsailing7993
4 жыл бұрын
They thought it was the download button!
Your excel knowledge is legendary! Thank you Leila!
Excellent! I loved the use of scatter chart to set the dynamic icon. Very impressed.
So cool!!! Excellent!! I’ve never imagine that kind of charts can be done with excel. Thanks.
Excelente técnica, gran vídeo te felicito y agradezco por compartir tu conocimiento. 👏🏻👍🏻
thank you for sharing, apreciate and I want to learning more from you
Leila - love your videos - very detailed and easy to follow
Wow, this is so cool, You always shows great workaround in excel. Thank you!
this is a great video and excellent instruction, thank you
You make things seem easy, well presented kudos!
@LeilaGharani
5 жыл бұрын
I'm glad you like it.
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.
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!
@LeilaGharani
5 жыл бұрын
I'm glad the videos are helpful. Many thanks for your support.
Wow! beautifully simple and beautifully explained. Thank you.
As always you are awesome. Thank you. Would like to see you creating more of these charts.
Phenomenal. Nice way to give great looks to charts. Thank you.
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.
@LeilaGharani
5 жыл бұрын
That‘s great Brian!
outstanding! I learn so much from your work
Wao...The more I watch, the more I learn Thanks Leila
In your lessons everything is so neat and accurate ... I am impressed! Congrats.
@LeilaGharani
3 жыл бұрын
Thank you, Matteo! 😃
amazing video! thank you very much Leila!
Ms. Leila You are literally AWESOME🔥🔥🔥 It was too much fun watching it and practicing it... Thank you soo very much💓💓
@LeilaGharani
4 жыл бұрын
So glad!
Wow, literally mindblowed :o great video!
Good tips, this was really helpful, it was explained straight forward and now my excel spreadsheet will look more organized :D
Had a full semester on Excel in B school but this is awesome. You make it sound so simple
These are perfect usefull tricks for me. Thank you Leila.
Wow! Super! Amazing! Genius! You are simply the best of the best!!!!!! Great work great Chanel!!!!
That was awesome, thank you!
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 !
@LeilaGharani
5 жыл бұрын
You're very welcome Michael. Thank you for your support.
I just found your channel yesterday and holy moly, I am so glad! Thank you!
@LeilaGharani
5 жыл бұрын
I'm glad you found us. Great to have you here!
Excelente video corto y preciso, gracias.
This is super cool. Ever since I started watching your Excel Videos, my skills have improved a lot. Thanks for your immense contribution to my learning to be proficient in Excel.
@LeilaGharani
6 жыл бұрын
This is great! I'm very happy you've learnt new stuff from my channel which you can apply to your work. Applying the learnt stuff is the hard part though. Well done on your part!
Incredible! Thanks for sharing!
Tx for this! Cool way to spice up data presentation in reports.
This is so extremely useful! Thank you.
thank you, you speak clearly and you are specific
Bundle of thanks mam nice video
Thank you Leila, this video is very helpful and very clearly in step to follow up :)
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 😊
@LeilaGharani
4 жыл бұрын
Wow, that's great. Thanks for the thumbs up.
the best explanation with easy understanding way. Thanks for sharing
@LeilaGharani
5 жыл бұрын
You're very welcome.
Leila I love your channel and the way you explain everything so easily! Amazing
@LeilaGharani
5 жыл бұрын
I'm very glad to hear that Humberto!
Excellent, cheers from Honduras! Thank u for sharing
Thanks Leila..much appreciated!
No matter how old the video is...it's simple awesome!!! Good work!!! Thanks!!!
Simply amazing. Thank you.
Your videos are always a lifesaver! I'm so thankful you post them.
@LeilaGharani
5 жыл бұрын
I'm happy the tutorials are helpful Alexei.
Wow....this is simply awesome. Thanks for sharing
Your videos are amazing! I'm learning so much! I thought I already knew a lot until I came across these... It got me really excited and inspired! Please keep uploading more! Thanks for sharing your talent with us! :D
@LeilaGharani
4 жыл бұрын
Thanks for the kind feedback Arlene.