How to Create a Infographic in Excel (pictogram with icons)

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Discover how to make a dynamic infographic or pictogram in Excel! No add-ins or third-party software needed! We'll use standard charts and Excel icons to create professional-looking infographics.
⬇️ Download the workbook here pages.xelplus.com/male-female...
Here's what you'll learn:
Start Simple: Understand the basics of creating a column chart and how to make it dynamic, so it updates automatically with new data.
Chart Types and Series: Learn to pick the right chart type and series for your data, ensuring your pictogram is clear and informative.
Icon Integration: Dive into how to incorporate male and female icons into your chart. Don't worry, you can use any icons you like!
Customization Tips: Get tips on resizing and coloring icons for maximum impact.
Overlap Technique: Master the trick of overlapping series to achieve the fill effect in your chart.
Dynamic Data Labels: Discover how to add and adjust data labels for clarity and precision.
Final Touches: Polish your infographic with a custom title and tidy layout.
★ Links to related videos: ★
Bar chart with icons: • Build Impressive Chart...
3 handy chart tips: • 3 REALLY Useful Excel ...
★ 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

[@LeilaGharani]

Download the chart template I use in the video from here 👉 pages.xelplus.com/male-female-file

[@Dougllastg]

Leila, you're absolutely amazing! The way you explain each detail and step by step. Thank you so much for sharing your knowledge.

[@ckokse]

Great! I love how you can take a fairly boring topic like column charts and make it into something creative and entertaining. Really good stuff.

[@apsellynch]

Guau just... I can't even Express how impressed and thankful I am. You are great.

[@DeltaCherry]

Leila is God sent! This is the only method that worked for my case. My chart needs to reference data in a pivot table and change dynamically based on a user's selection on a slicer. All the other methods I used had a delay or required that the slicer button be pressed twice for it to work. Having everything on one chart like this did the trick! TY

[@billhart4707]

Great video Leila! I have been a self-taught Excel user for many years and am thought to be a “guru” by my peers. I have learned SO MUCH from your videos! You are the true Guru!

[@LeilaGharani]

I'm glad to hear you find my videos useful Bill. I learn something new about Excel almost every day too.

[@jazRock13]

stumbled upon your channel yesterday, and fell in love immediately.. thank you for these awesome excel tips!

[@LeilaGharani]

Thank you! I'm glad you find the tips useful :)

[@alfsilva]

Leila, Great Explanation. Perfect flow if ideas. Many Thanks

[@go2mac]

I love it, tried this method for performance like actual vs target, thing is, when the performance is over 100%, the color overlaps the 100% outline. Very cool tutorial though and thanks.

[@rahulpathare2664]

Amazing.... Simply amazing..... You are the best Excel teacher .... Thanks a lot 😀

[@oshinowoadesola6811]

Great Job! Thanks for the awesome insight. Improving daily

[@yolindaburns3447]

I love your videos! Please make more of these!!!

[@Traveller_Mood_On]

simply superb explanation. i have gone thru many info graphs but this video is simply superb.

[@Teacherman1955]

I really liked your video! It was clear, concise and easy to understand. Your method of presentation was unhurried and I was able to follow the instructions (with a bit of going back to reeview sections I missed the first time around). My finished project functioned as yours did! Thank you so much! I intend to watch other videos in your series and will highly recommend them to others!

[@LeilaGharani]

Glad it was helpful!

[@learnspreadsheets]

This is incredible!!! I’ve been using icons like crazy in PowerPoint but never thought of this idea!

[@LeilaGharani]

Glad you like it :)

[@ryanbarreto5048]

Excellent. It was fun trying this.

[@velmuruganr1491]

WOW ! Bring different shade to chart! Amazing, brilliant! I'm your great fan !

[@LeilaGharani]

Thank you! Glad you like it :)

[@ub9731]

That's perfect, thanks Leila! 👍

[@OzduSoleilDATA]

VERY NICE!!!! Lots of steps but they aren't complicated. I like this. Great video production, as well.

[@LeilaGharani]

Thanks Oz - it's still not the newest version of Cam....

[@Meolimo]

Love it Thanks Leila !

[@ckokse]

thanks for the detailed explanation

[@kb7417]

Awesome!!! Thanks Leila... saved my life.

[@AbhishekTripathidce]

Its really interesting . Keeping me to watch till end and inspire to me make this chart for fun. Thank you so much . You are truly awesome .

[@LeilaGharani]

You are so welcome, Abhishek!

[@dawudayunusfarouk3098]

Thanks for the precise and clear presentation. I am proud of you

[@LeilaGharani]

Thank you Dawuda. Glad you like the tutorial.

[@SuperWolfkin]

I love the chart stuff. Awesome video.

[@LeilaGharani]

Thank you! I love the chart stuff too :)

[@MySpreadsheetLab]

Excellent explanation. Thanks Leila!

[@LeilaGharani]

You’re very welcome Kevin :)

[@ewelinakoscinska8115]

This is a-ma-zing! Really enjoy your way of teaching!!

[@LeilaGharani]

Glad you enjoy it Ewelina!

[@aart_analyst]

Leila, you are brilliant. Love your videos.

