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.
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.
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.
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.
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
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.
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?
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?
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
As easy as surprising! I had no idea about this utility, it's brilliant. Thank you Mynda.
You are so welcome!
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.
Awesome to hear, Julie!
Very cool, thanks Mynda!
Thanks so much, Chris 😊
Thank you Mynda for the fun info graphics chart.
You are most welcome!
I didn't know that innovative charts is soo easy. Thank you for sharing.
Have fun with them, Pranjal 😊
Enjoyed the simplicity of using basic settings to enhance a standard column stacked chart. "infographic", learnt something new here. Thank you.
Great to hear!
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.
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.
Hi Mynda!Some Super Cool Ideas For Creating Interesting Looking Charts...Thank You :)
Cheers, Darryl 😊
Very nice! Another inspiration. Thumbs up.
Thanks so much, Pavol!
Thanks a lot Mynda. You are Brilliant!
Thanks for your kind words, Eduard!
Great looking charts and elements Mynda! Thanks for showing how to design them. Thumbs up!!
Glad you like them, Wayne!
Thank you again Mynda, really useful information, much appreciated!
Glad it was helpful!
I'm so glad I subscribed to this page 🙏🏽
Great to hear 😊
Never knew this was possible and have been using Excel for over 15 years
Glad I could show you something new :-)
Thanks Mynda! This took out the boring default template that we have in Excel.
Glad it was helpful!
Thank you so much Mynda, for another awesome excel tutorial.
You are most welcome!
Love your videos as always!!
Thanks so much!
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.
Glad you liked it, Faysal!
Love it. Thanks from South Africa!!!
Great to hear, Chris!
Great one Mynda. I love these 👍🏻
Thanks so much, Graham! 😊
Fabulous lesson, Mynda! Thank you.
Glad you enjoyed it!
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
Here's a dashboard tutorial for plan vs actual: ua-cam.com/video/_PlBRWc0RlI/v-deo.html
Woooooooow, great video! Thanks a lot!
So pleased you liked it, Quentin 😊
Pretty cool, nicely done
Thanks so much!
As always, brilliant "how-to"!
Cheers, Dalila!
what a great tip excellent and very very useful
Great to hear
Thanks a lot , your tutorials are very helpful .
Glad you like them!
That's just unbelievable
Glad you liked it, John! Please share it with your co-workers :-)
Another perfect explanation, extremely useful and direct appilcation to my current work
Wow, that's for your kind words, Larry!
@@MyOnlineTrainingHub you deserve high praise...always excellent content and responding...thank you
Such helpful, clear and precise content. Very much appreciated. Side note, the shift trick to draw with locked dimensions is clutch.
Glad you found this helpful, Chris!
Brilliant!!! Thanks
Glad you liked it! 😊
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.
Have you tried SVGs? The Excel Icons are SVG and you can paste them into the charts. They get distorted though, so not ideal.
Its really great and easy to pick！thanks
Glad you like it!
brilliant stuff, thank you
Glad you enjoyed it, Simon!
Thanks for sharing!
My pleasure 😊
This is GENIUS, is it just me that wants to incorporate that into all my spreadsheets now ? 😅
😁 glad you liked it, Mazza!
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?
Thanks, Laurent! I don't think you can do this with Power BI.
Brilliant ...
Cheers, Tyrone!
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?
I worked it out by trial and error!
@@MyOnlineTrainingHub HA! Literally my only way of working!!!!. Thanks Mynda, I'll certainly be giving this a go!
Cheers
Mantab..
Thanks!
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?
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.
Does this work with Pivot Charts, as well?
Hi Sean, it does for a single shape, but stacked shapes wouldn't work.
Like the video, but most of the tips are already shown in other videos. Thanks for your time though
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
Great to hear, Hiruy! Thanks for your thumbnail ideas too 😉
💡👍
Thank you again Mynda, really useful information, much appreciated!
So glad!