Wow, this came at such the right time Mynda. A client just yesterday asked for some "infographic" style graphs in a deliverable....Can't wait to try these out.
@MyOnlineTrainingHub2 жыл бұрын
Awesome to hear, Julie!
@ricardogutierrezdiez91702 жыл бұрын
As easy as surprising! I had no idea about this utility, it's brilliant. Thank you Mynda.
@MyOnlineTrainingHub2 жыл бұрын
You are so welcome!
@leksdic2 жыл бұрын
There is an option at the filling format of the graph that pops only when you use a picture or texture fill, that it is called "Stack and scale with" which removes the distortion effect. This trick and the option of "Stack and scale with" works with icons too. Using male and female icons to show gender ratio in my company is one of my favorite. Especially when i use an only outlined icon to show 100% and a filled icon to show up to which point it is filled. Great tricks. Thank you for sharing them and making them more popular.
@MyOnlineTrainingHub2 жыл бұрын
Thanks for sharing, Alex. The stack or stack and scale with doesn't work so well with shapes in the examples I've shown in this video where you want the top of the chart to all show the same shape.
@c.s.m.k5737 Жыл бұрын
Enjoyed the simplicity of using basic settings to enhance a standard column stacked chart. "infographic", learnt something new here. Thank you.
@MyOnlineTrainingHub Жыл бұрын
Great to hear!
@pranjalmathur49682 жыл бұрын
I didn't know that innovative charts is soo easy. Thank you for sharing.
@MyOnlineTrainingHub2 жыл бұрын
Have fun with them, Pranjal 😊
@nsanch01812 жыл бұрын
Thank you Mynda for the fun info graphics chart.
@MyOnlineTrainingHub2 жыл бұрын
You are most welcome!
@adabekee49642 жыл бұрын
I'm so glad I subscribed to this page 🙏🏽
@MyOnlineTrainingHub2 жыл бұрын
Great to hear 😊
@FaysalEasyExcel2 жыл бұрын
thanks a lot Mynda :D. It's completely new designing idea for me. I've already designed 60+ Excel infographic charts made with autoshapes and editing chart elements. many thanks for your tutorials.
@MyOnlineTrainingHub2 жыл бұрын
Glad you liked it, Faysal!
@nick1209682 жыл бұрын
Thank you again Mynda, really useful information, much appreciated!
@MyOnlineTrainingHub2 жыл бұрын
Glad it was helpful!
@chiquita6832 жыл бұрын
Never knew this was possible and have been using Excel for over 15 years
@MyOnlineTrainingHub2 жыл бұрын
Glad I could show you something new :-)
@wayneedmondson10652 жыл бұрын
Great looking charts and elements Mynda! Thanks for showing how to design them. Thumbs up!!
@MyOnlineTrainingHub2 жыл бұрын
Glad you like them, Wayne!
@esthercraft2 жыл бұрын
love this video, could you do more videos on dashboards design tips, and dashboard practices for management accounting dashboards eg: different ideas for actual vs forecasts and best practise how to update the data table that has to keep on being updated month on month
@MyOnlineTrainingHub2 жыл бұрын
Here's a dashboard tutorial for plan vs actual: kzbin.info/www/bejne/lYHPc4WNmJWFoqs
@hafizgeain77022 жыл бұрын
Thanks Mynda! This took out the boring default template that we have in Excel.
@MyOnlineTrainingHub2 жыл бұрын
Glad it was helpful!
@EduardKorkia2 жыл бұрын
Thanks a lot Mynda. You are Brilliant!
@MyOnlineTrainingHub2 жыл бұрын
Thanks for your kind words, Eduard!
@darrylmorgan2 жыл бұрын
Hi Mynda!Some Super Cool Ideas For Creating Interesting Looking Charts...Thank You :)
@MyOnlineTrainingHub2 жыл бұрын
Cheers, Darryl 😊
@shiffamohammed58182 жыл бұрын
Thank you so much Mynda, for another awesome excel tutorial.
@MyOnlineTrainingHub2 жыл бұрын
You are most welcome!
@chrisg7582 жыл бұрын
Such helpful, clear and precise content. Very much appreciated. Side note, the shift trick to draw with locked dimensions is clutch.
@MyOnlineTrainingHub2 жыл бұрын
Glad you found this helpful, Chris!
@adeoladosunmu16022 жыл бұрын
Thanks for sharing!
@MyOnlineTrainingHub2 жыл бұрын
My pleasure 😊
@srilakshmisubramanyam12922 жыл бұрын
Love your videos as always!!
@MyOnlineTrainingHub2 жыл бұрын
Thanks so much!
@simonmassen2 жыл бұрын
brilliant stuff, thank you
@MyOnlineTrainingHub2 жыл бұрын
Glad you enjoyed it, Simon!
@adriabd2 жыл бұрын
Thanks a lot , your tutorials are very helpful .
@MyOnlineTrainingHub2 жыл бұрын
Glad you like them!
@ExcelWithChris2 жыл бұрын
Love it. Thanks from South Africa!!!
@MyOnlineTrainingHub2 жыл бұрын
Great to hear, Chris!
@lchase78582 жыл бұрын
Another perfect explanation, extremely useful and direct appilcation to my current work
@MyOnlineTrainingHub2 жыл бұрын
Wow, that's for your kind words, Larry!
@lchase78582 жыл бұрын
@@MyOnlineTrainingHub you deserve high praise...always excellent content and responding...thank you
@daliladuf2 жыл бұрын
As always, brilliant "how-to"!
@MyOnlineTrainingHub2 жыл бұрын
Cheers, Dalila!
@mefityoufit2 жыл бұрын
Fabulous lesson, Mynda! Thank you.
@MyOnlineTrainingHub2 жыл бұрын
Glad you enjoyed it!
@grahamparker77292 жыл бұрын
Great one Mynda. I love these 👍🏻
@MyOnlineTrainingHub2 жыл бұрын
Thanks so much, Graham! 😊
@StephenBoothUK2 жыл бұрын
One of the things I requested via UserVoice for Excel is the ability to use more than just the default shape types. I’d like to be able to insert an SVG and use that. So, for example if I’m doing a chart if people related data then if I have an SVG of a person I can use that for my columns.
@MyOnlineTrainingHub2 жыл бұрын
Have you tried SVGs? The Excel Icons are SVG and you can paste them into the charts. They get distorted though, so not ideal.
@johnmeijer12462 жыл бұрын
That's just unbelievable
@MyOnlineTrainingHub2 жыл бұрын
Glad you liked it, John! Please share it with your co-workers :-)
@chrism90372 жыл бұрын
Very cool, thanks Mynda!
@MyOnlineTrainingHub2 жыл бұрын
Thanks so much, Chris 😊
@pavol.cernak2 жыл бұрын
Very nice! Another inspiration. Thumbs up.
@MyOnlineTrainingHub2 жыл бұрын
Thanks so much, Pavol!
@mdexcelpro84952 жыл бұрын
what a great tip excellent and very very useful
@MyOnlineTrainingHub2 жыл бұрын
Great to hear
@YahooMail2862 жыл бұрын
Its really great and easy to pick!thanks
@MyOnlineTrainingHub2 жыл бұрын
Glad you like it!
@Mazza-hz1zf2 жыл бұрын
This is GENIUS, is it just me that wants to incorporate that into all my spreadsheets now ? 😅
@MyOnlineTrainingHub2 жыл бұрын
😁 glad you liked it, Mazza!
@quentinbricard2 жыл бұрын
Woooooooow, great video! Thanks a lot!
@MyOnlineTrainingHub2 жыл бұрын
So pleased you liked it, Quentin 😊
@wisid2 жыл бұрын
Pretty cool, nicely done
@MyOnlineTrainingHub2 жыл бұрын
Thanks so much!
@wodibalanakassoukpala24722 жыл бұрын
Brilliant!!! Thanks
@MyOnlineTrainingHub2 жыл бұрын
Glad you liked it! 😊
@nick1209682 жыл бұрын
Sorry Mynda, quick question. When entering the circle, you said tha you knew that it needed to be 15. If you were a lesser mortal, such as myself, how would you work out what it needed to be?
@MyOnlineTrainingHub2 жыл бұрын
I worked it out by trial and error!
@nick1209682 жыл бұрын
@@MyOnlineTrainingHub HA! Literally my only way of working!!!!. Thanks Mynda, I'll certainly be giving this a go!
@Laurentmahe2 жыл бұрын
this is so easy yet so slick! Thanks for sharing Mynda. I don't suppose we can achieve something similar in Power BI, can we?
@MyOnlineTrainingHub2 жыл бұрын
Thanks, Laurent! I don't think you can do this with Power BI.
@imamdianjalanjalan282 жыл бұрын
Mantab..
@MyOnlineTrainingHub2 жыл бұрын
Thanks!
@furtim12 жыл бұрын
Cheers
@debanshusharma69182 жыл бұрын
Like the video, but most of the tips are already shown in other videos. Thanks for your time though
@tyrone59492 жыл бұрын
Brilliant ...
@MyOnlineTrainingHub2 жыл бұрын
Cheers, Tyrone!
@777kiya2 жыл бұрын
It's helpful. I never thought of your ways around graphs, like using Ctrl+1 for graphs and the copy and paste. Thank you P.S. Can't you make your thumbnails a little more attractive, little more different each time, even with the zoom? A lot of people can learn from you if they click to your videos and the thumbnails help for that. Thank you
@MyOnlineTrainingHub2 жыл бұрын
Great to hear, Hiruy! Thanks for your thumbnail ideas too 😉
@sirewan2 жыл бұрын
Very nice! However, when I repeated all the steps I get a little white line separating the bottom and top. I played with the outlines but could not get rid of it... Any advice?
@MyOnlineTrainingHub2 жыл бұрын
I suspect the white line is around the shape prior to inserting in the chart but it's not visible on the white background of the Excel grid.
@seanmurphy40772 жыл бұрын
Does this work with Pivot Charts, as well?
@MyOnlineTrainingHub2 жыл бұрын
Hi Sean, it does for a single shape, but stacked shapes wouldn't work.
@ivicai32812 жыл бұрын
💡👍
@DiamondRock22 жыл бұрын
Thank you again Mynda, really useful information, much appreciated!