[@LeilaGharani]

Glad you like the videos Lester :) Thank you for your support.

[@xlezpk]

Yet another amazing chart trick. Shukria (Thanks) Leila.

[@staceythienel3193]

Your videos/tutorials do NOT disappoint! I LOVE them all!!!!

[@LeilaGharani]

Oh thank you, Stacey!

[@staceythienel3193]

@@LeilaGharani , of course!!! Been home almost 10m on a furlough. Learned a lot of cool stuff :)

[@shillyriser]

I love it!!🤓

[@monte4955]

Awesome as always Leila. Thank you.

[@LeilaGharani]

You're welcome Monte :)

[@vida1719]

Great infographic and good idea to use arrows when explaining

[@LeilaGharani]

Thank you Vida. Glad you like the content & explanation :)

[@DPK2720]

It's very useful thank you Leila..

[@orkunugurlu9967]

Thanks so much needed this for school

[@johnborg6005]

That was Awesome!!! Beautiful Staff Thanks :) :)

[@LeilaGharani]

You're very welcome John :)

[@osamasalah341]

Awesome Leila, how brilliant you are!

[@LeilaGharani]

Glad you like it Osama :) Thanks for dropping by.

[@georgeomondi8406]

Hey Leila, your videos gave me a promotion... You make excel fun to use.

[@LeilaGharani]

Congratulations! I'm really happy to hear that. Watching videos is one thing, but actually implementing what you learn is another. Well done!

[@KKB-tt4lj]

Great as always!

[@LeilaGharani]

Thank you :)

[@vinodcorporate]

Great concept and well explained Thank you somuch

[@LeilaGharani]

You're most welcome

[@jerg83]

Awesome excel skills!. Thanks for sharing!.

[@LeilaGharani]

You're welcome Jorge & thank you. There's always more to learn though - keeps the fun :)

[@justdoit54321]

Very detail explanation - nice work lady!

[@LeilaGharani]

Thank you. Glad you like it!

[@DougHExcel]

Neat trick...thanks for the video!

[@LeilaGharani]

You're welcome Doug :)

[@cavill-3602]

Excelente vídeo, gracias por la información.

[@ezzeldinmostafa3264]

Awesome thanks.

[@mumbaluapula5285]

Thank you very much, I've got it👍

[@mohammedsohail3911]

Great ... thanks for the lesson

[@LeilaGharani]

You're very welcome Mohammed.

[@anshuiway]

Very nice video ur really talented I m just thankful to u that u share it knowledge with us. I always learn from your videos. Your Technics r really awesome. Thanks again.

[@LeilaGharani]

Thank you Anubhav! I'm glad you find the videos useful :)

[@AngeloVijandre]

Hi. Thank you for uploading this video- it’s very helpful. Everything worked for me except that it looks blurred as I pasted the icon to the graph. Any thoughts on how to make it look sharp like yours?

[@petertraynor956]

Brilliant video thankyou. One thing that might be helpful - for some reason when I selected stack and scale unit 1 for one of my icons it looked really odd - it seemed to replicated the icon hundreds of times at a very small size giving it a 'furry' look. I tried various things to fix it, nothing worked until I changed the unit size from 1 to 100 and it looks fine now. It wasn't an issue on the other icon though. Thanks again!

[@rubiedelacruz5353]

Thank you for this Leila, I always learned new things from you. Is there other way where I can used 100% stacked Column using icons also? Can you please share it also with us.

[@LearntoServe]

Great Video.....

[@ismailismaili0071]

thank you Ms. Leila it's a good idea

[@LeilaGharani]

Thank you Ismail for dropping by :)

[@barttitulaerexcelbart9400]

Lots of small techniques in one video. I liked the positioning of the label. Always on top. Therefore you need the 100%. Thank you.

[@LeilaGharani]

You’re welcome Bart. How was the Amsterdam summit?

[@Vikaskumar-tt4om]

Thank you very much to made this video :)

[@LeilaGharani]

You’re very welcome Vikas :)

[@hazemali382]

always great

[@LeilaGharani]

Glad you like it.

[@nononsense129]

Very nice tutorial👍

[@LeilaGharani]

Thank you! Glad you like it :)

[@michaelgnanam]

Super awesome

[@peternganga9371]

Thank you, again.

[@LeilaGharani]

You’re very welcome Peter.

[@Dorcol85]

Thanks for the lessions, makes Excel super fun now :) Bu i have a question can you make everything like this but as a pivot chart ?

[@alejanbdroechezuria]

Wonderfull!

[@LeilaGharani]

Glad you like it Alejandro.

[@mohmmadabdo5899]

Waw I love it

[@johnsonjohn9757]

Super ❤

[@alexandrevanhuysse6675]

Amazing explained! One question does is it possible to divide in multiple ways the male or female icons? So different % in the same icon. Thanks!

[@Luciano_mp]

Muito legal Leila, obrigado.

[@OzduSoleilDATA]

Concordo!

[@thefeminist4389]

Very nice video

[@helalahmed6486]

Hi Leila - Amazing tutorial - How can i add a target line to this infographic chart

[@exceldashboardandvba2155]

Nice trick. Congrats.

