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
Пікірлер: 193
Download the chart template I use in the video from here 👉 pages.xelplus.com/male-female-file
Leila, you're absolutely amazing! The way you explain each detail and step by step. Thank you so much for sharing your knowledge.
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.
Guau just... I can't even Express how impressed and thankful I am. You are great.
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
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
5 жыл бұрын
I'm glad to hear you find my videos useful Bill. I learn something new about Excel almost every day too.
Amazing.... Simply amazing..... You are the best Excel teacher .... Thanks a lot 😀
Leila, Great Explanation. Perfect flow if ideas. Many Thanks
simply superb explanation. i have gone thru many info graphs but this video is simply superb.
stumbled upon your channel yesterday, and fell in love immediately.. thank you for these awesome excel tips!
@LeilaGharani
6 жыл бұрын
Thank you! I'm glad you find the tips useful :)
Great Job! Thanks for the awesome insight. Improving daily
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
2 жыл бұрын
Glad it was helpful!
That's perfect, thanks Leila! 👍
I love your videos! Please make more of these!!!
Excellent. It was fun trying this.
This is incredible!!! I’ve been using icons like crazy in PowerPoint but never thought of this idea!
@LeilaGharani
6 жыл бұрын
Glad you like it :)
WOW ! Bring different shade to chart! Amazing, brilliant! I'm your great fan !
@LeilaGharani
6 жыл бұрын
Thank you! Glad you like it :)
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.
Awesome!!! Thanks Leila... saved my life.
Love it Thanks Leila !
Your videos/tutorials do NOT disappoint! I LOVE them all!!!!
@LeilaGharani
3 жыл бұрын
Oh thank you, Stacey!
@staceythienel3193
3 жыл бұрын
@@LeilaGharani , of course!!! Been home almost 10m on a furlough. Learned a lot of cool stuff :)
thanks for the detailed explanation
VERY NICE!!!! Lots of steps but they aren't complicated. I like this. Great video production, as well.
@LeilaGharani
6 жыл бұрын
Thanks Oz - it's still not the newest version of Cam....
This is a-ma-zing! Really enjoy your way of teaching!!
@LeilaGharani
4 жыл бұрын
Glad you enjoy it Ewelina!
Yet another amazing chart trick. Shukria (Thanks) Leila.
I love it!!🤓
I love the chart stuff. Awesome video.
@LeilaGharani
6 жыл бұрын
Thank you! I love the chart stuff too :)
It's very useful thank you Leila..
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
4 жыл бұрын
You are so welcome, Abhishek!
Thanks for the precise and clear presentation. I am proud of you
@LeilaGharani
6 жыл бұрын
Thank you Dawuda. Glad you like the tutorial.
Excelente vídeo, gracias por la información.
Thanks so much needed this for school
Excellent explanation. Thanks Leila!
@LeilaGharani
6 жыл бұрын
You’re very welcome Kevin :)
Leila, you are brilliant. Love your videos.
@LeilaGharani
6 жыл бұрын
Glad you like the videos Lester :) Thank you for your support.
Awesome as always Leila. Thank you.
@LeilaGharani
6 жыл бұрын
You're welcome Monte :)
Awesome Leila, how brilliant you are!
@LeilaGharani
6 жыл бұрын
Glad you like it Osama :) Thanks for dropping by.
That was Awesome!!! Beautiful Staff Thanks :) :)
@LeilaGharani
6 жыл бұрын
You're very welcome John :)
Great concept and well explained Thank you somuch
@LeilaGharani
Жыл бұрын
You're most welcome
Great infographic and good idea to use arrows when explaining
@LeilaGharani
6 жыл бұрын
Thank you Vida. Glad you like the content & explanation :)
Great as always!
@LeilaGharani
6 жыл бұрын
Thank you :)
Thank you very much, I've got it👍
Awesome excel skills!. Thanks for sharing!.
@LeilaGharani
6 жыл бұрын
You're welcome Jorge & thank you. There's always more to learn though - keeps the fun :)
Very detail explanation - nice work lady!
@LeilaGharani
6 жыл бұрын
Thank you. Glad you like it!
Hey Leila, your videos gave me a promotion... You make excel fun to use.
@LeilaGharani
6 жыл бұрын
Congratulations! I'm really happy to hear that. Watching videos is one thing, but actually implementing what you learn is another. Well done!
Awesome thanks.
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
6 жыл бұрын
Thank you Anubhav! I'm glad you find the videos useful :)
Great ... thanks for the lesson
@LeilaGharani
6 жыл бұрын
You're very welcome Mohammed.
Neat trick...thanks for the video!
@LeilaGharani
6 жыл бұрын
You're welcome Doug :)
thank you Ms. Leila it's a good idea
@LeilaGharani
6 жыл бұрын
Thank you Ismail for dropping by :)
I was the second like 😂 almost 1st. I love and appreciate ur videos so much.
@LeilaGharani
6 жыл бұрын
Thank you Naadiyah :) appreciate the support.
Muito legal Leila, obrigado.
@OzduSoleilDATA
6 жыл бұрын
Concordo!
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?
Super ❤
Super awesome
Thank you very much to made this video :)
@LeilaGharani
6 жыл бұрын
You’re very welcome Vikas :)
always great
@LeilaGharani
5 жыл бұрын
Glad you like it.
Thank you, again.
@LeilaGharani
6 жыл бұрын
You’re very welcome Peter.
Waw I love it
Great Video.....
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.
Very nice tutorial👍
@LeilaGharani
6 жыл бұрын
Thank you! Glad you like it :)
Wonderfull!
@LeilaGharani
5 жыл бұрын
Glad you like it Alejandro.
Nice trick. Congrats.
@LeilaGharani
6 жыл бұрын
Thank you!
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
6 жыл бұрын
You’re welcome Bart. How was the Amsterdam summit?
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!
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 ?
Very nice video
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!
beautiful trick
@LeilaGharani
6 жыл бұрын
Thank you. Glad you like it.
thanks.
Hi Leila - Amazing tutorial - How can i add a target line to this infographic chart
Excellent tutorial Leila, as always. 👍 Unfortunately, my version of Office 365 does not have the "Stack and Scale with" option. 😞
Very very excellent
@LeilaGharani
6 жыл бұрын
Thank you Zahid. Glad you like it :)
Great
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?
Very well demonstrated! :)
@LeilaGharani
6 жыл бұрын
Glad you like it Rahul :)
@RahulGohrani
6 жыл бұрын
Leila Gharani : Is there anyway we can access SVG Icons even if we are not office 365 subscriber?
@LeilaGharani
6 жыл бұрын
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.
thanks sweet queen you are creative person
@LeilaGharani
6 жыл бұрын
You're very welcome. Thank you for your support.
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?
Hey Leila great video, I have a question, as active in the tab insert the icons
thanks LEILA, Please make videos about different types of infographic charts, like different types of gauge chatrs.
@LeilaGharani
6 жыл бұрын
Ok Ali - It's on my list. Thanks for your support.
Great video! How do I do this running office 2010 or in google sheets?
Hi, Thanks a lot , How I can Insert female or male icons inside cell.
Interesting one - thanks
@LeilaGharani
6 жыл бұрын
You're very welcome Abdul.
@magnusolsson1772
6 жыл бұрын
Abdul Hakeem Montazir Top la conditionqwetjlkknq11
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.
Good
Hi Leila, many thanks for this video. Does this only work as from "office 365"? I now have Excel 2013... Thanks!
Will i be able to do this MS Office Professional Plus 2013 version?
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
6 жыл бұрын
You’re welcome. You can download the spreadsheet - you’ll find the link in the description. You can take the pictures from there.
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
4 жыл бұрын
How I could not found in 2016
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?
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.
Can you also create one that fills from left to right?
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?
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.
You are completely amazing and beautiful!! I love you :-)
@LeilaGharani
6 жыл бұрын
Oh thank you Ricardo! Glad you like it :)
When I stack and scale it doesn't overlap correctly.. how can I fix this?
Dear Leila, I am not able to see the "Series Overlap" option upon right clicking on the chart under "Format Data Series". I am using MS Office 2021. Please help.
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
6 жыл бұрын
Thank you! I have the link to that video in the description of this one. It's called 3 handy excel chart tips.
@ziplesswonder
6 жыл бұрын
Leila Gharani Thank you very much!
@LeilaGharani
6 жыл бұрын
You're welcome.
Dear Leila, I can't find icon insert in Excel 2010. I can find the icon via the web. But I could not change the color and build the line for the icon. Please help.
Just wondering if i can use 2 or 3 value