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

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.

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

🚩Let’s connect on social:

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

[abdelhafidassadiki]

This Video deserves a thousand mention although it needs an advanced level in information. We wish you more brilliance

[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

[apsellynch]

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

[billhart]

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!

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

[staceythienel]

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

[Traveller_Mood_On]

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

[learnspreadsheets]

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

[jazRock]

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

[Teacherman]

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!

[Youtuberyoutuberyou]

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!

[vida]

Great infographic and good idea to use arrows when explaining

[kb]

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

[velmuruganr]

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

[rahulpathare]

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

[georgeomondi]

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

[justdoit]

Very detail explanation - nice work lady!

[gomac]

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.

[barttitulaerexcelbart]

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