[@LeilaGharani]

Thank you!

[@foodcity9875]

Great

[@a14266]

beautiful trick

[@LeilaGharani]

Thank you. Glad you like it.

[@thepreten]

Hey Leila great video, I have a question, as active in the tab insert the icons

[@naadiyahjohnson5585]

I was the second like 😂 almost 1st. I love and appreciate ur videos so much.

[@LeilaGharani]

Thank you Naadiyah :) appreciate the support.

[@steves6557]

Excellent tutorial Leila, as always. 👍 Unfortunately, my version of Office 365 does not have the "Stack and Scale with" option. 😞

[@ZAHIDHUSSAIN-ri5kg]

Very very excellent

[@LeilaGharani]

Thank you Zahid. Glad you like it :)

[@hosseinhosseinpoor4845]

thanks.

[@RahulGohrani]

Very well demonstrated! :)

[@LeilaGharani]

Glad you like it Rahul :)

[@RahulGohrani]

Leila Gharani : Is there anyway we can access SVG Icons even if we are not office 365 subscriber?

[@LeilaGharani]

Yes - you can download them from the net. But you'll need a program to be able to open these and work with them. Otherwise, you can create your icons on PowerPoint (you have a lot more editing options there) and then copy and paste them into Excel.

[@demyramorris9804]

Great video! How do I do this running office 2010 or in google sheets?

[@Iwasns]

Good

[@fulla1]

Awesome video, but I don't like the stretching, which can be seen in the end. Is there an option to make the icons keep their aspect ratio?

[@kharazregistrationcentre864]

Hi, Thanks a lot , How I can Insert female or male icons inside cell.

[@user-eq7dk2lk2d]

thanks sweet queen you are creative person

[@LeilaGharani]

You're very welcome. Thank you for your support.

[@rebeccaedmonds9081]

Great video and I love the result. However, the icons don't stay in the chart when I re-open the file. Do you know why it doesn't save the images?

[@alirezamogharabi8733]

thanks LEILA, Please make videos about different types of infographic charts, like different types of gauge chatrs.

[@LeilaGharani]

Ok Ali - It's on my list. Thanks for your support.

[@hmontazir]

Interesting one - thanks

[@LeilaGharani]

You're very welcome Abdul.

[@magnusolsson1772]

Abdul Hakeem Montazir Top la conditionqwetjlkknq11

[@TheJendog]

Great video. What if you have multiple columns. I have 5 business areas and I want to chart Actual on Plan to show how much has been consumed. Because I have Cap Plan and Cap Act and Exp Plan and Exp Act when I overlay it overlays all four bars onto each other. I want Cap on Cap and Exp on Exp.

[@ashleyserene6846]

I've followed these steps repeatedly and the problem I keep running into is the colored part of the graph isn't filling the icons correctly, it's bigger than the 100% icon so they don't align properly. I'm so frustrated, what am I missing?? I'm using Excel 16.42 for Mac.

[@katvob]

Hi Leila, many thanks for this video. Does this only work as from "office 365"? I now have Excel 2013... Thanks!

[@masreza919]

This tutorial is I always been looking for, thank you so much for this, it helped me alot.... only found minor issue, this icon cannot work for excel 2013. (when i download the icon file, SVG. Excel 2013 is not support this file) but working great at excel 2016.

[@asmust6346]

How I could not found in 2016

[@fahadgilani630]

Thank you LG for very informative video. Also pls let me know how I can insert symbols of man/woman in my excel as picture format like you insert in this video. Thanks

[@LeilaGharani]

You’re welcome. You can download the spreadsheet - you’ll find the link in the description. You can take the pictures from there.

[@saronsattler2056]

Can you also create one that fills from left to right?

[@hyelife0007]

Please create video on "Hover in Excel"

[@sajedezare5219]

Hi, great video thanks. Although I have one problem which I don't understand the reason excel keeps on repeating my picture when I use stack or stack and scale with. Would you please help me?

[@lopher70]

You are completely amazing and beautiful!! I love you :-)

[@LeilaGharani]

Oh thank you Ricardo! Glad you like it :)

[@puneetrai1]

Will i be able to do this MS Office Professional Plus 2013 version?

[@velmuruganr1491]

Is the possible to make vedio on power query?

[@marlar4679]

That's great vdo. But I don't have icons in the insert in my Microsoft office 2013. How to get it? Please help me.

[@soumiamoujane3695]

Great Video. But when I choose overlap, the data shows white not make and female with the correct colours

[@IceRaven0913]

Just wondering if i can use 2 or 3 value

[@ziplesswonder]

Awesome work Leila! Could you point me to the video where you show how you can retain the graphic fill while hiding the columns containing the source data please? I can't remember which one that was but I'm pretty sure you did a video on it.

[@LeilaGharani]

Thank you! I have the link to that video in the description of this one. It's called 3 handy excel chart tips.

[@ziplesswonder]

Leila Gharani Thank you very much!

[@LeilaGharani]

You're welcome.

[@melissayeung227]

Hi Leila, when I select the Stack and stretch option it duplicates the filled icon instead of stretching it to fit the full icon. I am on Microsoft 365. Any advice?