As an Excel fanatic AND beekeeper I enjoyed this immensely. I can see me using this for my next Treasurer's Report to my local beekeeping association! I was amused that you referred to the bee as "him" when odds are it's a "her" - the honey bee population is 99% female; males are few and there for one thing only...and it's not producing honey!
This sketched outline is a really cool feature! Thank you for it, and for other ideas attracting readers of my presentations, Mynda. Now, I'm gonna spread butter and honey on bread 😀.
Wow! You get a hive-five! You’ve really created something which deserves a lot of buzz. Usually charts are just drones, but these are bee-utiful. When it comes to putting sting into charts, you are the queen and the rest of us are just wanna-bee workers who bumble around. The way you pollinated that map of Aus with a swarm of honey-combs was terrific. Ah, I’ve gone on too long, waxing poetic…..
Dear Mynda, this was an excellent tutorial where EVERYONE can follow along. Brilliant work. Why are there not teachers like you in the schools, then the youths probably would like to go to lessons. Thank you for sharing your knowledge in such a amazing way.
No way! I was just now watching the video of power query! Thank you so much! You make modern day life bearable. Without you I would've had to be an avid Exceller outside of work to even begin understanding Power query and Pivot tables. This will revolutionize my workload. Know I immediately liked and subscribed. You are no frills; Straight to the point. Wonderful. Your presence is felt, and made an impact on this person's life.
I love your tutorials Mynda. They're always so informative and interested. I've already started to use infographics to display my data in a more interesting format but I didn't know the sketch option existed. Thank you!
@@MyOnlineTrainingHub i am learning alot from your video i did one request from you some days before that pls make one project video in which tools use such as power bi,sql,excel,power query,python etc i will very thankful to you if u make video thanks for read comment☺
wow!.. that is simple and amazing.. for a novice like me.. i definitely enjoyed it and encouraged to creat my informative chart for my audience.. thanx so much..
Dear Mynda The way you present yourself and your content is AMAZING. Whenever I want to learn something new in excel, I type your name next my search on google. Your videos are always spot on. I feel much more confident with my excel skills.
@@MyOnlineTrainingHubNo it's nice of you like you are one of few who is helping me change my life and i really appreciate your effort and dedication 🙏🙏🙏
I'm glad you explained the rationale for using the donut and pie charts because that was one of my first questions :) Thanks for sharing, this is super useful!
Me gustan los vídeos y la información que brindas en importante pero también me ayudaron a dormir más rápido de lo normal, muchas gracias. PD: no tengo problemas para dormir pero me duermo más rápido con lo hermosa que es tu voz .
This video is so much fun and it will be fun to try it and build my own designs, once I get good at it. :) Thank you so much, Mynda, for sharing your great inspirations! Love it!
I've been wanting exactly this for a long time, maybe since I first saw one of your videos and was trying to figure out how to do hand drawn animation but with the lines squiggling to make it more fun and not turn my PC into a series of Process Bottleneck Glitches..
I love this video. Sadly, when I went to use the sketched lines, I could not find them. Of course, had I read the note in the description, I would have known. Oh well. It's a great video, nonetheless. Thank you!
Thank you. Amazing as always. This is the first time I've seen sketched outlines. Is there a trick to accessing them? I can get them for shapes, but not for graphs.
Glad you liked it! Unfortunately, the sketch shapes for charts is no longer available. Apparently there were some bugs they found that would take too much investment to fix, so they disabled it 🥹
Dear Mynda, your videos are really great and helpful! I am trying to build a bubble chart with on the X-axis quarters (eg 2022-Q1), whereby the original data comes with dates (01-02-2022). The Y-values and the bubble sizes are just based on normal numbers. Any suggestion?
Hi Mynda! I was really excited and looking forward to trying to duplicate the charts you created in this video. I'm very disappointed that I won't be able to recreate them due to the absence of the 'sketch' shape outline function. I don't have the option at all, not even for shapes, so does that mean that option is gone completely?
Yes, unfortunately, Microsoft removed this feature for charts as it was causing some bugs that were going to be too costly to fix. I never experienced the bug, so I'm as disappointed as you.
My Excel 365 enterprise edition seems to be missing the sketch option for shape outlines when dealing with charts. It is available if I insert a shape. 😞I was looking forward to duplicating your example! On my Mac, "365 Subscription" the sketched option is visible but grayed out for the charts.
Only with VBA. Might be better to use a map chart if you're expecting the values to change and need the chart to update: www.myonlinetraininghub.com/excel-map-charts
Have you selected a bar, pie, column element in a chart? If you're still stuck, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@@MyOnlineTrainingHub Thank you for your reply, Mynda. I did select the donut element. But under Shape Outline, I only have Weight and Dashes. This only happens to chart. If I insert a shape and select it, the Sketched is available. I googled it and looks like this is a known problem for some Excel 365 users. Hope this will be resolved soon. Thanks again.
Have you selected a bar, pie, column element in a chart? If you're still stuck, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
Apparently some versions of Excel have a bug that's greyed out the sketch menu. If that's the issue with you, then update Excel and that should fix it.
Great Tutorial! I have tried to replicate this with my own data, and can not format my graphs with the sketched line option, even when i downloaded your template it was grayed out. I searched the internet and couldn't find the answer - any suggestions?
@@MyOnlineTrainingHub Thanks for suggesting that, however I am already running the latest Excel365 (2208 15601.20538) and I have read somewhere that the sketch feature is only applicable to shapes however in this tutorial, I can clearly see you doing it! Ill just wait and see what the next update brings. Thankyou.
Have you selected a bar, pie, column element in a chart? If you're still stuck, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@@MyOnlineTrainingHub I have exactly same problem. Opening your Honeybee workbook, it appears sketched. When I select a chart element, I can change the outline thickness and apply a dashed style, but the "sketched" option remains grayed out. Could it be due to Office version? I am on semi-annual enterprise channel, so only on version 2208.
Charts in Excel 2007 were simpler to use; just an example: I tried to add vertical and horizontal gridlines at my own defined values and after almost an hour I gave up; I searched Excel Help and internet and all hints did not match what I saw in menus etc.
Sorry to hear that. Next time you get stuck, feel free to post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
![How to Instantly Improve Your Excel Charts [Watch This!]](http://i.ytimg.com/vi/TqBYfMxVTc4/mqdefault.jpg)
![How to Instantly Improve Your Excel Charts [Watch This!]](/img/tr.png)
As an Excel fanatic AND beekeeper I enjoyed this immensely. I can see me using this for my next Treasurer's Report to my local beekeeping association! I was amused that you referred to the bee as "him" when odds are it's a "her" - the honey bee population is 99% female; males are few and there for one thing only...and it's not producing honey!
Wow, that's awesome to hear! I had no idea bees were mostly female. Girl Power!
This sketched outline is a really cool feature! Thank you for it, and for other ideas attracting readers of my presentations, Mynda. Now, I'm gonna spread butter and honey on bread 😀.
Sounds delicious! 🤤
Wow! You get a hive-five! You’ve really created something which deserves a lot of buzz. Usually charts are just drones, but these are bee-utiful. When it comes to putting sting into charts, you are the queen and the rest of us are just wanna-bee workers who bumble around. The way you pollinated that map of Aus with a swarm of honey-combs was terrific. Ah, I’ve gone on too long, waxing poetic…..
😂 thank you!
I absolutely LOVE this Mynda! It’s great to see hand draw lines back in Excel
Glad you like it!
So impressive Mynda! Had no idea about the 'sketch' setting. We would be lost without you :)
Glad you liked it 😊
Dear Mynda, this was an excellent tutorial where EVERYONE can follow along. Brilliant work. Why are there not teachers like you in the schools, then the youths probably would like to go to lessons. Thank you for sharing your knowledge in such a amazing way.
Wow, thank you! 😁 so pleased you enjoyed it 🙏 it’s just a shame Microsoft removed the sketched line functionality due to some obscure bugs 🤦♀️
My Marketing colleagues are going to love this, Mynda - so much attention to detail and showing us how to do it. Thanks for your all of your fab work.
You are most welcome! 😊
No way! I was just now watching the video of power query! Thank you so much! You make modern day life bearable. Without you I would've had to be an avid Exceller outside of work to even begin understanding Power query and Pivot tables. This will revolutionize my workload. Know I immediately liked and subscribed. You are no frills; Straight to the point. Wonderful. Your presence is felt, and made an impact on this person's life.
Thanks so much for your kind words! Pleased I can help 😊
To set the borders in squiggly lines is really a fun touch. :)
Glad you liked it 🙏
That hexagonal map was crazy. Great video, as always. Thank you!
Thanks so much!
Fabulous tutorial. Thanks Mynda 👍👍🌹🌹😍😍
Thanks so much 🙏
I love your tutorials Mynda. They're always so informative and interested. I've already started to use infographics to display my data in a more interesting format but I didn't know the sketch option existed. Thank you!
So pleased you can make use of it 😊
Very creative. That was fun! Nice job.
Thank you 🤗
Excellent! Thank you for sharing
My pleasure!
your colour designing is outstanding
Thanks so much! I just used the defaults for the colour theme 😉
@@MyOnlineTrainingHub i am learning alot from your video i did one request from you some days before that pls make one project video in which tools use such as power bi,sql,excel,power query,python etc i will very thankful to you if u make video thanks for read comment☺
Thank you for all your videos. I have learnt a lot and am still. Lots of love and keep these videos coming 🙂
Thank you! Will do!
I've learned a lot in this lesson! Thank you so much!
I'm so glad!
wow!.. that is simple and amazing.. for a novice like me.. i definitely enjoyed it and encouraged to creat my informative chart for my audience.. thanx so much..
Awesome to hear!
This is simply a fabulous piece of art. Your video are always a Great Value to Excel users. 👏👏👏👍
Thank you so much 😀
Loved this one. Greetings from South Africa.
Thanks so much, Chris!
Dear Mynda
The way you present yourself and your content is AMAZING.
Whenever I want to learn something new in excel, I type your name next my search on google. Your videos are always spot on.
I feel much more confident with my excel skills.
Wow, thank you so much for your kind words and support! 🥰
What a wonderful infographic. Informative but interesting to create. Thanks Mynda 👍🐝
Thanks so much 😊
It was very easy to create and understand
This is so awesome! Thank you Mynda!
So pleased you like it 😊
Talk about inspiring! I will use this approach on a coffee infographic I need to develop. Thanks!
Wonderful to hear!
Your expertise and skill with Excel is amazing, Mynda. Thanks for such an informative presentation!! (As always!)
Thanks so much, Steve!
Nice one again. I really like the sketch look.
Thanks. Me too. Unfortunately, Microsoft found some bugs with it and it's no longer available for charts 😞
Nice Video and good teaching ,thank you so much.
Glad you liked it!
Fantastic Mynda!
Cheers, Chris! 🙏
That was really fun 👍😎✊
Great to hear 😁
That was a pleasure to watch.
Glad you enjoyed it 😊
One word WOW 🙂 Thank you so much for sharing 🤗
My pleasure!
Thanks! It really open my mind in the chart design!
Great to hear!
Love the improvement in the quality of the videos and the great content as always
Appreciate it!
Thank you very much for such amazing tricks in this video
Most welcome 😊
Awesome. Thanks for sharing.
My pleasure 🙏
excelent tips, and I absolutely love your voice :)
Thank you so much!
Great charts and infographics!
Glad you like them!
Well done! This is a really fun change to tired charts.
Glad you liked them!
Amazing - thank you!
So glad you liked it!
Very beautiful. Especial like for a bee participating a meeting on a table😄😄
Thank you so much 😀
You? - More beautiful than flowers, more sweet than honey, Video? - Fantastic!!! Bee-licious!!! Zilla Slab and sketchy lines is sooooooo cool!!!!
😁glad you liked it!
You are a legend dear 🙏🙏🙏
So nice of you 🙏
@@MyOnlineTrainingHubNo it's nice of you like you are one of few who is helping me change my life and i really appreciate your effort and dedication 🙏🙏🙏
I love this! So creative! I also just learned about the copy and paste format for the charts. What a time saver for me! Thank you. 🐝
You are most welcome! Check out this chart formatting tips tutorial: ua-cam.com/video/46CGcyP4dbo/v-deo.html
Thank you for sharing with us
keep going
Hello from morocco
Thanks for watching!
like your "labour of love" ! 💗
Thanks so much!
I'm glad you explained the rationale for using the donut and pie charts because that was one of my first questions :) Thanks for sharing, this is super useful!
My pleasure 😊
Me gustan los vídeos y la información que brindas en importante pero también me ayudaron a dormir más rápido de lo normal, muchas gracias.
PD: no tengo problemas para dormir pero me duermo más rápido con lo hermosa que es tu voz .
😁glad to be of service!
@@MyOnlineTrainingHub Thanks 😚
Great lesson 👍
Thanks! 😃
Nice job !
Thanks so much!
This video is so much fun and it will be fun to try it and build my own designs, once I get good at it. :) Thank you so much, Mynda, for sharing your great inspirations! Love it!
You are so welcome!
I've been wanting exactly this for a long time, maybe since I first saw one of your videos and was trying to figure out how to do hand drawn animation but with the lines squiggling to make it more fun and not turn my PC into a series of Process Bottleneck Glitches..
Great to hear you can make use of it, Hector!
Why you are this good? ❤
So pleased you liked my video 😊🙏
Woooooooow!!! Love It!!! 🤩
Thank you! 😊
I love this video. Sadly, when I went to use the sketched lines, I could not find them. Of course, had I read the note in the description, I would have known. Oh well. It's a great video, nonetheless. Thank you!
Thank you! Yes, it's a shame they removed that option 😢
As always, Pice of art 😘
Glad you liked it 🙏
Wow, love it!
Great to hear! 🙏
Hi Myndra, which Excel version do I need to be able to access these formats? Shape outline=Sketched is not available to me.
I’m using Microsoft 365.
So much fun 😊
Great to hear!
Very cool!
Thank you 😊
❤ Excel & Mynda
Thank you!
Thank you. Amazing as always.
This is the first time I've seen sketched outlines. Is there a trick to accessing them? I can get them for shapes, but not for graphs.
Glad you liked it! Unfortunately, the sketch shapes for charts is no longer available. Apparently there were some bugs they found that would take too much investment to fix, so they disabled it 🥹
@@MyOnlineTrainingHub oh, shame. Thanks for the quick response.
Love it!
So glad! 🙏
Thank you
My pleasure!
Dear Mynda, your videos are really great and helpful! I am trying to build a bubble chart with on the X-axis quarters (eg 2022-Q1), whereby the original data comes with dates (01-02-2022). The Y-values and the bubble sizes are just based on normal numbers. Any suggestion?
Bubble charts require 3 values, x axis, y axis and bubble size. Sounds like you only have 2 values.
Hi Mynda! I was really excited and looking forward to trying to duplicate the charts you created in this video. I'm very disappointed that I won't be able to recreate them due to the absence of the 'sketch' shape outline function. I don't have the option at all, not even for shapes, so does that mean that option is gone completely?
Yes, unfortunately, Microsoft removed this feature for charts as it was causing some bugs that were going to be too costly to fix. I never experienced the bug, so I'm as disappointed as you.
My Excel 365 enterprise edition seems to be missing the sketch option for shape outlines when dealing with charts. It is available if I insert a shape. 😞I was looking forward to duplicating your example! On my Mac, "365 Subscription" the sketched option is visible but grayed out for the charts.
Unfortunately, Microsoft found some bugs with the sketch feature for charts and so it has been removed and there are no plans to bring it back 😞
Intéressant le nid d'abeille, peut-on automatiser son remplissage couleur en fonction d'une valeur? MERCI
Only with VBA. Might be better to use a map chart if you're expecting the values to change and need the chart to update: www.myonlinetraininghub.com/excel-map-charts
Excellent tutorial. Thank you. The sketched option in my Excel 365 is greyed out. Any idea how I can fix this?
Have you selected a bar, pie, column element in a chart? If you're still stuck, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@@MyOnlineTrainingHub Thank you for your reply, Mynda. I did select the donut element. But under Shape Outline, I only have Weight and Dashes. This only happens to chart. If I insert a shape and select it, the Sketched is available. I googled it and looks like this is a known problem for some Excel 365 users. Hope this will be resolved soon. Thanks again.
Ah, maybe update Excel to see if you can get the fix through.
This is great! But my Excel has the 'sketched' option greyed out. Any ideas?
Have you selected a bar, pie, column element in a chart? If you're still stuck, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@MyOnlineTrainingHub how can i use sketched effect to the outlines of the graphics? It's not available to me, is there any tips?
Apparently some versions of Excel have a bug that's greyed out the sketch menu. If that's the issue with you, then update Excel and that should fix it.
you ar wunderfullllllllll
Glad you enjoyed it!
Nice
Thanks 😊
Great Tutorial! I have tried to replicate this with my own data, and can not format my graphs with the sketched line option, even when i downloaded your template it was grayed out. I searched the internet and couldn't find the answer - any suggestions?
Thank you! Update Excel. There is a bug in some versions of Excel that's greying out the sketched effect.
@@MyOnlineTrainingHub Thanks for suggesting that, however I am already running the latest Excel365 (2208 15601.20538) and I have read somewhere that the sketch feature is only applicable to shapes however in this tutorial, I can clearly see you doing it!
Ill just wait and see what the next update brings. Thankyou.
I was told by Microsoft today that unfortunately, sketched effects have been removed from charts due to some issues they found. 😞
@@MyOnlineTrainingHub NOOOOOO!!!!
That was my response too 😭
The "Sketch" option is grayed out on my computer. How do I apply it to my charts?
Have you selected a bar, pie, column element in a chart? If you're still stuck, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@@MyOnlineTrainingHub I have exactly same problem. Opening your Honeybee workbook, it appears sketched. When I select a chart element, I can change the outline thickness and apply a dashed style, but the "sketched" option remains grayed out. Could it be due to Office version? I am on semi-annual enterprise channel, so only on version 2208.
Apparently it's a known bug in some builds of 365. Try updating Excel to get the fix through.
Dear Ma'am
As a request, please excel dashboard on the construction level with activity vise
Please see my Excel Dashboards playlist: ua-cam.com/video/K74_FNnlIF8/v-deo.html
Bee on the desk.🐝
😁 Glad you liked it!
👍👍👍👍👍
Glad you liked it! 🙏
🧡
Glad you liked it 😊
Excel charts in Office 365 are crap, so difficult to use.
I'm interested in what you find difficult. Unfortunately, charts in Excel haven't changed since 2016 😞
Charts in Excel 2007 were simpler to use; just an example: I tried to add vertical and horizontal gridlines at my own defined values and after almost an hour I gave up; I searched Excel Help and internet and all hints did not match what I saw in menus etc.
Sorry to hear that. Next time you get stuck, feel free to post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
thank you, I will
🤎🧡💛🐝💪👍
Thank you!