Build Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)

Рет қаралды 1,281,311

Күн бұрын

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

@LeilaGharani 9 ай бұрын

Stay up to date with the latest by signing up to my FREE XelPlus Weekly newsletter: www.xelplus.com/newsletter/

@sujithkamath 3 жыл бұрын

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 👌

@FernandoMoreiraR 5 жыл бұрын

This is brilliant, I had no clue you could change shapes like that!

@GavinCohen 5 күн бұрын

67 is what I had in mind, in 2024 this is still relevant, thank you and well done!!

@PrayEndureLove 2 жыл бұрын

You might be the best tutor who ever existed. Your videos are amazing. Much respect.

@LeilaGharani 2 жыл бұрын

Wow, thanks Mohammed!

@redouanegipsy 5 жыл бұрын

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 4 жыл бұрын

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 😅

@dylanlangley833 5 жыл бұрын

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

@abdul-azeezolohunjuwon3588 2 жыл бұрын

Wao...The more I watch, the more I learn Thanks Leila

@ikhind 2 жыл бұрын

Wow! Super! Amazing! Genius! You are simply the best of the best!!!!!! Great work great Chanel!!!!

@costaspetrides2848 4 жыл бұрын

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 :)

@kaml005 5 жыл бұрын

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

@sudharshannandakumar5314 Жыл бұрын

Impressive. Thanks for your efforts. The best 16.25 mins I spent in internet today

@LeilaGharani Жыл бұрын

Glad you enjoyed it!

@milky2sugars 3 жыл бұрын

The greatest excel tutor in the world

@mymatemartin 4 жыл бұрын

That solution is off the charts!! Just an amazing demonstration of skill.

@educacionportable 5 жыл бұрын

Thank you so much Leila. God bless you

@trowawayacc 2 жыл бұрын

I never dremed excell could be this versatile. Its so much better than i thought.

@Muzi74 2 жыл бұрын

You are the best excel teacher on the net… great , thx

@paulwaul2623 5 жыл бұрын

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?

@Amr-Ibrahim-AI 5 жыл бұрын

This is amazing. Thanks for sharing and for making it look easy. Great ideas and great explanation. Thank you 🙂

@usefullguide8634 Жыл бұрын

True Sir

@rafaelacosta4078 2 жыл бұрын

I only regret I didn’t find this channel before Great content

@muhammadaleemkhan4011 2 жыл бұрын

We do not like only this video, we like all your videos and we like all. Very impressive videos. Thank you

@LeilaGharani 2 жыл бұрын

Thank you so much 😀

@whamidi 5 жыл бұрын

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 4 жыл бұрын

Stronger feelings are starting to emerge here.

@TastySanchez 5 жыл бұрын

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.

@katrinesofialind649 2 жыл бұрын

This is next level wizardry. How have I used Excel for 15 years of school and university and never known this :O KZfaq really is the future of learning skills.

@arigetas 2 жыл бұрын

I have no idea, why the 188 people dislike this awesome video tutorial? 😥

@Noname-iz9uo 5 жыл бұрын

This is like ASMR to me. Immediately sub

@nickedwards8132 4 жыл бұрын

Hahahaha :D this made me laugh so hard, nice

@KhaledSalehwanderer 4 жыл бұрын

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!

@SeniorEliteStrike 4 жыл бұрын

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.

@LeilaGharani 4 жыл бұрын

I'm actually part of a secret government program but don't tell anyone :)

@SeniorEliteStrike 4 жыл бұрын

@@LeilaGharani lol. Surely won't.

@fifitomanalotto5887 3 жыл бұрын

You are the goddess of Excel.

@monte4955 6 жыл бұрын

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.

@PaulVass1 6 жыл бұрын

Nicely done Leila. Thanks for sharing

@LeilaGharani 6 жыл бұрын

You're very welcome. Thanks for your support.

@XavierFsc 5 жыл бұрын

Thanks. Again, a great example with a much simpler process than I thought.

@marianarossicampos6263 Жыл бұрын

This woman RULES! Love her.

@jameslucas5590 5 жыл бұрын

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 Жыл бұрын

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 Жыл бұрын

@@Thorin632 What other better software did you pay for? You see, the MS package is an affordable option.

@eduardosuela7291 5 жыл бұрын

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.

@newlookak47 4 жыл бұрын

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

@ConstantineIsslamow 5 жыл бұрын

This is amazing. Thank you for sharing with us.

@cursodeexcelonline 6 жыл бұрын

Hi Leila! Congratullations, EXCEllent video!

@LeilaGharani 6 жыл бұрын

Thank you! Glad you like it :)

@jego207 5 жыл бұрын

This was so easy to follow and understand. Amazing tutorial.

@SunshineDT2010 2 жыл бұрын

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!

@sushaanthsrinivasan3022 2 жыл бұрын

Top notch teaching. Very useful for a begineer excel user

@_pr0xy 6 жыл бұрын

