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!
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!
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.
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.
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!
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. 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?
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.
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?
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
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.
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.
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.
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.
Download the chart template I use in the video from here 👉 pages.xelplus.com/male-female-file
This Video deserves a thousand mention although it needs an advanced level in information. We wish you more brilliance
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!
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.
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.
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 :)
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!
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 :)
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....
Amazing.... Simply amazing..... You are the best Excel teacher .... Thanks a lot 😀
Awesome!!! Thanks Leila... saved my life.
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!
WOW ! Bring different shade to chart! Amazing, brilliant! I'm your great fan !
Thank you! Glad you like it :)
This is a-ma-zing! Really enjoy your way of teaching!!
Glad you enjoy it Ewelina!
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.
Leila, Great Explanation. Perfect flow if ideas. Many Thanks
Very detail explanation - nice work lady!
Thank you. Glad you like it!
Leila, you are brilliant. Love your videos.
Glad you like the videos Lester :) Thank you for your support.
Thanks for the precise and clear presentation. I am proud of you
Thank you Dawuda. Glad you like the tutorial.
🤩interesting and quickly done. 😉🌹
I love your videos! Please make more of these!!!
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 :)
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!
Great infographic and good idea to use arrows when explaining
Thank you Vida. Glad you like the content & explanation :)
It's very useful thank you Leila..
Awesome as always Leila. Thank you.
You're welcome Monte :)
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 concept and well explained Thank you somuch
You're most welcome
Yet another amazing chart trick. Shukria (Thanks) Leila.
Great Job! Thanks for the awesome insight. Improving daily
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?
Excellent. It was fun trying this.
Excellent explanation. Thanks Leila!
You’re very welcome Kevin :)
Thanks so much needed this for school
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!
That was Awesome!!! Beautiful Staff Thanks :) :)
You're very welcome John :)
thanks for the detailed explanation
I love it!!🤓
Awesome excel skills!. Thanks for sharing!.
You're welcome Jorge & thank you. There's always more to learn though - keeps the fun :)
Very nice tutorial👍
Thank you! Glad you like it :)
Great ... thanks for the lesson
You're very welcome Mohammed.
Great as always!
Thank you :)
Wonderfull!
Glad you like it Alejandro.
Awesome thanks.
Nice trick. Congrats.
Thank you!
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.
thank you Ms. Leila it's a good idea
Thank you Ismail for dropping by :)
Excelente vídeo, gracias por la información.
Neat trick...thanks for the video!
You're welcome Doug :)
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.
That's perfect, thanks Leila! 👍
Thank you very much to made this video :)
You’re very welcome Vikas :)
Thank you very much, I've got it👍
Very nice video
Super awesome
always great
Glad you like it.
Super ❤
beautiful trick
Thank you. Glad you like it.
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!
Very very excellent
Thank you Zahid. Glad you like it :)
Great video! How do I do this running office 2010 or in google sheets?
Excellent tutorial Leila, as always. 👍
Unfortunately, my version of Office 365 does not have the "Stack and Scale with" option. 😞
Love it Thanks Leila !
thanks.
Interesting one - thanks
You're very welcome Abdul.
Abdul Hakeem Montazir
Top la conditionqwetjlkknq11
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?
Please create video on "Hover in Excel"
Thank you, again.
You’re very welcome Peter.
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.
thanks sweet queen you are creative person
You're very welcome. Thank you for your support.
Great
Muito legal Leila, obrigado.
Concordo!
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 was the second like 😂 almost 1st. I love and appreciate ur videos so much.
Thank you Naadiyah :) appreciate the support.
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.
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 ?
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.
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?
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
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.
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.
Waw I love it
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.
Hi Leila, many thanks for this video. Does this only work as from "office 365"? I now have Excel 2013... Thanks!
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.
Hi Leila - Amazing tutorial - How can i add a target line to this infographic chart
Hey Leila great video, I have a question, as active in the tab insert the icons
Great Video. But when I choose overlap, the data shows white not make and female with the correct colours
Hi, Thanks a lot , How I can Insert female or male icons inside cell.
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?
Just wondering if i can use 2 or 3 value
Good
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)
Is the possible to make vedio on power query?
Will i be able to do this MS Office Professional Plus 2013 version?