How to Create a Infographic in Excel (pictogram with icons)
Вставка
- Опубліковано 25 сер 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.c...
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....
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.co...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creato...
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.co...
🎥 RESOURCES I recommend: www.xelplus.co...
🚩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
Download the chart template I use in the video from here 👉 pages.xelplus.com/male-female-file
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.
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
Leila, you're absolutely amazing! The way you explain each detail and step by step. Thank you so much for sharing your knowledge.
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!
I'm glad to hear you find my videos useful Bill. I learn something new about Excel almost every day too.
Guau just... I can't even Express how impressed and thankful I am. You are great.
Hey Leila, your videos gave me a promotion... You make excel fun to use.
Congratulations! I'm really happy to hear that. Watching videos is one thing, but actually implementing what you learn is another. Well done!
stumbled upon your channel yesterday, and fell in love immediately.. thank you for these awesome excel tips!
Thank you! I'm glad you find the tips useful :)
This is incredible!!! I’ve been using icons like crazy in PowerPoint but never thought of this idea!
Glad you like it :)
Great concept and well explained Thank you somuch
You're most welcome
Great infographic and good idea to use arrows when explaining
Thank you Vida. Glad you like the content & explanation :)
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!
Glad it was helpful!
simply superb explanation. i have gone thru many info graphs but this video is simply superb.
Your videos/tutorials do NOT disappoint! I LOVE them all!!!!
Oh thank you, Stacey!
@@LeilaGharani , of course!!! Been home almost 10m on a furlough. Learned a lot of cool stuff :)
Lots of small techniques in one video. I liked the positioning of the label. Always on top. Therefore you need the 100%. Thank you.
You’re welcome Bart. How was the Amsterdam summit?
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.
WOW ! Bring different shade to chart! Amazing, brilliant! I'm your great fan !
Thank you! Glad you like it :)
Awesome!!! Thanks Leila... saved my life.
Amazing.... Simply amazing..... You are the best Excel teacher .... Thanks a lot 😀
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!
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 .
You are so welcome, Abhishek!
Very detail explanation - nice work lady!
Thank you. Glad you like it!
Thanks so much needed this for school
This is a-ma-zing! Really enjoy your way of teaching!!
Glad you enjoy it Ewelina!
Wonderfull!
Glad you like it Alejandro.
Thanks for the precise and clear presentation. I am proud of you
Thank you Dawuda. Glad you like the tutorial.
I love it!!🤓
VERY NICE!!!! Lots of steps but they aren't complicated. I like this.
Great video production, as well.
Thanks Oz - it's still not the newest version of Cam....
It's very useful thank you Leila..
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.
Leila, you are brilliant. Love your videos.
Glad you like the videos Lester :) Thank you for your support.
thanks LEILA, Please make videos about different types of infographic charts, like different types of gauge chatrs.
Ok Ali - It's on my list. Thanks for your support.
Leila, Great Explanation. Perfect flow if ideas. Many 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.
Thank you Anubhav! I'm glad you find the videos useful :)
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.
Awesome Leila, how brilliant you are!
Glad you like it Osama :) Thanks for dropping by.
I love the chart stuff. Awesome video.
Thank you! I love the chart stuff too :)
Please create video on "Hover in Excel"
I love your videos! Please make more of these!!!
Great Job! Thanks for the awesome insight. Improving daily
Yet another amazing chart trick. Shukria (Thanks) Leila.
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!
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?
Awesome as always Leila. Thank you.
You're welcome Monte :)
Just wondering if i can use 2 or 3 value
Great Video. But when I choose overlap, the data shows white not make and female with the correct colours
thanks for the detailed explanation
Excellent explanation. Thanks Leila!
You’re very welcome Kevin :)
Excellent. It was fun trying this.
Excellent tutorial Leila, as always. 👍
Unfortunately, my version of Office 365 does not have the "Stack and Scale with" option. 😞
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?
Excelente vídeo, gracias por la información.
Great video! How do I do this running office 2010 or in google sheets?
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.
That was Awesome!!! Beautiful Staff Thanks :) :)
You're very welcome John :)
always great
Glad you like it.
Super ❤
Great ... thanks for the lesson
You're very welcome Mohammed.
Very nice tutorial👍
Thank you! Glad you like it :)
Super awesome
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
You’re welcome. You can download the spreadsheet - you’ll find the link in the description. You can take the pictures from there.
thank you Ms. Leila it's a good idea
Thank you Ismail for dropping by :)
Awesome excel skills!. Thanks for sharing!.
You're welcome Jorge & thank you. There's always more to learn though - keeps the fun :)
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?
thanks.
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.
How I could not found in 2016
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.
Thank you very much, I've got it👍
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.
Thank you! I have the link to that video in the description of this one. It's called 3 handy excel chart tips.
Leila Gharani Thank you very much!
You're welcome.
Great as always!
Thank you :)
Nice trick. Congrats.
Thank you!
Thank you very much to made this video :)
You’re very welcome Vikas :)
Muito legal Leila, obrigado.
Concordo!
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.
That's perfect, thanks Leila! 👍
beautiful trick
Thank you. Glad you like it.
hi, chart working but fill image size is bigger then other. how to resolve
whenever I click on the "stack and scale with" option, the filled icon gets unfilled all the time, it goes completely blank on the filled image part, Please help on this.
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 ?
Neat trick...thanks for the video!
You're welcome Doug :)
Awesome thanks.
Very well demonstrated! :)
Glad you like it Rahul :)
Leila Gharani : Is there anyway we can access SVG Icons even if we are not office 365 subscriber?
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.
Hi Leila - Amazing tutorial - How can i add a target line to this infographic chart
Doesn't work so good without office 365 icons.. Thanks for the video.
You’re welcome. Everyday Office has a good solution. You can also take the icons I have in the downloadable file.
Someohow series overall not working, what to do?
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?
Hi, Thanks a lot , How I can Insert female or male icons inside cell.
Great
Love it Thanks Leila !
Very nice video
Hey Leila great video, I have a question, as active in the tab insert the icons
Can you also create one that fills from left to right?
thanks sweet queen you are creative person
You're very welcome. Thank you for your support.
How did you create title shape inside the chart?
Very very excellent
Thank you Zahid. Glad you like it :)
Hi Leila, many thanks for this video. Does this only work as from "office 365"? I now have Excel 2013... Thanks!
Interesting one - thanks
You're very welcome Abdul.
Abdul Hakeem Montazir
Top la conditionqwetjlkknq11
Thank you, again.
You’re very welcome Peter.
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?
Hi, thanks for the video. However I do not have office 365 and I have a lower version, can I still do it..
Yes. Just take the icons from the downloadable file (link is in the description - go to blog post and scroll down to download)