this is so awesome!!

@LeilaGharani 6 жыл бұрын

Thanks Joe. Glad you like it.

@_pr0xy 6 жыл бұрын

Leila Gharani actually, i watch basically all of your KZfaq videos. It helps me alot

@MohammedAnsariRiz 5 жыл бұрын

Wow! It was like watching a celebrity Chef prepare a delicacy! Yummy!

@sergecharlebois6114 3 жыл бұрын

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!

@LeilaGharani 3 жыл бұрын

Great to hear, Serge!

@user-gd6bp7jf6b 2 жыл бұрын

Your English is so clear, I never thought I would get excel lessons like this! Cause english is my third language. Great thank.

@911alps 6 жыл бұрын

Totally love your vids 👌

@LeilaGharani 6 жыл бұрын

I'm very happy to hear that. Thank you for your support.

@excelisfun 6 жыл бұрын

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

@marcusdutton1808 2 жыл бұрын

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..

@fernandoferrer1234 2 жыл бұрын

I have no words to express my gratitude Leila, Thank you very much!!!! You have no idea how your tutorials have helped me shine!

@viksra 5 жыл бұрын

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 2 жыл бұрын

Be careful with what you ask for! Leila might be able to do it using excel haha

@SpeakingAmericanTruths Жыл бұрын

😂

@josephohiani6164 Жыл бұрын

🤣🤣🤣

@henrytibiita6170 Жыл бұрын

😂😂

@WillBrigg 4 жыл бұрын

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%

@gintomino4136 5 жыл бұрын

Excellent! Very pleasant to listen to your tutorials. You make it easy for us! Thank you!

@kuuuyajim 2 жыл бұрын

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! 😉

@zuzanaschmidtova9564 4 жыл бұрын

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.

@numba1druma1 3 жыл бұрын

I’m wondering how this is going to react when the percentage get around 10% seems like things will get messed up, right?

@sandipballav 5 жыл бұрын

Fantastic! Thank you for this tutorial. Definitely going to use this idea at my workplace.

@ziggymasternak586 Жыл бұрын

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.

@onioni6121 6 жыл бұрын

I love you

@NopeJustMe 4 жыл бұрын

I thought I was high level excel user. After watching your videos I realized I am an amateur....🤦🏽‍♀️🤦🏽‍♀️🤦🏽‍♀️🤦🏽‍♀️🤦🏽‍♀️

@DanKnight 2 жыл бұрын

Excellent! I loved the use of scatter chart to set the dynamic icon. Very impressed.

@domxem5551 Жыл бұрын

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

@santhoshcbe4678 4 жыл бұрын

The icon will overlap when the value goes below 10 percent, How to fix the same?

@tristenstaas7138 3 жыл бұрын

I was wondering the same

@newtjude2689 4 жыл бұрын

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!

@mengxiying5445 5 жыл бұрын

I have learned so much from you! Thank you!

@iana1083 8 ай бұрын

Thank you now I realized that the scatter thing would be an answer to my chart that I've been struggling with

@NathanWalz-hh2ck 8 ай бұрын

Your excel knowledge is legendary! Thank you Leila!

@rgarlinyc 4 жыл бұрын

Very good! You never cease to amaze me with your Excel knowledge!

@angadmadra3123 2 жыл бұрын

Incredible! Thanks for sharing!

@safalarhrissi7709 4 жыл бұрын

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 .

@mazarata73 5 жыл бұрын

This is so inventive. Thanks very much for that insight Leila.

@kiwikevnz Жыл бұрын

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

@jamespiazza7753 Жыл бұрын

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.

@peterstegeby 4 жыл бұрын

Wow, literally mindblowed :o great video!

@blankmedia01 3 жыл бұрын

I'm going to cry with joy this is amazing

@LeilaGharani 3 жыл бұрын

😁

@josefelicianocpimcscp3411 5 жыл бұрын

Leila - love your videos - very detailed and easy to follow

@maantunez 3 жыл бұрын

So cool!!! Excellent!! I’ve never imagine that kind of charts can be done with excel. Thanks.

@indradevdubey 3 жыл бұрын

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 😊

@furtadorebeca 2 жыл бұрын

Phenomenal. Nice way to give great looks to charts. Thank you.

@neldopardoyuvero5181 3 жыл бұрын

No matter how old the video is...it's simple awesome!!! Good work!!! Thanks!!!

@emmafeng55 2 жыл бұрын

So cool and fun! Thanks Leila!

@tomasfreitas5673 5 жыл бұрын

thank you for sharing, apreciate and I want to learning more from you

@GordonWafimbi 5 жыл бұрын

Another great video, thank you, I now know that ctl+shift+ c & v copies and paste formatting only, Awesome tip, thanks Leila!

@TS-yy6jb 4 жыл бұрын

Thanks Leila..much appreciated!

@michaelreis7435 3 жыл бұрын

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.